NAB/ioAau/lc/ZFzfqILLx1L1xH2rPQRZ6aBwSglur+QX1rdbPXjTcvO0JEsaq+BuFZvcYtgzeXtUDCW+kFOc47yGIqGXwr8G2ytInMjE3IfYyvSW/3nj2+/JRaHfUb2830OFGKaect4CARRsEffe36CPji5GMDW4sN37cvYMlErdAIcNccORC9uSMYYV09RiaCj5SBuAelF5riQFJsegtzJYaqfxxmje32svZluECghr4FFQZYc1P0IdqXXEnp1MmAy+4GxO9bwOpJFYS3C8Me/MsJKq/bjqRnG+viw91rLu1M0fC9AnSl13yIgQgGbzFSCKn+LFGIna//639jFRtZr7WIST7tJgbj84ZBIjDsjilgFY1PUU29lJilxwhz7rqla/H0xzO/Vw3Rzvkd0mO0w+Gc9KWYI+Juy+EneQX9jzE93Lu4fTdpfRvzGdmZFr5mUGuJuEvhgpRyPth3OsXX6xGxeRNdCkfkquJcD7IY/3fSmwKgcij86m4PDifqnK0ARXHB2+lpjrSPfwS0Ujkx6ZyUNnsf10z4lyiDYjqKx3o+s9ErLfZ/GKWBu6CSbWDHsjWvk+43jJHUUBDPlndc0fZNGKRAB94OJICgUdS9UpK80oBMQISf00HY25K9dj/ZmvSVxM0TF+sv+PE3mOofkoGnuERvxatEBulyDxv7E1jRn3mq+I9PKOmOQRNC+mbLHnRrGi2NaLrelEtUWYFEiVNGzREQXIh3J9M/Wvl3WpeTyHXLIG9Z1J/mDxFOmxrv9MJIeLhv3q5ntnhckHf/UkT6KHR8WY3S01cOCQ2IUj+1J4DM1RYF/Qbbluh5HqrvtsT0g9rKxeFF7scNeEIhPXv8ZeAARKh5UToo61FYuR9PqVyeXkEhICaArhnhfrd1rlK+5fARzteNNhOhKMtlfyneL18IiX0TpHgqbF7+c+rqwroLuzfYlmnLvAbCQ/f4Bb3S/ojY+RJcGm2/v2vNi7FKdWuADskor+Z5EkGqtY1hjgLMfTGC1LiT1eCyJwbP6IwuPz2Kpx84q4qEv9FdwBXnrJLcb0j9I7asZXd2VNNDw+oahwogbSx5CwgjUj8VAcgK0wJGc3Tf24UedHJsJvLaiQAnSugWFsmi78FT7t/eibNd1eoZRtYFKs6HDQIz/LpeL61PMG4f7v9ZTToZ87iCjY9Xai/V5wQUjUHGe0YLfoIYT4dl30liXRHGUGEDRn/NA3iW0SjGY+MjFpYGhyoZlUHCELRKJCSLBNToQLfDB6MV0ae55oO4dXcKgoS1sdSLMexKIoubylTMSkpZk8oLQjGUEnUxR8EG4DJMhSsIzWFVdTCgYQROLGPRMo+mmIiMsHaBeDEUAgyh/qOHDTJGd5KrmomfHYyA=
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