sKOl/zDurvOHjTzsOw/7WPZqqGOnmQG17gFrQbcrPQvW4SPRKRdqs9WMU9iQKViGzV2/FxK6x9s9GVp1JNdU3f5TTu12K+XgnVZq+ARXsCxT1LiVt+ejNXSJgaRYeKalqeuRAKpiikpNcHCxJLG46IlMEmCvgVk4XOCzXbSDTGyQbj0ztvPjtbxogXncjwle9BuoW2h3i1NO5lNN0DV0ujyp70GZJehqU02Wa0ZKzozoorS+9w8Eg4VL4gQX1/nXDGJIUS4rwtsvmeVGKz0L1Yqzczg55N54ALR9Go5rrUhU2pmrFT6hSG4b5qgdoaM1VoPxIWPctknr0RUofNrjrv4Rj8tqAY4OzYIA1wfvWQ4buQ+8/8YzvcItU92BkqheS+kCRAjhbEaqf50U8ddoLJTghbKUNjuKl7tJUXDrRKdu9IaQm2eCGmCZgZomEelZ+4Q67y2Z8nsHKWtk+qu57bB60VsasczBBOq4TQNGbjVog4+i9EzmAkOs7jcffciDEKyZONRjEm9WkKPjqfcQXO3mjN192RbkqwRBfFOxeRqf4+qPMPEw326utpiF+t59z6tYDRu6WWRurxwtb1Am3qIO/DsyeTl+3yINQ7L91UgsT18a46ywwVYJbxHGOLPMeVc/lI6QtRDtsmRstWmVkOgdT7uzsyIYCGTbBOygh8fsdKq1B0a0PzcLrBzUQt+KnjArl6GmHoqZmomtop6yntOlxbGXa9FZl/S6RT5dMmJpN28MgJjpYIGCIOkAEKwQavoNDXKLK/ajXDZoXkWDxtnAaovSCYgf8v5liEvmSanPHZgPfYUZ/rv4wpFsjjeMb8zk2273qzFT65GyShM/abUmvowNXgNXuLG2G3ubU1d1jJuvFta0aIH69xOeJ4pmtMsZqd3iwsWSdgxt6+M5ztR7gPJXNbD0PPopNjWIlgd1uameknUmaXMDSDrctRQcQ6+8m9Vv2I0XN3hfLwS5uyisV7SUnpe3oFWP5Nrjy6eYvNRQ5qiDx9JLVJ173P4EkEHCx1XFIfARWHuZOz5L0RKrsywItltLMs+x02/E2eCoB4WXazAWRs1jAQBw8PoUjbyIn9NcBovKGXQmS+ev+g709na5UoXdTnqDenIHcBQQv6Q0iHhXxwWtzVyKMloAXBs91+W22eGUySIGysVGG1ooN4mkEWd6MEGLlLBA8cXRZyiKpMbmWtbSeCu1QdeTe5BiZzitMZbHkwNpczxasD9rnAWEOypEFPQV8e+iyrc1LRjFa22prKPmcPKOIdOx/HJQVt+6EUHk0AXklN21fA+JzNoUX46KK6u0eVXEwz4XV0WNtE9pJ2wVxGSbPWGCNisYJb7FWdE41Blr3W7eC9ey+isKtTD8edC5qbU=
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