WMAJBlJ05XJ3iVt8bl1a7Jo7HgqM0IlXrXUShTvVj8hYUdNIilxsrLO4OuUlZCWJ1brv1DGxjOD7qchndjdS5gxZn2NiWZP4nMlNhjLN66641LCbRopTYMiBUFcFzzzVaVAg/TPbH2Qx2/TqCie2EjumJDHDtZTc2YKMasseEbpOvUbXvkdPtzU8iEHVkZcJikCtds88Ofdr+gq6IlXnrRsk8xHsf754q36Ny+KlVMCqGVeO8t0DiLt5SvJjVxtSTsYNRFx6mjPXPhQ0OVVW/1ORtqcF2JHQbGkWMtarY9ANOuC0xxkZhsuGlrcj7bPCZ67bnQDyX7FaqNfIR6YEJQQoJwFvPDnINlAgdhwW7/LISKXtwr5IeL8xxeG+g32Z+SgSma0CG1edGjGzevKoiUbMpFhthCB8zKJ91kTrmNlELYqpLl8jLfiXAb+br4KIZQ4/JngHHyrN+DnIxxRTR6RLxfeTmbRIfQ19/+zLpkqAIEn3p1FJhAwb/xLndhAEZRKo+pZzwBepiqSfH9pJH3FxccMnyglDsnKsp2TR0AYt5E1A33sbn+a0hfZggnPQgXRS6EH+xgWF3NdcLO67zEoq83taLiwHVIntch9q90f2Yauuk88nbfZGVFZerB+d5J9bEuIQoWdECsM6lPXMPIPolLJfT3Zoi4rADaf5FwTBPwnelmvhL6wMDYhf97zBVGmb4ilgGwzm3obUAPd/l7YCS8vRnaEnx3ZgTknVYgt9mv6oT4jTf7XBWqDRyl1JOw428ISVq4hlSSfFjVjTMQqkL6yZo3cG9Jzmep+ysMGUJZplbUmy0x46wnY7V8Upbo8mdL2c9MLNG99N0p3AZnTApHXNn5+eW1A4nv+QjxnH3aMZb3d0GQ5bWcEmjOgdQyyOTnKe0IkdKMJcE+1pOkm7rmvtz7Cq/oKA4Ij/oJvsiDZ2uNck0wjr07r5y37OGrjMl+ZpDJcluwWYxqj5RKD2qDqNExaiKxrD+rvmfzRvaFWkZl2LNFuMo6WMesFzq/nke8bWyoASI5PskNpBtCR2I/4ZMH0oVOvoCdmrgkPTHTbDLo0NZ5A5c3PPytslrmVB8FVMy6KAfJv4q68ovInIrLfSULs+c4lvoJYiou5xFVU3/L01NJK/+Ij9CL1hxwKSP/lygzRdSf5UtjCU09QpvE0OHM0I7h6tvnx40a/UwX4yUozS8Rb2/nNjjA08bw7SYU9MRkpzim27WvGqQ/JBwLChG7rF0FCBEBdbJ/9wWbOyceLGszOSZerA4EzwSN3AGvbzRVt1+2RDUvcfNBhhkTdNwRpRuZpQVCAc1FjysePzQBI4c3xjt40Ll50bbj4fm+R004sA7t6kU7QES5C0wTI2eZ5mIOXj+MM=
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