zaAlF0OsIgjYLMrwrBRYN9prdspL74OHrzRxtJbERysTU5g7bUX+cWmCF5oaefPqpITQe6Jacs4oU9zaoY0VxeXU720alJ740gJ98HD8HEi9Mxf2wsK2rQgXkswAV2wd5l0ylsvDBeZLQi8hgpr8AYr437P2noA9zanRmWPQGl8wRf/QHJcMmP/W7SMsxJOCjqrvTJTYLsdYxMMF/3XLZBNGNcA5GP+sUldu/2EK2h17TPPc5AyKhkYVYiupdcOkW2NK9Tlze8Wmq8JXq7i2rSTquEhz6r+sPj563sdUqYkeBBMakV29T02pATB4g+TQPoGvMZpjJIyrOtXtYQFFi6YgAD+csBS6Oy0ycVzpTmoS+zzM6kXCagwtHxtYcHPWaTieFDHzIGsJxg8QRWKhp9qOkgyoipZxF+hsPcKEoPArDgGQyTeLFZVrcFf139lkvRdrxs7b0N736SDm6xthZ88s8WkAN7BB3KT2+ox9uOo7XoW77PnP22zawMuTkznQ/n9Ok7p0YuoXdbe1HeksvbkmAqUCjqxGCnlcTt/Xi4H1lEdsf2eHRqRIAcXXU9cUSO2MUfVKtEUDUn/MhV1JhTb8LTcAb4AYdm1a5u6J3A9WY/IwTko4iYyNLwOCCO+wzkzlPkJJ81VbTEDPAY3a2YrOaMlcxEul/JUcAAY3V2g7Cj7G9YcVdPw2fsT51rbtmz/7YgX2Wvk+2/0FntOpKLIBBURrKHxvC+nXTrEyAPT/A4dla43vk11lEoRs09c44fUJAr6qp1iboyp10ddTtidEXz930QYxhjZvtoxkXUc0fBu8zaYxvmEthWv4OM181qxoDcA3/ML9chYpTij9PgSlmcXSTRJE++3KWKQZkfSfaEVqbHOaf1/3hQ4mFO7azuy1pBWQuPV/LABmbRkFfA9yzGWQczPee7c/A1TT0oRazF5ZpaqGhAdT7EyYyQKzlPZ1/m+8vn0zKTX0BeYGft1sgg7RoyHI4N/2vv2YtUOdMU8KishQhYO/3zfa2uRxZbkTM3u8skl3TO8hn9w10TE142BiKYvd5rYPSkLE55WXG0PDMXKDAgTktTGs7XofP4BDGGLwuGo5Uw9yIIOm1O6W2zzau2Odl7z+aqyLIyxa/VEAO4ED/1ZLmcr4ry1TfHmdIVYxN0h0djEf2rgu1FV787pfDGuevMDX8rPut4qw/P27C3Mexgk1Wr1ZYTrehQmC/70HoCTr7nJDaU1ViZZYm1t4wqxXPUBitaBZHTgOnVrSBd0FkzYpVcEVF/AD0Y0kpwQB1FZ/QZ2XnqOn5K+6PMBSvD4Z+uvGcdnMFkUOcDmPTiv4gaWUTWIwsQyahilKi/2K1VLlWhd7QdIO/0748mKVg0vIwJL06YE=
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