17VdXzJuV/bCdqR1yWiAZaiL7TjHaMF8eBkpTltNtNERRt6uq27M+7IPthlsGwfnIECie3xAy6VaWMv8ZWYBbMTA7yQc7raZnnVn1rqHyXwNc4KUFGWicgvp2cQUOO+WsW3eoC+JOfLqAHsjQ/ywZz8njenBy5WGE/bJYQTaPIfiTbXrkZ2BR6AmxmSiMMRoXYJ1uQK22JBD6KQ0PrUx2KMCxHQe+xHmQgTn9qtU1kLJTjy4RW6j327XVooFSAaLCuWlsxaHzeTCZ2VEBhUT1Kb1SBPhb803hWMY7WVz46TwQZASNqlxm63qgeewjIDw1v2kqmE7Ym0yNduP12nNgynn0IALK3HABQi6N9/Z8WS6ryJJ8wydVXyB9bIyqPZpZjo3N6IxdasGAanUuD//x6fVUA4TvwTE9pRU8vJpo4Yw/CmmZOlfEHTUFSbHa8TyDX6SHdmqxpIbZfxBHcB4XcWpIzHQ8DQ6NULSUHHO6NWy74yZQ2xiYG0trZsF3QeO8EnVsoulkwxiF4cUiDbuDaoOX+xvlWn1VCizuQP0+Pyx+scR15VpyjBG/GBHS91pDar7BYayc9Ea6hBaLXphugaSNkFIAZBLu9cV9hHBI78qkNVEJSAeMPeCiqYASPcVDGjf21DTwO5yQmkeO1nkN4LvSkLfMVdESqf6AowqKlavIiAw/lu+yW4a9YQjClVvjHxQqJa9lZyOYMS6aH3jGbv7W1Lwwz+WiZNeVQcOL8Ju7VaZfNXsoP8oHOBQuZRrhh3G3rEd7HaE9RR+4t7sDYUJOXjspob5T0y9FdAhyeIBW7AQXf+AxtVq+AsTfv0x86hOsZXBzi5YxMwArUZ/jMnFw89+7k/Xa7NQ4p4/fbqzDtutOTVVJibQ6AcD5uAdpeX+kxF1rMRCeioYaSfual9jlbDiUuAuDfBXkgHqdz3dl0YFIPRvOPTCQuXaDZ91Tih2rq6QB/lrNV61gOodgEJPalQy0db5hcyGsNHDaDr0UjiClv9PqB37vTBgR9fOIpNQdeM7KvyQS47FDXF7h1CZM19ylMZAjDTpZH/gtSl+yjGP2iK8E3bV+4v0Uj+sCtkCXr9DZ/bWanN2cdAv0k7l8kUFVLF4S299eubMtmSqtAtb5QoqrRiz/C5PsamzbY43isg04UkutoNByWc+mu5FkYIiUs9dfR/yiefcSqPb0Ka0Ywd8NLPAfuLtyDw3IyrxAZIvkSA8m9iLZ1xB/yLObx6MWLjPiCJcqP1+2yOvq8w8pzBdt1t+To/ouyun5oDcqJ6VfvIXJ1t237l6CzvctKz8An31xbao5HypJsxps8yiaLbr9mwj0oWz18/yxPRt8EXb3YoTFn4Ug2mAKPhnzR4IX+8XEqaPr2s=
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