pAcBBOG9Hp+v885/bJHrYOJZPnWH45j587G6yk/+/0U/kHrwL7S5hizbgkcoWFM0bdYw9Z/jO1PBGmMbA39hmSGNcB11HkGSX00Kf6Z0gXxE12vAJbdtu/HlUqWeXu5dPPec+7vv+/u+8kN8FFmwJCNBAbcPLuzjOCfdFLL278Hd3J5sZWaoKEnkm4ngwfmy/RiHvyYNSoE8C1djR0jANrmSe+WmXC9mPyCN/2C9Y2Wp6cP8pDX4d1Wp6ZCb4hnz/YradPrgAG4NBQrbFLm36DSHbJ6er+vz6/ZS5eVA9tvTm2HkcQC5KUi0W1lrQEbRrCKvDq5bszeDeDzyML5XaUl5E34vpl0bWtcA0FvGD7Som6yBBsi54Jwj38t0dx9+exerwf3S8BttUqI7utGf8pE8VF3EFsqX4hT+oIobx07fZaPBJVBjyedE2GEREj7LPTFezDE2STHEoS4T72mCdxUk8xuntDAXwphWAYgC2+EnZaRm45aS+PbPBnLoBG1Rd6dFIUrx4PUJy5ZDXJ5eFh0NbH4eqEbCLLttw0Ab7EJTUWxJuqo91YLjEARLcmFekDLA/gmy6uGp2BxGbKANQeMoaMsG1imVea93cMvh8t2LYUtk1g9xiuXVQcv6ABPl9DMeveA2ylVJ7VginAjfzCgg2EPkB7MJkRMi+FZ24OSPS2BSaL1lVif3MW19TCmladXa0eQP0u61UleNdZNVAxE17ncxYBgBaR0vN9NfzRmtNr3GDrAN7CXEYRvrvkRoZw47e7+0sCWilp9tETdyhJwpbte28LvdvCVsqcwueY9J/aw0xKLCKq9Arr8ANCfY/NDgouP0eoaj1+GFd1nVKdiLp3hIygKrimh24GkPU1BbZSrrf6cEZpV4j7gXaxe7EwPh8YeGYIlVsqlh/LnnBx5Ui6s8Enj3Sa3RenKMmqgCCvC4yer4eLDQXTzGZXSAXRjH7wkV4aE7O3j55R0cUcE5Re3oyewNL1KvME+jbnCUqyJa6D4Ys5mNXRnSEdEsLgcblw0nkXprGQv6EB2lqU0xwIpS6vdAgjfpPxL93DJ+/wS7jOUZW/e7i/1d+ffLpm7IOgVqUhbnhPIJky1XQvpT6gjG739zfQBAWa+j1fRoL2IoczuO4FngLPpvqMMQpOWEqyN9DmBqTZLUNBGtTLLYBj/KXIrMSSPPnSV2JR0xyRoV6OavfSY7iA6GBjcUcnQF4BeQi5fLeq5MEqByCyoJSjxDhQ0AFBsFdh8aFU2nAG5F76K9XZ380rSWF7Vh5qC95E19iaUFy1au+WQr8hZXdbO4cQ/B2g0c9YoiS1vnV/FPC+d7VWRXkFmdUJVgU85gv4mVjKaD22oObOGTXj/LLM6XNI7hXuK6p5U=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100