66Yy/3W0n4ye/vnVhnfwUmZ1iiuFSs/yd0QHC0cZ30rl3r/7R44LqZagENMl7Uz414EiP/MzVK4/qtZkDxqIdsDuMgu3OC+SFdMepyn7LLThcKANNvWTFtHL8iH6w2Qr4LHpKRusgYTOlLgn3u4KtdHAsgHkpvrkLeAqYRWqWibIs/olqJ1XOltyibDm6PIgPx35J0ys5/HJr1mpjFJHXPFTrSKPBgzNRZZfhas8sLwnqvd6EUt0UysHJBYKIIVd8Fbnu/2rr2ZxszCS2NbdPXJpEx0pTUdSwFo7TaApOrQmhwZi0QZKnBhJAcO5SY16MgQSFuIj++FVf585kX55AEKCqKgqgbZuadxZJbbr6a1NSkvCzsevht7Yv6YP4o1tCwsLnQLY6rJ3ENGOC1D6Me3Lw5EkPX9xv2kKLaVa7WkqpnRPWFom/rVbsOChH/liudQPAPTOjjpZ+GmYPzHG0k71RzujTY0cJibjh5OQ9UET5izUYkkKBE16cZneatHf6i9FLF8vZDlm5lBj6mJ06AsSbqbk/E+2Qbv9IdF7rqlgJb07eS1yIbRUg5WfL9s7x/GCc8ffMILu7YsbcKuS3y66NGc+1JTdbwnwxXvYlf5Hbqgh3+pG+B1ZdBITvyQdFzJkLYhbwxzsOuK704KgprgNGoGz0Fu0gcXTvgiCaZ+oDN9BQvRFta7fG424T0dekiFb7UFsstpsR539pCLCgf4WZHzea8gbQWhs0u9fmmUCZMup0GNZNS80i8dy+QfAqIap9ImIRWLP8PJsA2tA/y6VI2ly92ENrZym3zqC+frkuq8cM/Nz9S/CxUpETfjdUCUNCoWfvX10tr+KLbgIwJpnYocDAW/l1RVIVfvvp8gwfVQnEb7rqSnNgVaOwUSj322sEaS0gpLI9xZ3VJUMb/xkQJG8eywCV8XuBlM4vDEaKVIZkGbxIi7qExqVkBjyeuNqegLhbnzOQE8+vOwwAoI/G28ksmu5qq1YzLkyGXkoIupaO3UfKzXCdO8WnsgjHFU26mDuJ+nZ7tUBpl8ruQS2+EpMjcorWbUbZL8Xei2RlpqlYlTPKs75mvFcaEXq8W+SDHNNbOgypihTTCQuIVp1gcnkwyEjyX3c7P3zT45uvq1j5EXOlgJee5Ut9LSpVF277cVUxXU8FcHy0P0A13hBRKsZ/fFra9r+VrpbYyxDPAbOJjiv44xtmjvLbFPSO7j86OXXdTYRKE4X1MN2ElOr0e1S1OMoeUqUzrnFUblwamRakmTE5K74FXZjlYwgCQCC0ZMO74SKNi9ohz6neHF3E69Gvarq3ghoyIZ/TlPTUcR89KuzHJMMlZVfFkiqH548qR/dIZ9p/LK5kEwF61KXZ43DsIwGFjbqO3s=
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