/uqvQpTal1IR6dx5KVMCeE9/9CZtLhBDTthg900GB2F42oZSzAi82D19BjYodqJBdGFWXcKiFEZ+0kq+fPL0dwvK4YGsXVJPp7t8/Mzopw9IlndVHBTCqdnmC1ZYRC21x+agm5nc+6ghjjKpQGXju0RVkgMIQJ5epuo9Trj/skkBey0V8z+OUBw1BbnmpnWrApl3tnFukPXh67/Q4U9XH31299micjchZ8NK5xS3cyaBc3belUV70d8rx4Pm9oGZtcWBXwC8hnCuy0kzy2FHkymkz+wnw2QrLmWSrSAMXG75vdfiTaRvd+KtgxQi9nK9TElTNTVMSgJdFPClSinK6FYDknacqrdB0qMIoPdixzw94cAUnREKKHW2stTJ7uAUqLKDIf5mMnxOTgatE9tyjg9zQ2/Uw2PcvuCoM3UujOv2O7d17xHVH+XXupt/9K3zhaA8dXZrP0MTlANIHJIRGMlhAZwKUTBUF4uCQVGRAijgRHSjDbQtNxCNhfIrO6woE89oDRUEo8pWLfMlv413JWPSHGttu3iT/v/02oLp7KVZh9KrNrWmkTKqXq9tPh70lj7xsecWCNO3tcI53wSnWhUsRLc42qXIkVMWeM0F8SVM8C994KF3XKKhgAuHkNSb5ExZtv6txyXwfdzc3JdP5Yp2UcnwEjwqYwnQ6H2+RKKdQTA6l8aCnxAzk2A9lZrdyo0jbDg8TiSj2Qm7vKGsrhxR+qG5PSN9PhR/J8nCfU/Mm0CGRD/jyZkU2vZpSnAh2y7bye343dPFZdvGa7i3Ps/W6+JX74NS0ArF5STZ4TRUca+DXspAEP1DljT3uP/sqY2PtPbKvfyyg4iOwPf42SgWHfAJuBfPKCPQ5PYWoGiXr3ZHIn3IP6VGGOwLQI7Z5SqmLkPKH81CqPuWvdAY4jba6ypzo/JrXJvpDyY4aWTlRp/IARneZHUwkuRRnOznxEBwU+pMSqdwqEea1GVhSIG4ued8LZqXqBEicMPw00B5LdIDCmWR9G1jFpRWSMTj9bsSqnDwWRkeUg662COATtluReuoheT27awJq2sDWpFzM+cJm8RzzVy5mCvTWBtL7t0Q0oCs4KN5EOK2+X32MZZ5bY2HY/4AHIxITYpievWDG/w4c0RqoLFQJqyTv4a91mlSGtJfGj18fUjrO6U9krEoZr77EWYuJbnNd3yDsXfapMyghdHiEN9VB+r6fGhlb7k8rz/lQiaTW1EsXgZNLcYxZDzrLhQ0hJu+JCkBlC7GBw+OqsnKhRqP1hjhXcp/nOXg9wSHiRSV/gbmt3UZaYyhSgg0VMj4nOF/jyIsJgWt51yaG1dNmHwrApAPB9lSdE6m3KIjTJDacDh9MODUxWdfRWQ+UkJwDrhtxRQ=
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