oySnkzvU6ahnSvGvtENio5BhdEaLyWSCdI3Q3bWW1i3UNtpUtZZXS2/bkfjysPifJbC4FUr0Bv0VU37hEpEOSJY0o0ouu5NakFnWEaSasHJ5zPl0Cluu4EAAoeQtIsObXgUrGq58/yOCE+tq/qtPykhsskzT4HyqJlswk5rP16nDJXsrXYlEbRxYpd/v+NxdIW6C4JWDRX9Zvj8dShXngfOtcnBBDmQu/7zNUp8anCKy40/A7DNO840xqKRuJWCjfU0HuJ61Kq+JsrZONmpbqGAkrzxNOrHekjFCft3C9E4VD430Umr7VDfmSmJRtrdr/hEgivhxHdBuVIAsc/y8W+N+JcaDmcL/fLUjX6qKmXBSpD5Epzj3cn16OEKpYjVuUEZTQpimmdXPXf+EleGTsg8weQfQ2QOqPaDGpKUNQmcuJeu471gfuDQS0/T0aMbZkQtZxPYwwIxNzC2rkELKOw9O/BMKgwF0+6vXE4ppQAt30xiZ5b3cnx5sTx/LurmGA3fsUzu99nB20BymYJUCHN8qyovuVzIkfH+YxIXfRmNW+AT2Ia0JZ5NuqnrCLuOdrX50M7U8ZX5K6trQswBJzemC7BM0k8aG2IKZKQJpKaFOPu76PUcY4YJipIpThegIQ6g6+WIFjPtL8gXmGUI/1g3n10vQ28UtbSoExsQ0yss+v/QN4cZlVf+/9iiOuEhuu5uqaUG+09BwdNc0CAyU+6y7/2P5+J5On+Wfl1TIOZqWEi7zt12foUX6NsB7NXtBq2QV/UbcLLdHbszd4sa8EayYDEwEgxNbREaGMQpakrAivg+SRWDQFTzFksJdkIfxM9qq5xg69zUpGqQTYDBoy8HRN2Jt7ElBKkD2RDM9t8LHyhi85L4u8b8BPZvmKV0hkBbyg7kQ4017rJCtiHh5dTEOh/1RAxXy9IE7gX9ewAX7nhbzMKKC+MMUm5svvP3cWtnYVuU0f1oPar/T7KM/rFSA8XBMO6KgW8XecBWA5w0Aar+Yj6CmqUtv9UPT5pQqXLps6O/QJaStzO8BsZ8Zu7JL9pVFHdZhTffLH+huGXo56sCCv0Dk9Qo7luR06B+08ro0/1n9sndOVCV31moIU62BoCoSSHaRpNWPfKvpkwct312Prx21iGJTmZ6RIqrcyPxftsnQZtLlz2J2efsi4Dzx9ZQGKk24FJ9audrn19ayrdKVnev7eYM3RoIHOVtOoHdMiakRnCbPc8HwxMm1xEkOU+/BkT1B4mvzHRmTYKd9IYX7daygo9D/NQi3g6h3B92GNSUmLClVqmNGy1suPcZBlT0OUYRJaGRe8/MLBAyYJmUyTzak3H6cuTOrHg/OOoymma8bJN0zgkm87s+FGAhmEhj/AMAkVlaKgTw=
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