HxYajekVE/UTH5gE8lAuMuXMIwhGY+02jvQ6BnachTzIGMbOFb5zWCWDW5U0l4SujR88yxUIv5AnwiyPrKeQB+UFV9zzvRb7h3NVBDObnpiG5ntfnri+BbF4/Wn2oFl9gjKspffccQNKHKCuFN46WHqiLIYTPzW+fMaapaKCA7Q1pJeXCqTFRftKJ9YouOuuvawZY8kfwSv3jXwhlu0P8IoboydSiEq1J5ERgJAkd+FgT9FE3AOCD3LZalkNnpEZQfAvTIzuCiUIIBVDPjTmpzp0nrQQtSaKAX8msvtdakuSwdP2DJsXgIPs2KUkJN0JDhNCnuNMJ63lx29Z0zxA0YDc9MYjwBaKXdI0+QVtwBXVFLC+sC548aN7GBlfaSOMhg+4sh2Ovx1TsqT5eZT1SYYP8L2UNHDvQcHefjXTHStWR/uN7gMiL9iERlGXbrO2Bd/7lqqU6R5J0VlzlDyB5kvK30+VZXe2Oj0SaOB0r3j2/GtuUYVt8/BIhB+TGynP+BktDLN6+oHygtbEq+Lm68ynAaYYYMdMRGmuJoF5yZMRWAg3zZ6OGP0Mh2K3/7Dset7/xDxikESRALBLirjuJQrn/hA5WIUkKoip0WGtqa28ECA19YKRJaV9FFM8M5imfdp6PhKFfCP468Z7Bg/+hro4xGQA9FqaDrjtMIZHcNrnkoc0UVm3Su8tGdvdADFR5Cdh27D0u6Yb4UK8ud+VhNVqCB0xzRiO8hvhd6+2uGRe9GsUWlUxvxzHf2G8rOh9d8mmPS5sTaq8QOHqSTsiwbOxAItTFru+NImWdWCN3JBZjVv//w9iBt5k50hfj+o3+iLVIS8Yk5FccMKBdjXkT/N6UA+w92VlHcWDhTvBRi4y6y2HOo5fai834BpeaoLsu2pJn7lILPCzfUAUXNljXjJIub2XtwMUS9O9OGQRX4tavp9WrNg9qGPZx/efekk6E7qpS0vp0gMJ04UTSM5szTXbKFafHRKAyP/2T14lEWlllUHm2M1nF6egZQwPSIKcT/PRu6HPgkC4hNwXnvbYro8KjfRJJEhSnMnRrvu9M4FAJm6vqcdoWcJYkogjPeBZbAdqJggHKVu9JuE9h+bWeJD6GwsYYMiQguMok6xm/J6RpgtHOOm+tzBEh4QjQBqZ5EUp8hBBUO1MZ6vcJPDs/TaoWSZ3vA+VkZEQwBw2lpzL2PWk6YLebxR/gs+AvfvDoDmm/sSP3Mj6JBLJ8AWVgoPeL3YdQj5VyF2I3Fyez3W8f1WfHSzuSHWnMX+Cc1mg2a5EKLDkjwfhqeBSh9lhuV0yPmwcNRqj1IeIhbhZqYOG8W8Weu8jO2jJ2Hy5dPasd+F0qwnbuZ61ZQPpEzDtEEioN0LZwXyCd6ShdnY=
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