747cXw/jbhszKWDdfKw0jtY9ZWgEwipDWjqoMmYNC56Ya3LQ+wGabLcfOr8tXJhFiBZtMuXkRKmf48kYLq35fByp+/EdDEkuO6CQJJG39SVCXBcsma1gQS0HtceTSCdSNN7DKzTD8uVCzNE+I2CjmORMOy4hpLQPG5EO8iMZZUnii4j8yyuFRKWqCn8jmjFb+Hupm4i3WQP0oKe9TOy/ceC3A9x6XVWAHKDMACtso6bGDiu2m9kRP0yiTBhIgPahKADfaK3nEzVN/4g6p0ipfal/A1vmFd0kvP+ZRDI7qzzxnW30FGUC/mNqhPzQqSxI061j8FTLXa9GoXHW6zrpm/SBbf21FegK6IqcOPhvTVta3vxnL2YQsIHQyR2+aZ59156eVXSaG3lDNtPFJsx29nVvajILvO2h6WNHLu1u01AzSuPZOhRHBQTp1pxBFI6wQrkQTgbTBBnta8sTX1lIjVHQ5WbwvGAnAvxJWjh++NGpwDMtOG9NB6lxaqSLjd0Z530n44BY7zfm9IHiiJnJI4vRsLXPp2ude58dEuqEEf24l5Iy4JHOCm/YMfsjzZz/IsMJmoCCPgdRroTUmen8T7Nq3sIKv/I0Jq3ujjNUTb6/bhaXqDHILRBNgNIlndZ1IMnzjFUb/C5hAJ77yV9uOsAJK643wsq0ZHEmZwE/7doHFcSBlDPUDigLqaaYWrFI3tatOX+m8QaSKmrjdPrs0A8U/38+yVw5pyTq0VMPkziciGvLQYhYsjdOiGoUKhGq7pm+0kNw/5OzqXeA9/SBWgN3eLdnDzeKCyeT8XCZ2H6joPSF5uysG3w4CG/GWzOBaVLUwIffevLyq2ahJQpcEg2/+fHVhDm2SpYhqBUbdOMHhI7DEtfYHM2+iuMJQNqWaiVcocmjqhLnJVl7PKc9czLcaNq5Npulm/2NpqaULN197Mw8Mevgai+iSYcUWHvAVMkiRfI4zoKBDA/3XBr3pQcj2nxrMdIZm0xsEyMsTt3KfCLOiCj7EqTL9FEjtWoJpNdENMch0lyVwbFE/l8GYbVObWweklIchxXHC9x3PYpIcwsfslkWEFtOOG+gET4i6w+V28RV3atODz1IDhHmHdLDAA7sEuC6ddspQquvz8/9JP35kYl10DZR4up7dR5HwkKMh3KXG6ZUSaaygs4LCobFDtDEkOzUWPFCyD9m1jKWkwnitagQWTOaCRH8nE5ysYk6vceYU6FOqp1YtQfpPbyyoou6flnJMAS0Vg0QOuQxR2ryt+ufkfqCM6OnG2F2WFd4s2FNQyIkQDAKRZ7wuBIoAsCnLx+vXY/lNUP3vOMaFC9VOyWT6tl3XBqtyO3/jkpU/UWRb6zWl5QAw+7lvCKJ/m3oTqMs7lDarKk=
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