0H/Wj5EGJXvbEmXF0VeIKWefTUPUxLLSTWo4G7dTEwuB+x15Ielv9EwkXjT2yFWn6MPOkCyf7P/kPZUyiHjDB4sB9EVWd5w8FTrx7s+7njk0y0e+CA8DjqAB4yqhMa2vV0MFSWbx5jQadVuiezvnL90c6/GDgVAU89IPzydtdInXG9PTsfbcXNBtiDL1RPa5NhNlAy+RoYVXMRydpDeNzANlrj9C4gC2UkdKy3tfP074UtVm/6wetgBrqVLsIlIMBoO9Emu7CKfO5zBuRRcYXinA4QXct37K5Hi4BDx6tIvoZ8hv4+49iur79IVj5CiK1Dwqi+tRTuxuwAc8PGZgVChsoAdr+xKVOOg4ekWYOsbS316k4FBPGuQe8QqN7PO3VTyevC2XmNssHFiCmd75LfuOgLjQpxMYZqjNNuRffY1RYy7GiY3wCgCAle7fikoxVRywRuMqQRkEUIcJgxTmHzFjwGeYBH5OdruOxu3IS5RGjx+5/vawVpn8bMeX9IvtVPSk+zOJmg1b+H721UeYg3wvy29YNSR4n7AQdz/9Q2L5HZqbKuvJSXcJ1rmnvr2vmQxfZ5TVIocnWJNpKO/ZYJex0jfT8DnTi0Ug5s8wBw5yUuj4/rtpf7k0B5HaQ1AhSVNahcqH+7NDmSwQLAiAfZpGSeFsMU0/ZANj55qqpd03vMffNT51UVI4YFVE47WkRnTl/plXVppz/4VGlGonfz4EnIuC6ro10XS200doInmS7Ab/bC04srUGaDbLivp/NXasO1fx/fPzBQD7x95kT+LLk/l7uicA1dUo5uZ1BeoD/P7JFNPWXTRZOTi+e6rYbLmX+lRnaKI/DA81YM6PLKrebEYpVcf91WPnkU5gFYjZej6rNFzC9Q1gldk6JrsBDKE+bJUO3yhn8YM7sw3QQKaBd8RcnHbKb5m9BQFGUnPIJnHwIZ9A5Rabvh5c88ahzvUb3dFcoJTnt93Q/MyVfm/RIBkedrtfpBXrWMLS9mQcJEAWRAosizkn5tzOrJHUjs6mMBFChWxB4BPo/SRXoLR59UncwoKfsgOFkgCVOX3/V/61C9tGlQCCcuBEBBxvR9q/wFv8ljebkhYSBODDPH5ZWXZS5FBISv+mI5EwyXH4+8JFmg5ytWsFdxhVe5stZA9AEdKlj69OWomsuk+lxDVkOHPKK53D3pyS4bygTTZvqTMnFdfIPOgoETCm7KOa+cEWhI7tCUlVVX65WqdEktvtpBIl7G/gnf0QtlRWuDw7Pt5NdQRvFnzmr2gbCB1oquN4609KrXKhl6l8AXHYu5HBdGhJnjBbsGGhINUmB7vThL0nnuYpX8lFQ4X9/PUoljshEgWNXKoAAk356Tp1qgGgFUzKUXcPuU39rms=
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