D2Pl5jxKXUK572ZJNwXKbq1QrUmri+TLrCuTQAPPptmrLC5KQKL15L0Vg36LzaUT8U9IuWrlJaMX418HoVRaU3TDg0dnmtFw8AFMgsSsJG4pBnEKHglp5VrRTBQqakAoXSNe6vQiprn12MDEEzTz2V62LcT5g1/fWdRyPBnEbKWx6yWgxKH7DdayaNWMzu2c41/r6y/SeM6fkRBIM7zlBfQwX3O8bPCIjihe1MGjbduBjhuUQVWbmVjwfh5IvL0asoJOfEgiJ2wvTjcbIQUl7yl0SWQRxgjVZ2byQ2oVTr/+/uERUpeb6pdcWvTDK8dIF68xTod5Nkpfs/Vnmpyoi1UXQtS/2xtjSRZ9fJoejfiCgsOPDgwMPH5zESnAm8D8QkiO/Ua2RYGmg2ZtBT3LsDxhNMALYL3tSphwLN7cdPGa/bMG9jXImBWHuodtvddtYyQ2hzAqJ/0xibncPe4X+Izrs3YjM2VGQ8aIZk3BaXHgHcV4nNF3KUkfG5SWq/xcfR+g7T7I36PkCTxMg90n8JWc/YGrdA/zalQYptj/qG9oIG+ksHPKtDYbF40bqrXwFYHgSK51G/4VWC5TOut+vp0V/+aDKSMTo2e0Y92Q2kacmHqOBfFB1/43T1uFJUoXWZW5LWPpcHpZz7EjVZ75UmxmOTVhWhFSOCwq1UyYLbI8nEombALPrh1MqkWifIeFPnzvo2wRcs9Gi778WOZOaUmK24uoDM6FttKR9JYP4jOO7zdVuEvwHe+UUggnUbgHegHqEa89zfVEf4YGnyUTeyWrcnCciQ8IZScBxykg22+6XBqKB62SISXwSOSqglG5Qvude1Ye1XAxLPTbqyiqNQNyKOHUwIrfaNAtuGr4j0kt7oFVevdN+ciJIG32PSez5tvtAqusjde31+4y07Uh4YNCtYyUOqGF+gzbtmhn1p8MtFFD9upEVLawWpu7Ni1TwpeEr7ZXKatSMuN2m1jkvmuP4EyCEBGj7BeUpMSsNOkf5ZeLQwd7TkGr8Ax9nh3XIsvnYPAMNVgG77bD/Exeqq+1bifnv5A+dPLMZx+Lh/pemHGNe//zptWzQ96XKeDrQjKH9VGK71j2RoVkhLMosn9Z98kymQxPDzzk96bF7382acV0wUCro0bMnE7+HgzTcfsCXISlFycfzJJ9LXpvklHIS3ZkBNXpIhbRfaAV/TrnQWK2n6CRm9o8u1uWHmzNTMrYPnbb2J+6IdmqXzkSi/keerJwiaWB3CsXaT0B+/Aon8hm+q/smAfp5PdjXHw14PMVnMehWsrN9kLiN1zk+0dMNbNzMXhqoM+EgxAiW/6qZAx40ahncgw2SzhIj36LQbgVvmP/sDV6k1bw3hixXcbU8hPG0ri1vmeCQYE=
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