9ySj+bI9V5vOiJDDJkFCxA+YTKIB5+Ghb4/Rbr4fwN9xyhctjYYCA7GuArkD9CIrGKQuQdY+T14VomTTilI3Zp6EAS9B2fW7l97Nx/33Cm5AZbe/tYpijaEQKK35i1XaW3mZdb4/VnpCKkeWyb9hlnS9K5PNZbgbNDzeqkwbrTz3NBhUBNitCkFi9NWtjJHGztp8gKatiyHL4b95ym0eqhaDAg2hpcyubJHaX9SemYCwdYyyC9F8eTx7WvLmdHVbK+bIizQ0czeEwfKOz370QGQMF0U26jhvizscqyj7LWpRzom3Qxs/ewFqv/Gm6XBKUM6XE2w0dSXG4D7QIkf2YZWWysJntGeDyw3xAPQKRa4Thko6uOLXuV3CxlCEx3Rx95HHqZ//Rh4cHqoE4Rku43TXlIowm1c4uJ9+e/HD4loVu8bQvk5jR0yzlAuLdxlkxHhcwokq2ZByajb+tS6X/PIk5LgfIJR2nBObuf6CEupHAXyYq6hVJibHfr5AyGpCVOAqfMDUCu7yW8uzOI+P0c3RcMeCJcjzUBOy1GTFdQVVoYi6e7MjPtuSgnaoUeuDWgaVOUDO3/BgUlxVMi8N0fTSmQaxHyQgiwVzpC1kkKz5ZhqehW5Itey0CjmmyS1zXNMKgGjZM2x8QC9UAW8Dcxf/8Qp9452DSGx+MHrD0fd1xYu6ZLoXuMMyz/1pJ6paFIh3wBaUr1G+xJ05tIXekDJOHETLGOdT0ojgKofes2G2HegjoQgVvlYO0VMtLlHIv52Hv5h3N28iBY+cPOhUp97iCLa/lCPaZysvAplEx2saEUKH34yyZbuviCb7+hFw/ScixkU9M8qzJgzDYZhH62w3Sw4hv0speMUHMoUtEa2CsZzOuEwIstmb849yqzYNfxx3z1B6fAGCB/FkPeF4Tr/ejt76F/GrQRXUdSQQOSYWJQ+a22GUtnpr0IyGhezfyP03hwvMpeMTRrBUVervltcs9Vhz5aLqfNm5aY59QzOzBCdxng9c6rAqdJJJKmxN7HbskNwARTyNsqwcvrivnUODu7RKQp7VD69uqFC4DOLaRseQyg1D5GOb/7e/XVR78guyd4rAO2MZ9q93yjbVAM/PiCZ5lOIveaEIoZ2Be83VnVkGZSWXby0gMQrU5p3YyNB/qMvP69ik3BBuaszy7FCAEZ/gC92Bo/rHTPMvwW41bzdIRax2B43LwNMceQj+wJCrIw6KgCpOAcKNBx7cd7eJ9/ZlHxPHcKHJRxuzfsm3bjxkTH8A9qwBxgxgenkw2V7hzyLReaHS8+7ZjhYTgEVX02hBvs/VSLNMphtZhGJScOU5R4d1srjGbeuc7tm9Jse9Q5PkTxrGooc71GMW3RqW4nrxPfZzjvQvbQw=
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