qz5fJxykYHggSMRBimZNmMsMloKsvWBAQ3sDY88rUH4DrYRIbmRiyLQKwBNhIaeU+M66qlh6OWKzHHP9upF9ta+KDUENjiJzxPQMz0EDUUoaleOg/37JYwtTLSPdOXmzIbKYQKxKXBGXjU0kItU9LYLCbHslxa/PJBglx4NNphU/oLw4qbiV4K/kAGT9GmtBxtQgl1a1fzV1lm8qoDmb1DFBgsZdemMEK+el8WeDIv2kEVUVMUa2JYs0LQRhlOg8CXz8c42fmsQZSYYEJe0fu0l24rJgKp1HeahKHzkPIrfRk7wvFKlhHS6SyTbrbAlZHAwCM/J6koa2EdgCjJ1lRxRKzUA+ekaQGFqOaTFnLbmqMrlzRhF89XJBnp8zD1eyIvXYALX5KWmPwK6SyGVQwYrUcOBOOB8U7NqKxBfpNqeUWkMBzsla7tyyL7xBlg+iq7OQsSsIZ5tx/Iqu2lecAG2L2phUJRRxFtpXjeJoB5HLDzla7+gVtAY40AC558Ay1fHxHGwND4qmxC6XXBCh6APO4ccDY1Wev6uD07B6duIwNYnBkK+NPeS6o20eL7WeTXwlz4+32VDBJuhnhwv86p90Sk9bTt5sdkBHUvtx79X53gx6qCVZYCDJpbH03iuooCuf7Vw1uzA9vCrU9Vvsyp0jxBBFmtYI39SO71/JuvacfEHnRp/lx3htbsWssRWgk1DRF1mXGYIGFHd892WPo37rIdCqvaRaRn5GzjpM7SQU29yRBzntJg21KYetcUP3jdwZelwSp5uCyRE4V695EAS/LthsDk/0KmdG/yXIYoQJsIUwp4E8f0spXGmkUOh35uP0hlU5x4sA8IGK/6ezG34oHBLyoCxg1fqx7SqvFQxpc1WGSGV9Rr3BxdGuLnL0cYqVMkhkxzfZ0UpqIo6sZDxvewliGoLh/06DnDPl9k82UqF43ZkDqgX4Aq0VMhqE0heLsrTyUV8g6GnPwc9NYsb6/17aW6JevfQyPasgs3B5xPxo2uztyBm5etugMf4zgE4RdL/iGHn/84GVCxT7cW+9UD1vksiYZIuyRQXxUOTm51CmCdUPR2pAsX9ep2/cdI8lZynvcyHjDo1PWkZaMWMjGhqcn2eslEGM/fN3UuHZBfp6F55D3KaGIh2r6hkdgtryiMxtPs/1zOHm+L5UXajTAavotZuQ3PDLwCJKfe8sAM0Dg1HMafQrWIe/y853DQWKRro6KO3d5iyNQUAIiz7JwNgDLzqPbsWynhhmdDb1vYrraS/mIPPgSNNzLiAs/6QXGhhJJjcNSRyiNT4HmrEVza1fD5M2UHWWxgkea+e36T9Mobw+f/yCE9oXpi3UvezecrbIAzjUVoBgBOKEqwdxBrpK+J8NucSsMFs=
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