h56a4S1OvCfLuOeQWtwuQRmWzxP8g7qogL2HRlRiaSPUOrmHAuedVi15S8Vq4dJHonk6g7bY8ZIpRcORE/SFZc/yysfd6NIc4j6CYbH8XXznhOdB5A9kLx3xNL6Q1LgSn/KV+UH4RmSGthVPFjb4A9I57WplA4ZVfr8wviRIOlwwFqUTHJBg+jclAG0ri9OSjuY6Mr66TZmHWnCyGQj0Cy6OC32Hmxp0OV+/rkoADLndD6zWsJJFa+GBSPhQN18iq0SSQH48U1+yIpLCAze1Okr/wE62O/53Tqq+uyjUCGYpjdos5eBKCA19LnDuTkzyijaarMVAO67nZ/zjVxq4dfvcIyG5mpNxBLcRdVBw1ynfavIS1XioQm2ylxZM1N3SzeLBXPGLBVPFIO483czj2iyFR6rMAKpF/6WBYVrhs2HWxtbvHMC9TgBSI9NRyjKUk+uYZtf7kuNfmWHVKWZAfXVKlDIw9jhlXVRtpojgArMs57/QG22gVgdYG3S4+cs3eUMIAGQQe3ChRFmRzIdzZpBsdzI98iiJFPKUdSnrfZxE8BYCwa+98WJDP1o7U/3A6AoCpE+F3hl2YmhQscBZOkJYmuTHYWZNDhNrOKCGNVcMLQVvtIFgNZRSKZioVhYGsqgXoaY6FvhFsVtpO2hT9lqCrpRVyYdd4X7a7hGM6wqdawCcVEDVtK5hilkFgnSTF4xNq3CiWpoCg6n/JEorYjfKn6axVla89qSZ4TfUPkDJgCOduf8rHXGR9EU57m3gEFBHPaqrQzMAjmZQk0IIUv4IvTCGM/g9EArvUE2mpR47cq8Hab1f+XO/nQuDEabn/baac8pQgWdAKkzCBGxHac9vQyTSwvBNu+owgNb8aKId0E3M87eEO6EUmWB9xF4xe+q2EzEp/n45MGXF0MSEc41rriefRJTmmpZo0RpBPcMMZmnpcJbw22WPZF9aFC7/ABGRnQ+uH2U1ZMrlFjHVJ/CjTYD7iCancxlTh6glPxRDwVF3KghX4pkMPh3ikvbKh/N5yHD68Hqw3zPr5TqfKJwgCg5lNAlQGUyIJvmhW0mwhsfiFFnVpqC8jnbcJApom+AeZOVUgUxidiaUWgHow59qg4ct0b3m/ZZ/LBHE3ezTQw7Uk/SDI8ZjzLY4vvYs0xf+y5bqbxG9aN9zLqToAipRzam+te+9GbHgDhprSDgfFsEv4OaMfkRRrZsEV+NoYZjedsNZJ9Y8HwjA5V6Lojym+xUCuONugPE/TFGQCBzM9z2n3FxkK9452t9XuDgWSdUMFOg11SmF4JMTCTvMEq64tSa3fIaMbM7qV2TyVWrzKGCG2L3DwT4Bc61b4m7oEttLdkp/KKF5ZpQcc1cSUloNpmCR9/ZfcEAaAuc=
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