8tAtDMbzPseB2BLfSSeRlAzYgC3ASYqmX4TyLSZA8On1MQDliTA1afDsQqIIbInXwZ09xGnMHc5VZAK8BFwLFUCp6dXLjXkrGld6kt23drey1LrUXq0k/j6QmsrI9VOwtur5eHdpxcJ3KEP8/UjSmfL1IQ32xNT1PYMJr0SdqWW8q0TNaXeLcYYsxtL5ISUm1LefVRVwCen7NnF0OVCsF4Olqfr/xEyLs2lHDKYb0G9f771TTkCR1EhJfWLpWEulIv8XyUqzso+MyBu832+LLwYtVyRiDxdC4YoOSJUv+JTa2vkX7P1vkd3H/Hf7ZHZkosqzgLNXN3H+fvB6/FvI9zyKoj/GdmnogOEqDHEGTVwmDIr/3asyD5z/9CRkHeeKQrINPTzVpy9MjTuryLJfMAXzUCXH0Ev5Ag6EH1Xbl8HLvfsd1qt+E2QJ0OUpRPMrw7GlaejM6klWOhBLgtxeL+7o+jPTCGWvPZHxvmbkGeti/W7XCW55peMjy95e13ytRA+6+WhZyd7YgHpW5sfYW9pz/nbpNCFWCrEB0GOmKiTyTxz6L8iGOtocRciCHxb7dtVQ8qHy2YI8b70yTTsa8VaB1HFk59SRnxoJA/RSaUYm2CAwJD2CEhO85xEn33AqFkiJwgrTvdp89U8m1lY4Njb2IXm5YJWAJ1eAuNF4xLxti7bfL2uqwQRW+ZJe99Haa4VHPuklegv53Gvy4B3Mrck8VEMXcQ9bXmke5AiYT+j5Bugp3O/vrMKHpgWaX2gHgM9/gMpn+z42lFBPE4GQfiM8Wg3RsP1kPwj7desuMLU+jhw6qHhxrANO8bW+TEXGYF2lrp1ubpRjK9+KIEHtw5a+fPoFHXUqnRk5ijtVdnbyrBjABkUM/tmlI3nWpXzCM4A4K+vNSL8Kc7EkqVOfp84FyB24NuztZCXxcJ0Ij9137ZtV+dRfgDXWWLOM16Ak1GfWfpcu0yuoz7Ez/+31eOQRq30wWoz38+myX3ZPzBA/2oa9hy59JGZ/S3p5P2RoTw7ChMbXPf9ATshoc2D759XbvjFHzBGbH/NEXn6/ZtNhByNF2WYc5hESXgUA2bUH150PEGYE6jGxxmtu4jNbsf1YTfnxXedJQMZWkxlaXkwb4E8F9uFkg2lXDey5dWpMsjmcEedKOp2ankAkiZx4g+h1fnJZ+bWGYfuoPtaG9ZCWho64RcMc3MQv/OSPY5AAuBE25dF8WKtsMrchgB8vz/aFcwOIh/BS+pI8/PCNa/3GoXhmqoLVmBU6xluDGlliuMN9Y7J10RSuVTBPtBKwl5VohC6DSqtEAdm2TkSuW70KmBsf5wjxr9qkQn+Vdki1+/HlGyiNg9sv+2mv7cAIGDWbUIK0npjs16svA6A=
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