zt1X/QrJlDYTY1RgNS+PqRGZ+2ncMbh2GnObk4quTqkvf+WJLeCd6O/BjsWXpVZ+U4du2yTwlLteuQbtxa3vPwC1cSXQYHbub9wYzgxC4Do+AIL10pqdDkDfGG/JWkXtQOIvRcGzqI4MhrvvQ35Gtrjs+jxHU+ZqKlf3AbPJwRi6E34siSs2Lm6YQE8pb5leVqLlz/SurrinugZdeoQXlNvMldBB8LsRfosiuep35DVYYC9kogV9annhtgZWpfGilVAyNtL3jYZHgNPOkFyMSalxnuZcwQ/EwKnBiW+zvR0wxrNmGShC5OZXobBnVcvk9iFUCzp+MWJiCFq6M9/c4IZKozbEkitZaB1tuEBCsw+v0S6Dt1doN2Ox57T8BVh8iBoAEUPMk+GcvnsVoE0zPCdmoeFRQj945iGJcrG9aZo22TppskSseZlRAk+q/TVab/q6aWvehlXPppgxYF6oiX0EI5NNL2zDNi7Cj2h22wqWhAuK31d/a3z0oiZJGjeGtgMvmEnQwXwPYaOlbmmPqFcuYYsBVkMWjAMRiRpVPaM0yGnrTRmhr6nPvDYImwQ+yL1v70oPuxAlZCvNT/XrSKHiN5fiQrsdj/O+74lZQR/a0YAZg0cEz1sF7ROMvcXv3sVU/+76D8IIK7BS7vynWsXzRM5nn318zSnMrDoHIj5FVaixBG59AcrPV2n+It1Q5aMv7gHiIlq4UoaRzhQar2Qn/mpihf1THByPAsDgzxJW7rGYQBTAJ55CaahEARQ5n3RJkA35oCT97WdglTiWiHQSzoNK9rbTvp2KBbU+2LSQLMAoqSD8T4rG526pqR68BeapNxMyX9HRsVD/Zx9KB7pqUC8+Kobu9h/E3e0xwBnfe/plJ1TUmJ0lXdlJtsTsjWYrNvzTE7fbI4Yd9jRAw9H2AiGiyZpjAs4szjy5tBwJSMkC7ueChGbABHQvJjpsHvcIrlZvSAjx+R+1MuXzJhoDPqdjzIA6tj8qprlZP1IztGfjBQ7XYN3M/D17nW8bzDgn4/p9V2rw9AENpx998MCT9qHbvq/U4r/IJrIxMzZKbk3OqpoH7dA+DhpBcP+1X5fuvGV9OfsiO9xzrpRa7YEejJBJYOBNUNg68QNwiMHT+2Dm03XUT1u4D9HR5FBoyUdJwOdv0HUE/gK2vLQdgJj6Shb2iZOnHRuJKgiECij89Y8GeilSBTbqEPU/yNlrgKYJIcz8/OIqc0V6As1HRPPDEq1dDEhSD1AoPFmKM1bqZLa6u9bo54m5YlrZc2ZFHCmZuKb8mZQuu96VKI0sZtjxxPbGLgyq9hfyYxQzGl2ZInYlj8oj3iSybmKDjY39Xkxi/CgofDPXWweeHwQhGXqefvrEdEXVXtFZBco=
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