EgY6ebkmudSbplhDEltI22DqRYTiIZ7tXveGtiz7hZBzhACJ3BHR2VKROzXs2rgYqGCH0LKVbpQr/pM5lKGpunjUvK59KXTlefF3EoJF2wsRPV1OoM3H9ep6RqLEQfhUYZKK/3C9nUBz4OJ2DagiORzGtIzbuX4LHlkn4M1yxWgPICRCo+COkKULSsTW2b5SmI9m9fCnL7iRXmJ+/lLvM74J9NZHPMVte8yNtD1t1bRtZ/+iXVZltm/GX6lsMsFUjK3qVHBWxJtPwMfKZEB0/stWDytHhxBdBi8padZyvyR5cPCcXQ8DRa/hy2GY2Hb6f2seCxMbSrMNmLGgIyWnh9xZAjQ5DyoFtvtCnGKz1emD1tVECgSuLAnc4tTntNobobmDFKmZ6XoOtcu6fvFHC5a/niLkrtCmiic+ii/SSKwmKzETB275O/XwidAK5H+x5tpeZJbwnlGqFC+Mh1N6rPshB4wRi83vpCbMvV9xEENxNoDmBjfAdPxGpAJdEywok43UVWtKlZ9oSXmejxAwNWFCI0QacaCvRRYljjvjeXQef1qFrQNz4WDDQjPD11pYvyIqZ3e/bDdnzZBLk2vcaSywiKN0IvHhi8D6w5zuFhNWi9eDXtsuNAkm2J32YgU2u50JC/SdUeR2zc0W8sDeqSROh+qIIyOyKr7fy7wi77xhDbyrO0kB+VeVkIASyP9oRuCvoU++h4/njrorki62Sk6shaHjT7EXeMRS4UvAmscV5vOAeevYB/wPaxF2C2SVbqgJdD6Fh8reVs2aALTySQmRTuLNRoYMChaPL9QqqyEGM/GI3Yghrd1LIO6NLgnwD2fU0najO3c+STP/Fpvnpu8LB0IKDAy8Bdrz1c2Sho3R7VhM8qvRmFwdmKu0MZF11Vi/Am7XcmlmvMiKykFhCQS9CzyryzZkt0nR71vmmWUz/4vezx5c76DpLrl58ji4cjvFLfFbvQeWWpqGFRnphD8bvQPL7xsYZAlOCOlItw4vDQlzw+Nnu0/aGod7r8xXllct7WWIMzI8ZOxk4EJLho23eO9EoUxgNuidIFrtMN+LGwb7keaIDw/LsmMb6UNeCnFylz2T/YdBUqe5q1O6yNv/EAXYnwYDt+EC9Eo2xptvVfctL1pX15KsNLpj33qszEJovb1b3UR96O0mYAC+gi0a8SQhxSt3pnJmlZhuqtpCuxVBiViUvX8Hqjf8+00Iyu9DGHRzPo/qoNjIKKgn1HZ3s6q2VuK+zd2VwMSocDvzXs8y5ULP9T5M/tg3rZZwGd6MB7ldU+5/y5xxDvOhOq9FPV/FSREdg6MfV9H5bBOiK6Pmz203RKsKBr9+A/+s+oNwXNSjYXyNtQsutc08h9p3eyNcxRiNOGWCbdw=
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