nIgP6PsdsX+x7vRG+EjqP48xxR6BOhuzgTnL5UULhw6yhHyohMQFvyBDePrfuO/c9I6OLSWP1LutHEGTQvCIfmNQsB0dVZSRypKke875JQSSixQZDShiht1TK4o449EmaWorpXQE90wBPJw1gyNjXt2szgCGm4akUZ0mpKd2S69pGYwzo7DeqAyc7Alln9talWzY5fVI9HGaQcDYY2zQw3VWDgKXdnJbFETFPspqVs3zZNB4NTOFnLJ4lyolIwNad4bksxlrdfilqaFTGxqC5fwaMiXyAuGoCmlvYqX/JQSoEWmqy/AclFb8+Y8A2gH84yoMjQFoSLeDkfVHXkPCMIm8LnSA4J+wI9Hl4Aksl82MrvFBntmgHk2+nbiKKbsyxBgcJWv/AmI4zCSxPO2TeRgx0/nrrgXPEtPWpAPp/Plw2y+SZfyjD8ZRZqpJwGmnT2Yl/Hfeu9a/0l+pm5hreiC6nJ4LhYJhljs9KcluBveg5SdIevlceYgQ5ChV1E0Fdo6xcoI+nepqB5UTo3voG/KvYCs3oR2t8Dqs5vLtXYkzZ8Wsc/28NNQxrb+cxOTvSax+mRVjdj4NQrVpsUwPCEK2Cy0Wr8XfvQvdGa17bUbmH2+iwL22bdPDo4RuMlAu/ucDyT4m0HHPRhLnJpOKGRCodPGNooJ4cFkJj2d50YiwMUV6UeNtUHod0LFZpGDXWdWbNU9NtT4T56QDfiVHU8khx5xSYcv63d5sU7JD52Jo9Cq2TX0nxqleuh/8I9cB4eyXesXY3zLGt2iUOgJiCeRfrUguahBfQfBpcjLm3Mtg6+xoGGsS18tlNW6CIcY5KkBMXqV6KSvBw+l3hh+9xPG4jpxKD84C1e0iJIPuT7gtqROjQiYF6Psf4Z4cKe2E6EJdmU7RZnMwIHJHjkdTHEenN/FLg66aeAA2NMUD2aMaV2eRh+PWv57ygS5CfziB+yLoS3jBHCDj6ivI7mL42EYYH1/zIMiniHPfoAO6m/uLDAxz9tgJbmtKjHOVinXUGVDaElEpBX5DkwjNOgQ0d6PseUSs7p9XJRkbig+pOFk4RMa1rzuJApmp4kL1ikJRPch2rmh6ZmqTmKRmK0xnkRXkM/umPUrEY6hA62Xta5/iCfHW52eE86JenWa7iNn6TRRmUdjugeh7iJUGWwBmoD67NaVzVzkisOZD5qr8bopAH46oHhHmD1m8BxbJ87WLbhbhfDBxSwXFmuHSNBVlxfFR5UmEvvVLOWmA66Fw629weK+/9YwrIqh6yKk7gngiFYkwjdA8FAvRCOxC6TAGudpMkNFJkn9QN8pKW5n3z7vKzVhMfQfnpmxnJqzG/t0V7ka4teS9ex6562RFU/Or9MkBX1+c5cqiK4WKmUk=
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