ExOORvn/gIcg74gTbzUE6kTrRfS57rUzOpTqPP9mdb1CygtcuLxMWXGXHadfbHriey2GCL5N+ZechOyEls1sGABfRnNQvk6iLdliTIQRXFQ0ymmttfbPtMETn84wa8sjEvccGCkaz2ihvIguxqdPJikovsk4nnmjAi0wc3VQHFe1ZkfBxyUvDbq+8JxlmA3aU0d6WX790HSSjar/R901tIvlsqxKmr+Yf4RDCSA7wMvsMZZjI4QPfivpRmXQtZpARQQumNkCY12ZfPlaVkPLyJ15ri6XzPkEDF2uk41okLSfvxmeLvK4mKoHvjOIYC67RcV16qF7GGj8cRMLDNBa9FIN7lW8WgWp5m6aqi7TADImaACaO7iIBgnqIHjYxMn0nTmWUH0dwJ6lsSnmk4/8oESx0Znhru2B0RDzti4szoV+8IKk8wQJPBqyUFwGrCUBFeoySv19Aez8+O3Txp4oF1jfkylLBmStmYcymBH+SH4Y+7i3wJCYziF349jNuc/cYR3TB8olXiDwJHumK7FO7LjZ2wyeYEdU7gQQR2r7of/Ls26dubmJbLCa+1MkPhVEE/MyfHXloTTaMGxbJuBEEE9qB8vDvMVm84oc6SpL3oQDYo8dVFVSQ/UU1klsGZmJJiWLc6yGPLAYYrHnLcMrd9PdtRrVWRle1lKZYhIOXYcdYLrsxY/bgcABOCgTZpYuP8kBQg/0Z4uwy7fSMlCE0k3QIdXrwIFbvHQMlSv2UCc/CviItFYFHC3eYJUlGDTM6Ln4tAr7HsQC+ajDzLU9FwKlwQKZPwET1INs/4nroh4LFSyg/jGY0Ikr7n+htgEJnnvzQIdJHNhVkqdbh/7NeWIAw+SxrrkWvD56A6syJmHNTy3ORjaLmL+p8UGpTKvmlyiJyvJp9QDbBk8g+hFyQ83yyihXQ7+DE0knKjtcUnGGv0x7yiD7dB6b3CKK9NTy2eyDUULPR7LNkLaCcMlD15T700DU7ckHTTsyQATXWElEBY4UUuPvHcKstNJ+98SFmRJut7kgy36ps+pZGmXskVElyzQZiivwPQ2VhOHah3aGqiG36TUDVxdD4ib+7wAPi4d5k1c9pmjrJxdWzhP9tySK4yB8jj5J686rekMW0kspqI2+00GBKmbTnfGC/9KogoeI/OxELPCeyMtPPKWNR3s2pg9qJMBQN+y4YwRCw+xU+ySqtTGU7rh2oUwYoAUiWdC2f891SCVzYyvwiuvonVOqLvI704bvldGEWrQhYcHLQ1EHhk8gAc8gqNOKurXp1u39HdDjPTWtpE5h0Xr+FwRP7Csn+sZlLwBsva04os357acsEY45wZfRgVPnXSnBfbK9INCh58qOjY8ndL2fk1o6QW+3aYbWkKsRIvc=
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