CEeayVZjL7UsDTKkSvmE2z2f1xtr+9RRCwMYbke5pKldmmh8eZVncRNVNKTtcNvtcQn5CkxSe6Xd2TuacQ1lEIRLn2g0E8jr/R/ZjNAOliP5LbXtCcJN0tmpRuYREUXaJ7JvKiklLiTFzBiSv+cmfzwGqWfJbcDKKd7On6X29m9g8PRfkNjYJq6dmvTAYoXCUx7szc/5dlMlXesQdTJRfhFCuuqPJzut8RnhzCsxayc3AxRheL0itAuRNTp85OkpnUORicqhGrfOO5b3XxugT3QFcApJtKvcoj3MXTVx8IGuQqIh/LTUuec4ky6Z1aME8jkxlVQaH3LtxVw9b0o1Sx8JpH72n6XvQZdqBYxca4qwEH0q6zW70WAFtm6NRo3YQAgV41EXiHO/rm84H006NOJ4776d64FtweKVxdrOzctsR/JPHf++i8QipBojGL7gKtybpWRwIcoQrs41OcXiFTrTaKiO6ihxsa8EIbuD11v06kl5OSB/1lrQlW53KQeKC9LchMWcoRFC0LN862kkmdHqNDUA2cVjiPepTD1AqyST6keQyGuwd6oL4MnwgLF8wFib7JFlbXPRzFX3z7tNTg4A8gGxTAFDuHvZJHU8tlcjvJTUAolll5JLMRzHHq4MkFA/QIUhWGRJov/qa1uUyl7aPHsy2+T4bNv+WMYoWk4ILUFq66fda/NCbbrt1dl7rFPtfqMPCqxqzewMzXdn40o7med44EmrlDoi1TmHfARZ5dbAVYgmR050dFm18GgElOyUCL+OwNxUVOBnHm2oana2b6LiK48S73zIHlyMxom69JvQ9XKz8VBkHn1r6s46UIiR/TrU7Uji4lZ4LzxkIicLtlEtzeTkSQzXVDPBrtF+GJ74Tub5XZipBf4qNcC+nTrgkWUHIolKpigE6Ar2II4Q4ywZqlaFeMBMpBttNm7XbTHnSMXeouotIYc6f76K3O1QiAmo1NM1d4737N1UgZqXy8FtMFs/u1pwjNoqzSch3VGkTsSQoz1+g/3cRM3XfJpBGnUlj5TnRm1qXuI8iVw2/5yWalR6WB/KHf1ruOKC930V1uepjj7Q/PQgVpi7HqIIqe4BY3tMgdasiL38CFkygWGqoXkCmH64Elj0QUaU/b27MXB3IbM5C3uK99pi5jzFwkarqKA387hhEXj7v/ngm0NrCNLTVCvX2wB1hneUPPPcdXC7sXU97z+e1d50pIs8ld8vtLUdVQC7QmH57TclFsz+0KOUO4E9gfzEDw98kB/RO8gIne/kGe053BgzuBV7asZzbrG9h2D/wsoLK2RgktXFwFsP4JVIEobh/e58r4SBGei6R/+VFf3O7pmXqCwZOTuPP75Ch7YfK2TMUIUKdkbbXT05zvHXGYY=
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