2POPceMMf6wKxUYPYcEHrWQRcuoTwHvZ/y+l4vCLYzrDj/cfONKHct+GRaHIBLZrPIs37s4yubHZPp4C6Gc5TH34LS/rZqYoKj/sS/zdiBCdwvVgamoQrabFuoFYQIgUIx4TlPSh1heMhvwzJ54uIRsORUxiLqHCeI91OAp47r7wo43Jy7HfULcklUVwbhmXid1SfzgmkJqOBEtKaZUFQEl15wF9M0mCwC/hEBrmy9kf+XLzFG2aa5fQ6bb72lnzANNyGdO/KVSOryYc9cDEJYdz8zRRTpRFQOTGNEh+3hcuUXzOQrt8nBXKLG2uZkwuUP7fNelkN6YI1Fx1pwyYtveupQPZI+azEIpbPGtVWrcJuLh33r+iupHgdTwn4Af7XqEhSbe6TuHktLVapL6kU2W9rMrxYLuSKo1vAA1vMxK1wVZrnXuuHfP8ZOBmt9q5IvI0tFK2NjRxbnrU+c20w5LtPRTuVGhUs1Hs5+4AgWABN6/wS9LwyaQF0XhW9jeRJcWSlav/f1fuvCegls2INal3UYH6luQE3EjP494bdbwXvPd80grPrLmWTfplgAMeOHzYAtIekz77cU+JefFaId9V25U51LvyjsJbhGt2EOthzycnMRvofgg7MJ4ur6WlPs2zfzMD1Iuqs1dOp52zZRpSgl8AyQrulAq/THvFtNVoowavOvYn+AX0XaiVbnUBKcF16HmEy4pNCLDjmSwQ8663mOAbs8QtXDw0KVrnXwiVcOr8PVLsXYi2rb6FML/5qj7E044Mc+gmHrKxD70fw7IkrZXJSra2UmPTTz78l3T7fGaMNlAMXDC+wUm/axww1ZRsay+Ugn3Jb/ptGpTPBPLaMacWZNcCiBkHR/SzD0xlepXjieFWx8zCsDxQ1+uwBKBcPNYdNdly+HK1ChGq95a6ZMhvS5tTDissnqrv2G6aBYrUI0UzodUzZVw8BkowqVNEgs2ZZaJnPuy5IhnMRcPe04fgsUWqlQbI8O79z/hCQNZoe+qPRTQT1QgdbQ6B9wJEkmw8Y3/3djePPL+T7xjdiP4mZ7VXzyvl0IyY6wZD974E/y/4H4+aLbcnUtDUsZ/rdATn2u/0DUC3UAG5/QzT78vemq+crdG3n1h7pg9Le6AJ2osYi+F4PGEYS7RbbAmbXBYMPSzdG03kz3xaJ5Gfcabk86y+eF0NCI8nmzq5S317rmgy5kTyy9OOgSq2456S6+dhb+cIQt2ScxPFXV+rLWzNaceVOx/H1oWN3XSpABdvKDe6ZsFiNb3SlWPeNNfeIBCg1YKkCBrP3LgAgITBUJHfnvm+XJ9vOyufN1WcUTW9L3oK7/7wHDS3ZSQTL6TXQEYAbfSdYoNsB8Crda8BgqjyTMQn8KpzZDQ=
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