7zRit1JwAUwipYkbRrynKrt37ewEXDRgiiHiYnFnhqzX9BlPoOUOsPM2kzU+kCfhDB4KEQt7bAhbBF1dXAvLNleto2tkeJaO6LOhgiw+40q4AlVZ6NC36XOugYgQmfTa8zyWEmfCnz+nge5+o3jXt64DyzQ0n9XbUDyolJAfxHZhLi99cez/0UsHDJJdaP+xjrky4ip+ORZLZJTjvDXQbNlfM/6fhVZhQtyEX19tMGPcWej/mCoQ758kdSmEZq6FXW65shMl62pEL1zJJzUPz6RYkIQ9+Sap7QUOJoxPomZJcJGmHsy4eZ8QMLuDZ9AOd+ky/FTZGadkhEpSWdpt/B3ZbTSSrXpfMFoTNlOXbjKJ8jBaWHmZO2aOYXQLLqv2elikxlxnuucQ2CsQiOFz/TjAeae+fUhsyZ3ZY6HdaZceuddTqB8wg8wCx9GhhqjTQyrtmpexZCNj+PRdLlbk2kMNniykMdyqxeU/TWd4HGjySTKoDM5VdBs1ODX9xH9gJiccovvNjymjFeHYoPxfxroLn8NMMj9tGORvnLZ91pTline2ghcT+yZv/vr45WbD8coMKVpG26IspW9FYMCfeGbkEe9LNs12b6S0K888kUEaf6gXWDvGZXIi1V+yL4MYcMmd8pWaskbeYlk0cgVHoEEA5nnvi5coz7DMRr60jfZIiQ1y7V/0rmN/sQWOtyHiUhOFpDOh+ZWvAttPSjeuvOB2QmshPWVdG3wEhmo/2ItfYb129Fn7yQfzfMTI7uGpH5Zv1DSeYQR7CWFIkaKMhhk8nBJrFWUEoMRmjmjTAwFLanC5uYZ/FRAhcrhpz9TsKJt8Yr+1uDBpIGrFtGZkNoPSpTqtbOpywSm/XvmbAWw48O7e9hKHtq+gUyf3714LszgKT8hDAge1DMLyElWiFD3e+tHe6IqF4zBvgdyZbRLrqxJ4IplzSQKbai36+uco3uIBQHSAO1oZrhApN0ZgoBwSzoI8UowAA6i8o0mbOE50oXLmL7foUA+6s1CvbsqedycGvKSoGecm9VQaFyFd7Yn1oW4sLX3iUdM7kTAJNw153z6kybTXai9L706zH9F3DJIB4h7ZbmDmRwL/hwaQkQlFMiMWmS6RKexICro2UN4jY7PkrynY0ZhpiP7w7vdUD1E/i8/UQBzoXTpYvYB8aTEPNOk8sfOV8H6xgecFqJR47KhJYQ5t8G4bh9ETzsFx8sinlO8aCC/nae6OLkoHoIUOi66UKsl/NmLQM2Fhy8QONhxgzBt1KLg/xMiq/u3QHdrhA0WG7JSJWRKPTaMEnqwsScliiVF/2FSeK3BOJI44U7W7S8FZWtF18LdoCQxBp915EVqPjcLDYDLcRWFZLa2vzXY9cToBgx2brqM=
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