mbTP91zxfyuRqm8J9aUoaDGeLVox8S0rTZm8h/5roWLQHRXUmtSwQIn5LaBO/38a/emj4taDzM7cAskIkWGyaOd3UDU9qi9NX2dYchVCuErxR4nFgnm+5nEcJIvRwlylWLjagoHNNmOSD81CzgWvcjP2RPuQzitEgX/CEX22AAuS+BpDJlKHOUXwvU3mw+X11eLQ2/72Tzy9MrhMdPl6CZ0M/7pkXTWSZYSwcQYch/YlzilebQ8aYdG993tuKH4lT3OM5KfLSaJCsUeYCGqGDtXVsLV+7Qf0tV5BBqjrKmNQt2vb3+WrpIKwCNOrfXJG69NzqyUiRwA5oz3xgZT96RTiO+C+/ovFNIrttcWReARkVNWyGi/Rxu/ZHLnrdfiGCmMNukzAjlx7EaGNL2vlgl5Kc2DKZQt6EeFNry/XdtAqrkRtyaCnGfmNRkaE6Z7sELIMPZoYqeoy9DGhr3E2UxrH74Fo7TOjvh7x4hC4DRzDfAA98uoI2Srti/Xm7pdBPvyMQ4L/3sNtrxkvKAe1wc9CCN+ndlya6EE3yL/JcanXrYTrP1eVPaYIh1ANv/8XoBOMowt6uh0m5X3F86Em77/3gNMr81U33Ywl0bXJsswBIlA1TEXhPfgHxvChU7qEAXE7zdgJvRTuFH+rV+wthS7lEI6cphRAaIcfstkJXBt8VyClfFCfeKOMumzLqWsSS90kKu6QMZp2cDwM0++TRkudQpwpsNO9Pj773/ChaafG6ZjrBCucFmaA/2LampYU2MXkNA7A/XbQtxmGHC6jEOPvq++sjNw0Vr1oAw32R1yYlNyJbyK3VvbtK9RKdqbpbEwyDrAk0jTaLAZWF67FhHq0l3VzXEHXm48pccbpCiiab4VYKnLQ13gANlljct4YBe1WtAnicsq1RpOaGXlOdqHOrIA+l35FBBzH4Mjo7xX1BRWw9isCRdzhaoRNrCfk3OPfQF2qyYZZHFhRXN2BE3+9ZAb/ttoO5UlWDQc+B5ObynvTx3XciD7Lhail0FIm9GMU9C4L0obbQkC9o4tMYSmVFdUKvtcWwqUJB+7+JF8O5nZU26RmZK/lc2qx3EVxHV3BW5oJo6NjljJGJDUrpIF9WsHwCyuy7Moh8NtFuiD3uoSCKy2t6+Q9vDQXIjUSqDjYhrlwuIJGPBPIrf9dnK6Hn3nUXiwuSGGEE73qi/PQvxZYEh3ZmtHyt3upZp3jMqsXkISqrOd2TeeKCtMrh5Q8bv3dh42QcXNTZAh77gjikBipFwDDQN3qbpLShgszpncFY3bqw10OMlKvM51CvhL81pUA8KG7D4I76v4LHgl3DfWHAMzpSd3nASZkTPmYbGul10IzLBSocVXxAQYgzBrfMoi/H0wyVvzQbEA=
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