dMswWg2cgkNQw0CBOqyWkH73Z97+PXnQs2Set8YdewcdwpAuzAUZjOnxsyFLn4z8Yi7DJGuRhoUezFQvN07tmZJgGWVe77f0Y8MNkbTu/6unxIDsqfXyeHJdfSUeYUZX/pPij9SrnREN7Tvu3y9gBAnC5gjLXV3KJEL4uWJH26xkEcT34Zdyy+1TiuzsAr7DrWN3iHdk2pR3ntFJJBs0U2llLmCKEkpoVs9S5IYd/xwjCxaXtAViRc2IHJTTzm0G3rFjoOxWWOYuPmW1C7ZXTHVFM6H2U7Ic4MHyku2nz7QwAbHmSzWg3xPg6O3wJtrlf8DfXx0/xVcKfFDS8y7JxedZ71TqHXLXVuvVMKRTBPE2zVLF9YmETMQsfxHwEiylOQ6AiVMvUU8Mvi4kmUjCd7v62yzmS6RwX6nDzGKeLWtVkgWliRs43VFly+RBKn42wS7Q4EPDPQUCnb0EMshZWk0JzWzqfSObdXJdoC6qm4ujeIDArMxWu5Rtb3w42TAyqVVP5K8mTXy4YzTrLMRdm9GvuYolsGWktnO4CYPUt6uC8wsHlLA70lP5lNaMEE/GEoyCrxjke0/ubtUAFK4J/izrLckS4ZXbVXCctlme659hySufngTo20Euv3yrHrSyYHmG5L0Kem7hZkokFFg7izfMS5abl86BQ4wx+evvTo7pgo+MkqtWfoSm1gsm8zBhpy3LhkreCLqr/JF9s32sqMCxlg6s+weA0L+6jBT+tGs1Dtao+bLl4UhO8B9sbujPnug9C7YSAj9gPjMU2t4KR77M8qVSdfoYqRaUj1IoXKFyvChdoHF4POhhsKF2sTWmqPuqYS+NdHAE0IrlnwxynW+EzcADYjPLdtpzKuuEP9Wz+bNvY7m5swh7G4HEyJHnmrNqn72t4CYi02cp7PGVOMbQeHb+WRgMPWFzlAGlH2kCv8jkAniMfgrbx7PbxXgxPTqapAsRZoSXTtTc/wo8hd7CaKH50520TAJcQ3evt5gAp/q/d3CWtsbKcMz2iw5Jmb25OJDdcIygmxj5ouOhEhqhGgqlYcOFW+rtwN3iKnkplLmnm8idXj/FUP4HQkLeXj1ZrfQhyrJcJhzg50D7xKXmHn3GC8ra1zcL6MNIqzj1n+KVmrKN2LP2aO54IlMtWirXkLJrw9arGQlIUBG3AbwmW6RHBEKBW8FemgEGTSnZpSnF0q+N7lK0FKxFrJk9sCQrfuHjp6FaLEnv85xsEjAmFyO4A+f/oUTXA0bRcBg8EcAu6iVpMSxPOvcCRlhjH5Bw+/GUUvUG8ist1EF1itLJfxBh8DYwQ0qhC4RDfgbBJ3n94Dpg/vayFCgrB5ayJlYsQyWE16RU9cTzNWrNN8NuvauQSP1BLG28eTA=
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