vu2aZtHXhC2pvpuz0UyEQkU65riCP8D6OclGzn0YG8H86uHrY+c+/4LDkaSnkHvtbOSbtrEDEZr2NNKDP4hXUITy8rnsdD4BKgnxULrx4khThNuaMJVnTnyCKQ3uH8Rgcjt0N/FqFYoI4KUKMPHwBv8j8xK1c2bLdZXRgiJMZpx49dOqQ2gkz/fN8wsyCaHWUk3AUP+CAw7Bx4lAP/YaFRoE8YLXu/8MObi5jTUfiRn2wl2X7EhBW0AWRG+8C6cR+H0YVItSHP2Epm54NjUj2iDH1eIDcr0pL40Zoh82Za2WhoH3I5dhUSm8tlod+rMSlcwaduqrv1fxlHXZhxKZoHpEV37MvisD1KbeZfa5qPW/GrYn+irA/fDw1/Nl2ya6+jHyFbrBFEOPxacjn/u8jEoDEWPJIoXmqivFpQZ624qdU3H9YMdaSPk4wfo9hcj9oyK3GxrooZW9XvTWPt1zMGyYFfhAae2DID0k/a/MDmUw47Npfs6ZAr2du4e+txsH6m1Ms0iMhyoVc0bAMr+LXHfBKw/loWPsS9ffHoIdUuidKIw92OJv4uLiaWQbrwh4NOsgUbVS7xm8pRFurtaTa37pCjmSXlZUkbQ6bMzD4iqQgam8HQvKEpS7dciQkUstKNdIkIXSMMjX28kRMsw+UUZ/tfgL3LvZEiZdSN3aXk2OzmR6ZIyvq7qJosqtLtYaioKU2uk47Qlup+qtsq/DbA6FVzm0d1zB2MP5qrNkV8TAKAYnIbe7Z5LC5gAmDVb/ujW5pqxNBCOsTsLYw+K85ceEOCEZrRqcMhKH3mLxxYS5U0Mubs7eB+qB1u9zD089tALDBE/zfmCJ008sIVY7yByD4wdchUrxCddaVQC6sFrLAt5cXfsQXhxUMPsox/IpZ18cpI0hdlyOuAtXmmrkuBfRUBvURiJe+PzreLoHM7BibmConq4s2iD9JIo2q233n9o6Klz1baLid2xUeNH49BrcBKgPbaNTh0zepNGLOC9DXh+9dsS0K3+MHlG08d0bRAQvsfeeGwicmiEZhU2mkMWGnEPSsR4bPe8hJiplNguz8e5sxAwi17uOWC6IxmU94QqKNKEPMKYxQyiIVrIlt35d88Ll43vxG3YF1L8oPItGcQOUxKnqiWk2iwoOW9lGXolshG+qN8xQOosHWjfrfJs9IN/7G/VYDxosbkfhec7EBcn2/aJrn/uFM2X/mtZYNDYWMF2Fs+xP36eAkyszDAiL5l0KHeZ6xat8Bhzs/QEhUw6Xfa4R9aoSTIqh2qqJVP2pLSvDwoJL7MsmKyCHfohQ6pHJ4rL0itKBO28BJ2AGtcSGepi0WEBgRMTTxBQXTiUzkf2VrlsoGUdVFpn5dXCrLjdpD1gZayaGTAI=
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