WzRcIXO7bnM1RUdoZAFSp3AQZVsqp9rNmNC8VwC7GNUVfsMCuUklaRnAPr5nqYVweuw393LFTLdUYxUcK6iNjlKh9Gr0iThmICFSDQsGPoy4JOo0eAnORVnb6JMJieUdta/Bc96z7TKfl6jdCsukiiYE5gl7AO2Kc7PWyxCpBRDybHdmtSHBf02Xbl8n70APVYsmYxgpr/di1LoTxjJjqzXcbxuxPYvitKN6GR5SQuFRENgK7sp++5Va1PBpL+hGhl2twG6LjlrgW1SNZ8slCUvub7uEVV61xPnMNk8/ZufUkgvT+sgINQ1cRHEiwiG1uVOFwL2gQOrvDlC7GGlEWdGZ46Azlm6YEn/0qGFO3jtNXYDUrJXRHWc/vvAZYYT+QYMof32pdQujHQ8KTOu5bwPJx8yYOSoW46sNhjzeHHJHUjrYzPkcJdjD93c6L63twrqNpueZDh6M7znJWP2mBjMMHN8Kln9lC4j1+2Py0/BZq0vN+MYnjhnohNhZ9Liy15gy7PaVILDcUJIeGECZn+uqEUEYXoZJvpiRQ4eq31SUQEFiseSLiYCm8OJeg25/DwvEXoBmfbhWCIDsfDsP3rk6bV6tggoMS1/Yi4ahuLG1Fw4oIMqhStPJNzEPpNHUMR0AWHuatiJ71ZQLbV6r0HQh+zUEV4zDLTyRbEjDG8T7Nz6iR3hKMMXhneeqtdopnU+tr3xtp1jrCU5yFqiYMjfTOSMPvUhBcLL+iM4TPiUtAU5XP82yGg8alpTvLw0GNATcZWqbEGqZkZliP6PFR0M/yVrYQscl/p9j0646VfcybLxGxAu9A82VOlp/yxMzzLjvm3zgRMOhI11h6UVrw/0jZx+0uPxdLOpoBLg2R2NgxNAZc6YvSemzbH5jcgvpBXvy
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'
GROUP BY et.id
LIMIT 100