bCPtWkmj6nYBuO2RzmSbF4hZdZropOOD+hrIbIOzXNVPHZ9cC7NMlk7LtlE2JwiaLQk0cIFq/am1hgKJa2Ld1j/Kgkg79uyj40nfgBK3FNhzZti6LgE1CIkQSoeRiszJ3wHdvPiqBfTr7ASK2MhMk4SWXvfdKxKJbXtzo5EjE87K7ppi6zOIDE8FN0pYRMgmnEfLzU0Byj0Q2bG9RxE9JdfsXa8V+LAzrOYi+9wKvXGaI6bXLN3EirDmDfSZ1AN+FAH3w8J10E58oNYihk8bN7e431ym1amWSZrkZ0WmTtbeY+xxRrkHj4oAfINFs5utNlFy5mvPK6k/KZorUavuzWJYl7X/bsQyCsb2UKDMvcvDnBiIkWVcH9mQcHBP66mYUCWgk6xYgaKguTSIRQOgHi3HRu5GwORhMRufN0NrFxeNt7fA8AT9EoRQSJ2V8t7xOXZLy8VaL6VFcGvKwbkoL4HGVITGAdt9XC6NS2lTVAxLT6r6Zx0N9houLOfZq6JFP3R2CHVKEsmedMsGEf3QCUukvwUeBmxbU7SlWQD7m0bao0BzvN87FKBQMvhonR6lpO+NfDbRM4tEzi+2Q88uOIEadNCxmbi3kjD7b2KeP4CsQYgjXlcw+eG8P1sOtu010sK3j97XSSPmOP0nhS4LKE+bC0+a5qS+ANG9aVNlHPFanUEylPVJXWxaK5iaw4xWX8ZC1dUrnudA1z/45v23RRszUn32SYqsiorvbLFb+3ciUsWJfaLWvzgzttJ1M6M5WoqP9iJJK1FMC2i7a7zr9QRjtgFEI5z00GQS9rM0xzdr1xUttCZZvf8gxV4GDt88bVTDL79UAyiUmObHHcGnAEsRmzmBt43I1aRxWXxxBfAyscFVzOJftqaVObtiOHu/NRu5dXFH/Yfj9i8Aa2uKa7uQcYvvtGlxGHyyYiBs2tAMZo4IVEbDjq/aDFUNXwT3bfdXtkEm4A8eYmpBOkzEK3pJhDOb8dbtt/Ck03f2Z0F0+JcjMaEH2Oz1HfKf2g3qnXchXMyplmqnB6dYTencdiLMyJw5lIDRiwxPp2qv+20SS3J0jatGKEdoTuqG7xlZtVL6m/ZkqKxw0vCBXzGhpiHRuD/dRM73m6bUfr+X8xBICc5lsfAIH+nTOS7rdaLcTeIm9KJmmUU7JTkQ0SjAeRzChlAx+S5OBd3bMlZRdexJ0TIvSYyf0ur7FMEVN8JKze5FoP04z9JTQHMoiJsiuUcFKiaQxqTd4ae7ihMSEQdMzW48iQPosSn1EwaQeHr5Wz2/zrcdQB7hjmPXaezz/PDh135USezWPhKaP1ChaHD2lzCekKFE/9KLxkpoh07oDVM7n8IsOYsInjdbVVOT4Xd9eQRfYBaChRXZTlk=
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