zaWhM0OS0Iw0N14HPW1Q9Mkg/7splHOO+iQ2IwerTI/qLHIXW8AWhYX95aGYSwiwHikup/w/VxHxnLz8Dl/42fxd4Wt18bVAb/QQxlbZGEcF0XI3SVhbkWBtJjt5WB4b9Gw9klyZ3LRO6mtAVSqnDoE3wopNNp06BekNK+75fMNR1DkVyJpe05iAZsQA2mS6560snMQwMYgcUPlsV6GsTmy84ZVHTeWr7d6Vv6u9OV2K4tZQl9G4K/lGyGHb6p0Y0b61XT7bHx77cXqHShxUKdJ3sZKGUfH5xOJBiowqnztGQnq8N+6mMRciO3aZc0Qi7Lkm0kkIfmU2FstBRdvXVWIXwoHm47SVkgb/JULRcN90ZXbUOCBlse1oown3JtzaHOrfF/RW6Te0jQSZt6CuqKqDb1C4ceiYHoPdtAkk1zPBIdkCVflye+84GFbTVDeBc7blpPBvUK1i2E0qkyJNUikNKAE5gm6bNlPv79PT+GnVDaK811yEvjio1qEM123TRQAeic5zfy4FQ/aZpk7BV9tjpkUZ030Zo1828RcdR5d/HE9T8bXVLWLPgiLy2gLOMV2cf5Q+p6/6tE8Ldg+nE3f88hdFHRPQRXIbIbFVaHcwtpIORLfHuXbnUoXhMpOxwjLMe6e383syOYZe8GWNp2hkv97fgtw2Bg+l0XCbXmR9NzdVdPkWZ+th93n5DYPd6pj5AyxtYbxnm7s2K4v/8wfq8cMgR+llMpTjEbS26xHsXQ8REGHRxbUlkABGzC9qQezR2aO7Jf9U5jPD+QDH3WKDHA546jUGEiLqbpC+r7DUFbIsTlAW0ENru7RuaPQ2RexIOq/nrDl+kVHg0lkHZJeq2seLwyT7szc3nrVrvzI4/TPsDROMVPDYAme1BsxbNgrwPaATQ9n3iqfFQB3WrITMfr/y21XcTQEfx5ejBE9RmQT5urTpPK/0pQ3N0XVIm70b3xRkjlQsSc0Aw+Frn9mb+G3Immd87nbebtqrzA/orDY4uWZ6v/NB5STIS4eo688fsr0PWlY6xhqlGtYfvu6pF1iO1pF6e+fmEStQ2XLmYU9CYKzj86r/GTd8Ei2DEAqlOSCQQzNPsOJj9eD3d8J1nyHpO0IBDn+rWqut7VSY7Q5PD8i192AoE2abmzO5k/wHOc/Ls+61eanq5ERGIuWKn7iw3lXkMbZd0VLPEVDDT9XmB+WuiMcbHuNR9LM8nQWSWSQf7VRR6T+54NBNKcjFk569xjw8YI4I3nPCTnAUz8L9sg7bd/UtmhIc4DUF9eyKqNU7NOhCQ6aNkDNXFS42e2b8Za0QpblqfDD/0fcD1eH6R5oVlkI67X7u75Ud3aYCh0fx4yP9V7OJLMwEx1wiC1zEyrlAV2mmcM0=
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