wV7ZSGxq+op7MdPfeDVqSBKPpH7K2ZCTnLw95eYQej+eHO5nWYz5HCDh+CF8KZiVAsS8iusjAcGvgNDNOpprS48FtPIVqXrF7t1VdepD6405qBktR2cQuQ1ls0OL7orjV4LsVpYmWlDHSfBMSvdd+cfX2319hnFmBX0X18AYxEnx6VqyW74tRh+/73s3lM8a8MvffuLgXKjuyk5PEDJOaMP1vx4RByQ5zgmU2tUg6mP8G2e5CcPN+CLBlOb2ZPd3kvb0rCe4gkJ9nlhnbJo1NBTXz5sadwAftkJILPeIzQosbDWVLyzEhgiaydAEHFEfZsCz6D5K0+wlAm9tjQwNciMV2cuvtmAUs5D4HLeqlVOIUPGizOXRGt74y3u88adNBAtzpjxyrEymSj0hSGt/3Bi7RS/4BCVQ83kZ4Zh7IzQ73MdZt5iClfocreSMobsPo7lrZJD4iWPWk9ITNDA0uH9eObBBZX6+P+KfnUKZzkvTeIJWATwRMTPibD4ZnUybtqycuxZ5hsMdtAFVY4mWcCd4DOE8dJhaKM63GQVLD6tGB6YkEPiAU98+15QlzD6sVKpNmp9QxqX6XVEy5nlL1RiJ4t3/WV6npCFjRdfGKlqiX8DScf2GeR5yQRnYD0e5/ybIu3XpMhE1FD00XfSTZOmz0zzPKsTtQfgOIcbM625YLojtsKPYaKFSGfVg2bJK0nrhxui9EQdCs5tSAaBMVHLYkldzs3q8OGOGUXqhMacr+ydSG67zneqN3wI8vgYANiNV6j9xymESDYoraUiU8aSZO9Bvc5um9ugjd1GUXFsM79ZusGVB74TlJWAKd4e9K4LZ1UlnPn1WNBxR+k63N96INqnnGsKh2BthMSb/GUXjlzm+Pa71WNxJIYBq++x2db2BvW4DXKrcOUuEioD21MXnrFdXwcmjesGNNO1PvBuFVMHATd3S5hOAaqbv8HYkn1bLFFSDksOs8G66NnwYhuV7iFpRke23jzTEMOigdAR23bpdmzSyTw/DtiHqercDY7uMsD36yHxqHwnQC/l7LqIXkw/auGvkkv+5VQi/qxg3jS6YHOfVwrI2juC+pIg1itlLRwzW42/Em3vArBC9xXeQdQqZ+w1GIwiBsAmQCfZKifkeM4P0ZaUypH4pgDBG4qCscAzXiUgICMIcbbrrZmsJh4AK4gUD5F1Chzrwdx/GN8ZawSFazR9oDeCFVczIqzZrjFqMt5HeQ+I+jYxc7xRSreTCNtBxYfb7KKLBTW+e6Q3rEQRkx1qVaQIXcJtQfnITsY+EQAJyYtdGWos4et99M6KL7wxiEoKYHQLYkBOG1hUzNde4qy5ViYI43rYEVHKO3UBnLQ5HoTVRhRSMSryJr0ATV3m0eWjULJc=
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