cMMGKZrnJZI+3TtoG4r8YA4sT1eB6TNFz/2/PjM8t9zDxqIsYV+ORxhn8fYZfIMvRKlKKL4vS9H7sDxT3ZahSgd99G3bvz5UZKqE2PnjWFGJkhJO290ptfDX4xNZTf89M2xQd2AHeO+Q+C6c7nEPsk0M0mTZQOZE39FZ4hwoWeDapg2huXlRGGQ7k9UfSVsnNqpztXn9uxOYnUKuQ6pAk4PHgvHSoc3g+voA9ajLGbYdegfewhCmOSePHOwcdTLVUETWmzxQs9eFLc7wXBoEXCm5xn3jL0jGq13m5E8Bju1jaHqTzIaWNrxEQP4amwD+byvJEbLHxpthHijgleIplodjjGeKPR5hCmiT8jDaz6g80G4xddPFjh9esNkqI/IF8Zb+3D1QZy/yKxAqohLFF1Ald9O287SmWRiWy13xwdBaA+hK3eCbcIuRJ+JQQ+BjSkPs701eWShJ+WYr9RwcyXW5mzhL0N1r47ssagKbhPi1b3CwDvcklCN4ujt/a2mQwcTN7k23UrJBzx8r0yaPA+6O9oAR8ez2MySV6RfNNYb41C5VtFEDec4Q2b8mTLl7wjUC07v7aj5Z/lRjF3ZaRtLaSNNhz1gWGZ1C5ZTqM1NHmIk7nHWFpGOYdoDB5vlBVh8m6kNLRj+0qByjGMDDbjozicdDzifoYf1YH7sEIisi1UTDIGwgVjllm/Dd6ImuetSjYoMay7N3PKXM/6gmZ15xVP8yJiW7sNYvpIqBAWM5P5D4pquOfi0O0JqheYUAvZM8Hcy1wH28AOnT0qwVW7C8Q5tuvdAYPh82zeCkIfF/PQCVewX4RNcf2rqGdeUvfehgn3tAW8nMF2cEUzndn0/fMesIqfgRzqBgEQCS+kHZLt/LJQuiInDjX7BNv4L7fwKXKRH+s+Ufpv8rIJ14HGen5iNJlmsgkfgRyhojt2+SHIcR5LJHM1TljvfLVMuGkCRl2DelxHhCAPBYGQNDz0pxtaABvUnGrSep7XVJXGppIMm0iqCHt4YMK5/v9OuPRxD0XZrW0H4jap6Wl2AYfhg62NWX+TBOKCt1HepH5gILFUCGdGrMnaYyOMXH0T8c/0O99DPk8JsZLXPeurAXSJJ1jJOhfZe3v3kr0cU3pUVggG6V9MOEqVZOGVUVS6Tr7zx+fOdhE4d31Wsq+n0uEKUVNwW8/JBuqln1ErYvFKBm7vAbC6TIAQdoMfdpAxf/bfzlJ99a0cclHoJWgwQ3r4I8h4eSIP+V0tFLOxKjvRCUd464Y6EioLB/3J/XdPfk1+uBfZ6Y8K0Y12BYvWPr+cl6qPiJuojb/ZkIhYZA0uk0xfwsIZM7PLcPYJ9dXzwdb3xeZOd4Hp/wSk9xF4BxVJt9ytNb7vZmIRlikuY=
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