5YsXhwDm9k68ns6Lln8IokV4Jzn809ZPgqdHh61hZV4UCzwK8ZRHWx4oNkMBxulQRnGyozw4zns/rXX2W/gQ1my1OuHnNwia7mliNRtoqc3rpor6pAt3iDtv3/pp1w1cTolCSi/7oYbeZXku2WydfZVNWG5UAhMn6W9fz6ssfYfx68NbSGL4ZhPJ1rtOY1Y0PrVsDQ6w/9LVu8MjYVf00jekTW8GFzXSJIvCcgN8SuInlK0rS1FwKepjCBng0en1y6YktyKuKLe8IQ7CAcaYY3fW7Z/J/qMjj51zvRQXu62lgC6NXOO2t8m6fY0wenViH09VMNqYZvB4OZ44ucy6khFHaRZ4+LOWfw71fxmp7LNQWJz93KGwJ+WAlk1Z4H4/0A9EsIfS5ntdLAc6sRcOt2WzdYtW9g7A1QuLjv8scJuIg17o8dJmYHKd+515LeYOwjw162J+anBUUG+FxALPn2VQXsnYi0/JZ/IuWvoidZOjN+Sm4H0gPFH+Ts8eVo8wHvafKsqUBxCiRXhbAK2gxtUhlvZ6/HZWIVkAqSEM/rOIwf9YsNPSM5Mkp+Y2awMOCKGo1MrLBBozwZpKJRcWGY1f9+vn8TdPMo+7VOB3zxWaFVKxer//OPCvWgqH5NnqrS0mSgsxFJbb6SQ4iFF9pcB4nwhKdWmtO7XqYIg+0slElhI0T4xT7r7hOeSJVB3OfWXsGKylTTVGyVkJZtFqUsyy+pWuHFRvkcL/1szRLPl9Mhuk5iZ/Dx3zciRO5Wfwm062MbtQQi0e1nXjPJReC8pgSmTjymkmVMbo1qedizn+xhUmFxM7FOp0hTRSmOLx2jaKDi4NOh27HPFSJcpjKe7o/2xtY6U1iZStdgi/JYtyR0bzpVEh8Am9+eonlAbDZvDjsZV6Uc97dvQ+20JjemfWAN2wy1RKK1OE5RDBdmr/Ww0huPaddt+dYuUA7I3kK62/cPLHYVBk4AbyT0xaYw5z1dnbzr8g8KU3fQBJmq3D6cTNv/pMr9aUs+roKdPH/BnXJ3gOlFP06d/OBTbGVdmj9tjin6VVIUCnDysUoe5N/ozS4pUDhRuyJASaFXc8R90ijvKBtK0XXEcfgzXSuXnUaLHmrcO3BJ8u48AAq6Dh2NQSqQ/CcLMd4g9UXi9ffmWn9v1/Eljmpu00eICbhY/TDbQL4q4i2ADbmvlLBSYZJYReIzWoxrIJQ4sMUgYb4JfkBp+a56QzR4+o50KQ5T/bUoTgRO1RFCZdiLItja+eXn7NCkBr0V5NFGwQVvULxiyWLiAsTaP9rCXMFKNeMU8DnijQB7M4PWfbo5e6ipjHNw5LfTbMoWfe9LoBqRmvNcR+qoXSVQmHT49rE2+HikLQGiKlJgrcSVL42vc=
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