xrSy3ghExMLMjqDRki+jV2iftw+/Zq2lofeWjzXnW807Kecwm8R/yaESn1ser+79HNEls73Hzdx+1kQaYcoga5/ZjJyRNm/plkVgb/4rHL++1yGYcodVPMnVAtpJjpii7SMQOTWqZvLc5tcVPryqAr/qUMhZBr9nHxhltpN2e/7D8P9MdnNrI/bbNRS+PsAgij4cnIMhKtkDQOJ14881pjqx8Ilwy6T0J4pTKJJU8rPm4g6dRh2l/WC5j+VSuRSIrfTU0gW48rPWBroE0RWZQjp3srP80yK96xG+qIo8rjGReJsM7UtPHXMtoX1QPLyEecaJXCOcZdXerC66RA+GjOcAO4jK0sI9Q08gLus1a5GuQAk6JcbHDMU5Sd7qzvAyV43NX3SNnC6LNZ2tymJHH4bjCvStlJyZr/RL0NrDq7/zHcFwTKBG24YanbeVWrrFhbz+w6s9DOXPPXij1ud6190HqteKi7Yo9DZtUFyCxx01/+xTKoV0erb5LNZikEIDEcXq2s8KGbCtdq4lcfO67ooicEIlU12JqaVH+OTnG11bP3ACyBDFuros2xAVEgzcJmbyPoqj2/Lo8+H4YrBboEDe9fgzaPa1qY/XQPuy016zIEvspZ674BYDfReOpsEeTgTHYtvXmcXaHc15uNzfLWKBW/RYa1bXarv1EZt19lwYhpob5ukFs+ofro02OxyWdj6jjPFiugFSBIkm6YpyTo2ymE64NAuzhnLVdZtvLob9hf8kphwfYxssBQzrpf7MfEcEjfcyji6Cx31mBLLvANg75sFXsgEnOALpdRYILkU+ugkN7FTz/1CD2Uy5HjU9RfOhqfaJfZpZNaBxMY77ypier/5AZ/le/MsZMxXPEaRrc7e+OezGMFbt9JeDGbi+QeKd8eddT6LSbIpGeTWWjl8321si7nQeyv/8IBVow0r2guZjwi+PCYm8RflN9+7F0pSKhtLCsQOkXkMNmhFUJCMfjO19jS9RRBqmnRGMrdMSueikKLFvcXzYfrvri4C3lKQZh26aqJ1bkwLrzrLRdgp2OYVMBurhSdC8kLI0FpxJPtY0Y74wj7robZvO17isWZ2Tpep1ZpyJbuPIpio+X65mISM/u42MeLoKfFTR7pce3vTSYO0fkgOBfzTMN7w/FscVph6d5jlEdsLts7WyKEwp1PDqGf/Xxl7D8sFDJU2QTcvSOKJI5Xzv9qBdH/8RzSmn+k/4rqgnhkPK7kION1XTSmRX0Zrm7AFwHS8+pr52uj3HETD9VCYt+tQ0iBRCsmFQiLAPcKPeUmYDIr3ic6HBsSNSppM5BXEmodv3VMN/0WePHF3vwSlb3pZggk7FFB8t6NYJ4sDuf6SX28BSSMCnpPPNys7ZhCX2qqg=
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