vVYJbwCTedi5OgS8s5VQOszfebJIg7neL3QCkVVhP3Kncj2Bh8QgiHjW+z07w1AijZs6VYh4VM0JZck1E6H/MzUZjJfPBCtfmhhE4jQjgnHiNBBOt8C38G/mrsVm5sInioKsg3ePpPVuX3ltTtcCLtfvNeL2zNkxy8QEojgFk8Ih+fTs6Ja0vTrOAItypM6EIP9Wqvo9qsiyeameov2OdknXe9wV/qZ+ZvLdmv//J1+kQ6MuJZcklWa7L6JFmem/FSSBawmnb3mgjze6UgkcmSjwuJ74Uu2a4WvOmnZN/ia5w8gBrf8TTtgpzcBWcryHtySx5S7vPeig8peJLSEfIGNDPbh2AKlU+ePEc6MOx+qxLveNblOy2roTxKKy52IENc/qqRtfvK4XflgOuHH9r8VpR+scDHFIvEfCW2jW0bhEbgF90Kb2xlliUTi3yE2SROaW/SI7tXHeWvy16SVMOtH1Klkp980r9YmTs6B6D7De5spSroDADrBFxnuhALEVKxcBaap/mxqiY+GwpzQkOnua5nMqL04ynkI2VSDIVV0qm+NOk7gSoyhcgm/gb8ywUVmywruolzsxaeDVXYR+nKy0OjK4XscIo6QpTD1iYApyPefGs27bYoG3SoZ51cbg3RrX4V2yxBkOM1PutuBsSd475bpknKGNudVBRycoaRnZTuoB/PQqISinTdkdaMeEJrcJH6HDukZOzGcmSA1Z/QsUrKPszbFmxwGXUk3+o8zbP0aUi0XsT79j4mE7bVVd/e3ekoqjDD+ZI92WVUhkzM2ghFyo/nR2K7xc1PKFXfyWKAghWe4RQfzFzuKfjrCTCO0XX7tsznLb7pqAPDjDcwV4jgiKSspfB0RoCRYiPWuIoCzpuI3ffEw0NfOD+2FL/xrcI8VxRxEiKHnpliLEitfo+8VUAJe7JQRSug415hPZBv+zPP6VSV8lCysZwhmNh+vCvArbsqim7Aruq/8hFNcLSZSzzJcoWVBO0OL6jQEdtftR4vzBfcD9kDuJ4hnVYgSlO7VBdcZCV1I/jrPZT1WmThSTS0w1AVPkuJcfcC05dDvVdPRaOreq3aS2R7793evApwHQlhQ0fQh45CYPlCbBN6N62ELeswCOc/1cgXiz3ypzf3oz6L6YnUD6Fm6aQxBkMjpZwM2GK7nMPqWiz5C4l1fHFOdA4JPRob4LrYedxlsbXGQpZQEQ5ZILCKPEbVSh/ErQlYn1UTT6ZT8zERKp9Pno8spr4tjvLnEziog72sMZUqp/EUa07+JAjCTkv/l8nE/0X+ieJkF5Ju2JYyiPdHVnnB7DqG1bcn5RWr7JQtmq/KCrFoyFAP0OxwzWAMAHregscre7E8mVKP0Z4IiYYiayBCmZMWwZrjw=
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