/M6TJZbncyV+EpQ56Xv16R5K9mGw7cBnPP5pIwp5OEWYXZcj/LelcQ2zwJEfbyty63vsc7DUekWLT2qBVvMHVfk61Hg/gwJG+u7sHkrCUH3VbRzIOEig6pcb8gY5tof3M/51Kss29DkcxMX/W3yzzcjYmeudEZ295iHr/cpKBhdCTmeKLbDD9JLwHG332npTmt9rXTMtUWo9M2evYLEFX7RpxMqjWGqsSBkrsryIsB685xH/K4zxevq5tUXlypMeNEYiJkYoNgcfVxZGLOK/FSZDhle3G/owYGRQ/bi+++DfkTkoEHjhiCnHKwda/AG9lDxguT6u/QcqzhoEfWYer7mgTsAPNrKKo2pyj32GoCdSUhAv0+uvPBWmy4u2ANTTlztLLOh02SbmBBddfiwh4rxeTc2HKhp5KZxRaMQ92JCWvFscbpaoAN+QJv09wSIqv+sOawOBNzeF5cqUYZOinWmJqDzxM0n4+uzxPW+VZ8CgHvqbpYTDoBm20GdncbDJnKOTfFQSSmYgOJQUfEVp4O7BggSfJMgTOG0dfozc8rWkVY4DLPTLQeV4N69/0WqyDs7MU7GiQ1B8jsFx8m9dnPFwVRnNj4/47m4jLR/8WPhtT3xJrA9BP19C78GF2U4wMUouRqcNTkxthaQ1gko/Y7mOGNnZ7UhXCCrQ6fPiEwYGOzniDsOPu3Snm8Sgt2IWibvmBjuEKAyxiz7S98h+bsLg5nwegbKROogzNinoeY/dQJo9DUc040LVVDoOk6Zu709Mr5WDmFo4bXWbHKWH9MzYzRVJR1Jw88x1yqOVPdr1T/NQwclRjehhrWNjkMjexm2F64oizeHzFypTg4+8z5xTDwcYrakSIMEkRRLU/6EqrdmOkyeW7uPZfpKeJETii7yBogodDMRd5px8hpM9cp4KcsytPul0gZM8PaNCvRrMdOJxeDezWzRtm6b11o1T4Jgyl3fTzpG7r+JbvJLI9US2HdJxpPk/mivODQAzpnUAb6uqe/jKaDPVKMXdC840ZfRh/xjMVZHSVy+AApXPqYXZYUOMucCQsOiZjhPswdiKOl2isJ4AorEQ24yx1dCJvl7p+Qp/QWR3TUFiu7Pg9IWwEnnuhGe3dNFAtetHCs3SwXvJNXEJOfFmidi2KETxUS2oKfMcIZgPe90HyjeGzCeIOhSYXBqJ41s9+Q5ikyvLXqiNSt0UvAlUlQXRnVGCf2+aktZlbWs3YVlKpsE2wzinZ96Pa9ioduQ/By/8sPwbNpQY0M17XKSTwDXDGZRxehlGt2Kw2SFaOxNzG7yqk7rBe8Ejti0go8Y7ULw36Cqmq92Kmsb85TyBLFfZrrzd+9inQcsl5KmyEdIzGqMzc8RilDCMoTX30bTG1Gk=
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