AbSQDNghZxdEQxav3d5lvH8jzUbR5st67ncDYLKbaGaYftwZvRDi3Wml9Rq8Tc4bqBChte8jz3q70zxYQOE5xP4R9J3jCFBamv58XtCHWkajMtCdUtWgwwodHrtdE7XWCdERAQtUmzGfNYubrrJ7biQ0fUsl3GRPU2f2auE1bxhc476KPO0+e+oHvmmI+fecUZdavoam240wphD9FJq+lhgvZH7aRwIsEEluDQZMjoFCJCW9rDS4eSbRfHnCBYMtO6Lyjq2zdAnXwJ8eaiP9N8sYXXov0sapapwj2Mt/Nv/UiIJDQVbeCwyeyzlADS2idOK3eeWUAxQt7WDxB6bBQKzrRdRC/z56dQ23xuIyauzStxXVp5SHGbxEaR+PETBzgSZi2cgYfu0X/qSI7yLMqij1YFsfRR/WQePJZt55Bd8Y5/sj2cF9PDTZhIwKAizYY4qcl4j3R8HzmQaoZD+IVt9OcECI/Al/ex4HLYxF9xz7zG5nnqJe+W7ajJjstO3m+/TMZw9m3NeOJYy5a3rp0YkBe2i0sFiIC5WDPTw8W8+anS8UWzBvGU/6jxnMvz/J94T5pnHNJ9Q+5tL5tDrp0oc3P83cedOXapg2BxVh8jDyc90XIhhBieIY4OVjGA6nzMZ4f352GhscA/OSE7X7ymdh3capDjycdE55csyAPDibMnAe3VnMFiVel7i7mlvcyNc4fIOzHNugaw6VDSkijFOJr2WL4+Q6ROclQhhKLHhI0LcO/AHNpkT3O0Pwxz6vJrR5cuM7R5km6NW5It+fyaAg/7ptCsCC5kHEtr0d25EjTwP8w5cQ0rzI9Mh0oR+mYD31OWyt25EWIJanYvmXDQOi3oMcfxzqlElaRfQhb/ubDy2pR65VBGlYkDMEPXeZhKrIItgKAYed8BaOereAJHU3iz0Oj0Udq4qzAqwUTmxWMPsmti4p3qrqIKoVihAs0+itE1ZVqqNLb4Qt5XWf6Jnzx8w1LUSSviKi5iuCEEplsXWTlfLo9QExEFj/KRvzM/z7Q+xDD1x9hXozP+7ANhQqOmaHaz8QvLSAyakm9ekW0TNHYiseOcRxW+El36eB6wDXEtjtswQohogZQga0ZHlNiBpb6dZVrQfFWGeoG3OwWiensdiB/B7g5NlpkOtbv56RtkAAuwWAjsTqNTimrQucODmcptoN/AuuTRr9c/OaQt8Dph4Gqe0CgPUIO5RYDuEsT3ICKzsf4aOSQK2+GmaqRTEI/IC6qG8xBwkYdLF0GOElVktHLLzUCQflw0fLY/GZ3OMKxNCeJwUEk3kYay8WCtTyE25qOM/LHXqLeQP3C+rotusbao0uddkFlnLoWeBElPLbG6L7TiKzJtXV2Q2lyKWj11Jjp7h8AkA=
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