Rg2oR0Fr2xwEp3AxSqXWVxok6c8a7HgpTF74sZkcvVxrs+o7zItyOOHrRJQVPv+W/0sJQlZFpjlIEJ0RjXNR7OUsMGJ/HYkiYxQzXOgHlkqW+f/fVcIY8dH234kEfZJqP5adpAfI5VqVa67VwIDtz+4n3R1i7HyY4fEOqVMIllciplzY93pheeLPGj9DyTBE60BmJJBuFjS5rapglSnn2K5PsmDdVaDyvu2WR0ClRECzJbUaKhW6KLYhk1wVsQns+wz8M+hbvEXvemYwBTmEApjM2BhTQ4WHTH0L3AJAIyAVKaPslUe2VOPzNpqSnDIvm8/SCDpZDQqffO8EIFFRWuGoKEknGjECmkQtKEj3wR4cWZOrHebrhHPr9X7znhxNkW//+FSDNPG1vVaBG6joGy1M0W0FnFMmHl0Tm1pEhhtvceQoYJ8NDtndB8QnKHum5RcNX34VsIwz2OJDlxclpwRZWoJKljczPfPqcyGmoBjuibraeu1BGwzsOhVCqpbxmeIjQAdnMk5GDTIoSeUZ2VHkKZUMoTAOESox8dRc3uWuaYGrr0vZOiQpdF5k29CgI98anfeAOpJj7YADf18ZnkqkWwEnR5w/M5LHYhLF/NoAjbtmlX0t1BCiLLDtfrSIqq4XZrUCmZDsxPy5B9iphc8+yXrJoGoLYKmMDC+Jq1Bx8R4N7ZwtvkyHnEWl+3cCABAEa1h4uF/R0JXWLqP2qNlWn6KmhuJX2ji2tCRIjvyIMVADuPtgwJ9FndOdEEsTyePj7gcyLcHiAGIiqQDhceHQAO7Fomfo0SlS5etIZrN3Xap5mWqv3E6S0pkQfquaaYOqLLqf6ap+umopg+hSaaztBPwwLXyRY3sUZYNpCiBe5nX/WuBPcs2J954pOJkn12Qm9FgZ1JPbPlnkJVcgnylhTjo9b1qwGHWczDmKizEPF2RiaRiQVDwmJBSf/x7nD4dPiFQ7wkeAk4vRyLZL7AITAIheYEjsC5NHLDWAOxFOXAOS1+r24hBAxyIVrduss7iWnZCz0T3nR7VlruJ9DFwJWaFP+QvSGUNOF1NiFkIlbg3YVf81x0XSfKLFswKjhzwsx+SQllmYMTc3dU0EfCxRAhKbObrwBRgAv3pHon8uTK2IHfNKvEI+Lhn/3sK2434MIA3GSXFtBH+6zoWwd8qL9cKBCEzlejWENe7hpjPgzP7+IanHB8pJNAF/ehcG5TmscuiwqsBuB0LMieSw4ZRVIZs4krPYdXTRmjvjrLjPIOlSX5QL0dqxfEKlZpidS+E4qhINXv9bzaguoRGOeaZkh+ai8k/2iK4JXYLjNcr7zfxRtVRWNRhxON+l0Asb0qVI9XR21SOzE6YiJ53VG/6paVAfwoXfi3F+Qcs=
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