ZCcwSWb59a4HBiUHd0vTmB0FatUeNveK5Nu8giGH4uvojZNsg60VPKTP+ue6L6HfIJYtS577hRLB5KpQV9ZssRBg32y2ZF1+S4Guk925vaW3/UX41FpdP/JOnp3FfjXbzAjczePA6avBUd99M3VVX3FoA6HgDBnJeV2pgxxs6yIDrRNIILI0zC+uJyaSM91YI6Y5/Qe3LUP+m0lRb+6IBnCSHF7D81iR7blQYRAnXLMQ2gaAqykvPyb220aWpoKOueV2lEJTziv8CEMMWeyqO6VX1plyRvceIabU1dlaOieDXyKdouKWY13SdGAZfUwV8WhU4N0iroKr2i99kqRUnJH1lDhKVtFdDyXZ019bn+gEcoqR6wlULqnzyuvMozhgnSYNj8CJdidK5wrepgnhEmKfZUUx3+iUkka9+ukZJ1uisNyQIGbhlFQBhsBCB9ViPP5y+TYKgtNEl6/CH7jLViSFlL06kaoXtfcRKrmZsNJBcPNvwUFJ+B7ib7t3Rx1Ou4NmBptT7isQBABPQhHCtx2Ae3FJGV0unaRZXcdWXFGRm7QSmdKh2K0cyZSnkAUIngi4BqhBm6zifYx0Uv5znNpVA0072F635GUuyGcfngK8OTqEbynZzXug71aIgtNR4Asve1UG46UwCIdAIewt+dt6F22iefJx4TvKhmt+Niu8sjO18adIr4Fn83ztwGjKgUKQ9XFOVo9tgCo83Yo6mrTYPEY6njSUBMSv75RCRN4ZzFo3qvLeUOVu6RWxq3buCtkDSr9/8FKNlQtVvn5tW2O8EVqGKk4kSPcGsM0yIfmWoml55qeXXDa7LKVZ3wiaFIG3DwNR9eN1f8nPStozcwG1YbvigqZLPNCOQhWVu4UP2hr21XILuZKrnbhxrH3aixveK0whKUx9geOid5H+vqENuHgbRgqSHb+x45UuQ10Tg56BH/tl8v+Wt7dRlDEUTQ1qOuo3gF/pjzvi/QxfzzsvE/Whw1EewsSDQOshr4WJLsMAVoZBa0Xt7COWMtPoPFvTN2iyS/mVlpsiLkjRhoFXH4fjfPZvRXUpZ2ZcxX79DxW48js/Eg0BgHjHfR+gxyfVrNOR8IzXMlPJfQxd8uqcdLBi5wSnTey6dx1bc1AmcvZHAe181s9TMmMKw/2okPi6AJI0GyFHgWXzXHzYeqoTF8vatrZp/6c0AQAH2F9VuUJLM8bKB2oCYh4K4PuxoPJwfIsW7j3UNFCh3WKCcWe9zLdUnPzl9GLN0Wv8Q3jZcM57PvEVApDdAjy5VCwpTOffz7Mqkuq5ZTCvaH/psABPQGiqqRTiHYkZdEs0RVyb65SWLAi+CYQcjJ+WnFEPlA01FFSz6O9d+aqOOqWOiNAtAynHn7I5YydfBIQ=
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