5FrGg8pZ9adx0PG/rDxW132r8+nZFQ/OdP7jWhl/rbyJUGKC9EolzWVLfpdSSMD6OJ4/CbSjohzhOyRhbALk2g+w0+WQ+wsDK/1HQFplp/CTbRh3cA1S/tA1gi7+Axe6ilRm22aiYRWUOUAJw86epj78H/scaG714JZd7fc1fAwnYf/482SsYh10CPVioDRwNfnkQwEcBUWp6yod5n6cLq9EWdJMqGKP5NmROO+cs8rnWVtacvqmy+hdWs1dikffeeHQB8vWUDGjQ2QDHGCUQr8Kq1v73ozhqdFomlOv7RHAjgs8JzhegfhkNFiwPRAu6/WEoClPh/dCihWHnS5B68FCmPpega5GzEMyVFu5koFN3mKQ19mh4xxXfzbWAyCQjsQu6fZSpZxaUeqAHATGvjpe6Lcsd+A3BX/5hSta9HIL8g19N6/17CJ5RlR7xfrQXYp8JUaLlGjtINUXyYbJavAR/iJ4tRezdjOMg0bdOSIqVzSU/mDAhJ+MdLNw6QT8fBMkRfJ9sy1MUGzhakRAZXNOfj7KDJmn1TSw4bAmXQCu2oGjj81NFSIkcOA0Ik6nX9vi7rNfYJI5/BNFLQoaV/of1kWoU46IZIJ05YGD7gOXZkxYhNm6jLkOzzuU0WdEtNYdUF2J3bBpfW/O4jeqO/+LcorL3wdigGIX7qMfm0B7qnEDaIBbQ5GWVoEwLeHJ0mpZ9GdDL0Me7t0O17/FJT6SGoZyCxrPTvG9FFasV9vVsXa8zsKI9PuWnPM63TSbAP16HTFUnGAh398ert6qOOxrLbH05xm6sadY4ib7KqTJrieHCdJwx8iAj3zDww/G7EaZsIF+zH0VJQXPxWWJOTq703SNLILDoONOUj9Q/mALGcTNMoAzj9DzQnb6mKRNuDcBQQORADtHHL9QoK/Ky6D3ye1/sHoACvWcNs12Z8bf6z+pZmAqrz9/O5RuTFVFo+hrGr3D4n0qSfebCloCThOw64oC/WucRzlf6w/kUTMYFWxDfXtSJgFle1QoaaCaK0KW1rUhskqWbPpQdPMB/6LBK6zm83H94+mPSE7iy/s6RLSGmRrC3Fpzlmu6xCqSayn0O6V1FXUxclHRN61St5k2E8i3TLcWe977AnrqjfYNo5fk9jRyut0J3I0qFFDTERqv6fr6K83ieo23JlOmkS2PWXFenc+a49dpk9SollS2LwFrHNGSmTgS4YPYarTpUppaok8vGsmyhHfpm5xTW/SemjsulhwO15P73z3qn7ZCScc0tg4Z/OuMDPsklbvFbwZA737xRnnXj4IxDH3tztKHDhw7oRK4HtMvNTHGgRNhmsmZfdtrv8OFB/J6k4bHC46Gs2dMwCkZZCPj5wyUGYT/pS7dcH7yus588Ks=
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