GDd9kMtPeFVh8ZDO0JtGbA9yXDhAtodVeERItcHFKipKLTt7MLF687VwwtbMjUxMDY6NTVK/pDXUZFqfDhRGZ+oWZsgSO9KR6Jl4fu0UEgMHeHoAi4RYTuy8P3QU20XjNuoMxGLdJBpYX2+8UNvXg72R++A8MUBc7RktvwStV0eh+h7/kr9NJkhJ4kEgCrN8ClSb08p81gtyjPiZTSzqQT6iZIVoyk4KKspVQSgUTbhWxUaeYvN+Q39hTNYfIPYTjX2LY7qTSkulFB4IOAv0eklzKth+yP8/wytnH9U8BCGUn7beUgja9sN4EwZ35QEdWyTw6JvswAEmvpoYFuRTjzwjuPflM5HHIXy78gO8e6Z0i4S7PFpDt7Oq27vlF7HjQt7ihcBpq957PbEEoAJEhfoAlRuFdKjY8gqOD+01WcZbLMjIug/0mCYBXs6VgRhYBSO3jwDm0MhzMI9zrqa+hthxaNzV8mHfhK4vLIx3GJeIPgQ4MGJXtEdx/NdKypbEPajLvY8A2cPEIMCUZz1bOep3obKUT9GoD1GX1M9OQ0Se2bUUk9Iuf7jTi0aL5RF0jz6fyx/7AWyjYdA83iQMK7JeZFcjbB9EqDUvNiROJFE/gLTSCQ3rAdJFt7vtMm2wO9KnbP9dxKuTlLr7soUHpJ8TzkNmSe1sOXLumwoQSNI2EI2IP882zFd9hlTZHfj6ApF0VHct5E1tExqHFSj5Y0ZMRZysAsW3O9HhWPNUohYtcvQg4Qanbyeo5EzGTCkaqGRRX1u0ZmVC3Z5kURVVyCEtyiHcitTGKL0qbmaArv9HZrgAP/ayT18UjHXI4OeBZsV8YSpEojOhYIfjOCXCB2oA7ujNJ9128i6astHKo5ootColJeejPYUDv+J2wSLYNbHsFjyqeWsm+NjQEbXx9NecS9mm+XOw99XzQWJLLNRNIpJbApASIoGDOlIjyuINFEkFqeyR25nvH/1EYRcV0tmWJOcxrXZEVE2pYk2T+uU6pw+bJLefS6elSUK4+XPoI7b5Y9KPATgD+r42/N661AGgRuJrpUMRnQdaMSR8qG7FLxHbsjS9tc3Z6VGswAjGwTCz23PlogM5xYg/mkhVZGAHnk2I6pvUSodp6Eyv1FFP/Y1JQrMhKPAe8lARBQ0wodCBYADuTG9xs/l8SSy5Xjp2wpDesPQLv1ujIBJO7gwHr0bAh32nlYHE1gwt1x5qgPb67kkbsf1VHDuBW8wgrRzvDKyHkS63XVCWxdD3yDNi+gPntvujA7nKBBFNOIMsLnj9qn0Qy7UK2zQh/x6HJIywPlXwLlk2AbPVcNEgWWRs0hfWNeoQAVhtHaZ+uIUriG2KDyQ+R1s5Fugnol+Iv5b0OCcYaa/g4VWLJdU=
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