RhAYrsWNswBFuMLDBoZIi8G6MiGYILdNmLIIUcrsbgRHUTFsAh3yqwYCALDcpysuSH4JUQ600Au/6rASnFa1T9j4dDR/VoPBt6mP86kmT500EwYP7C7zNodBiFEQ9kiC78h5ynmHkwX8q9Dy6FJsOnPwntbNySqmnrr6XEQVtxyMLmDytMHIxMDwU1EIDY2Vju6cBf/3EBewxlhPFelsM3qQOgMwEnnCnvC9WB7QMRaVK0O4qY2FtVqlt2dIjWCm2EZdcUjbH0toXNgr0cK6KScgkPo7QKRFN20sw2nDBPcrpQHOIXy9K2A6LXAIzy9CVs+jHVPS4A45DDMqxVqpSQvsMHxqfc7uxs1LRB0vYdxlmNaYv18zoqjAwao3gifRa8UcQM3u4M5rSpffN1oktGo1jhREyykUudGE5IrY43T7PmLhFsfXu652QRj4wtGKtF90SeUi0TH6cIPlwLaWBpFWunXqbCHCcay73S9NwOxICDMHETzgrwRpeNwm/0QkrXN5jZ4+NH4OoJwtbSS5RDzf4MOHfbu/Fed+AVoDMpaW8S2AYbeUVL/kFU1+BHKzmcgvD7tTWapdCffmLzJE9DzTyk/r1MmbtF+asnEGm7iikDVMqAoJ9Zf411IkUi8eixf22mUvLuNsa0udGrwMuAWbCnjvs0c091PbP8NrjHS5l8oYGjyN5uvRtVMVrURBkcUtPOKpDiZraeYbejfLYb5FtU4zW3j36fSNRNZ84LddEESpeMPc3g+Oq0ucc2Lr4pVvAYLozJmmb8q5po9nR1/ERBfReZEeie7j8orvGrP+W94qHmfPKdlFgC0mmDpUBo9AiYLY/NhU7OuhLDPcQp4Gq877v5Wh+4k7ulhazK8w1DOx1rNPzgnKbvVBEwo5YYE2xHQaNWiUfBGtT4FiFyFm7SDXKGA4VYsrJNbSFokGBCzkg+0DZAvoKzmSsBRnjLNkpaR3ZPe3ZbIKPRTkBdRQujZFL0NRLhsgNPJQU6NyzlR7A/fi4sN9j7e86x/4XpNMj7L6kDhqB0vlhFihtioDLoLwe+G3WurmtNuzUzuFNcwNk61oYnr1MJg4e+zHwqJdDNC82iszy32mAMlmuGc0zxOD7STLJZMb1Jyaj6KsQcnhQIHC4j05dGG1fgTtV/zbr2fN1T9leBShpIfSOGQGmDd86BqrxvY1/Tp37dB56icVzjSBRjwKK0L9/RYT7VzbjaaS9Y5XJNmn3r2mbc+5269rJEg+jwuAZaXoVFqXCYsYkLoyg1m/TGWNgxkS/K7PRYYaRTU7C1+5gJcp5kvDEz+l9dlyEnNp34pMmn/hXmQS9spVh5qDVUVRFLt+PUwMfzoAhKjGn/i6JdCHgMHSOfUk94/z24pJM88=
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