0L+NAAgtt656nkJNs4ZLZSmsVpuXHpa98DBMo65y7rXKhPwuTQUmr9ZUdakjcd4bXl3rAETTk00+CK4Lo3Yz0uMx0l6P8XMf7ElBUowXGe8cXvvzIk7bGvetsaYZrsomkhn5P3Ub4Jr2zs74M1YHfxKYGQuu8lut7baHuTzqB/4L+tmvW5J9re9tFa1tPtzBEPBczO/uQR4Y5VEEyXX56Ry+fRqGxvPvPZ8CNqVETiEyA6wOgGsl4DUjs6NraIR+NVlKT+Q2IytaZQIZ7JqdlBbc9fjOpMBBNjSTJ53mf8avPOuECNWuTFeLwtZB1I9C9BxlE0TqNEYZaGSxx3J5wwox5ZAwNYL4kAkpsihXUqmU+4OKWqWTYDCD+SkRuv1bzzErDhkGk4zm3pEKIsMxTZz8+v+mCqjfjwq+gUGCTxUkTGJh0pCPzJ4w63zXVZY/VH5HyqsxuUOlYPsA2ZBzZNrL3qogG0PgkqvCHw5cNYf4B6XfhfGoPw5d5eRgipLZLvz1EmYp23HZdYZRY5XkEs3pA/zUOBJzkgDRssUcJqv31W78v/FJcGUaT/g+sx8qVTvNJxztopGbgzJy/86doOji77712D7qN2UK5SkbPnOA38aE9Tv+ywSesT2mzaidLlkOaQcBZyOEqLjhM6PNpUE/lX2PhgFsr49/qiJIySIX31C9+An2fuAjUcFa667tHIpQAuKZ0pAiqW+IMkqEH57u9MXgmS5UdMjI8fdfy+qnN5NfNjcpAMCYN8kvbOxAKl3yVD9WdpH/s7Czo+FDMEBNdrW6OQq3KD05vFpiW9DPUh3tWgjG4j91YyZ5Sz8xryWc8iavJ44Cq1bB9sAvaGl0IuFxPPFeeGQzUVJbYJalJ4xP4/ODgX5SFax2LiuYSD2/6QR9FDtQNNbUUnyEYGR0FznLKkvH/gc696qPpqJNDG+17kswZwZwakB6pCluzJIA2jw7JupNcTXzwcbNfdxGeLZ2K9BltnwSfRuq+RvdemnSNmAq3TI9PynpYkrOlUpWwB6nV7A4A5ctul2nwnYCIwvfi3PjvBSOqM1QFSm+lj1rCCMTjM7dfBGc4k0k4u5ZDMEvg12/gkpFGC+to5zUzjYI+Jsh/bwvCsB86iBg/XmMmy+ITHQdMUm5x0Zy86o5oCJW6i/m6tK8upMCzk1srNbdQ28co6DFfgwiWEBAiRLrUr01oC2aQbE5wA3HKyEdoaKvc3BHWk5mefeIZdigD+0qTe13A1ACsvn8o/daMfK+bo3ml8pMLl1Zf0Di/QKIxQikW3FDHLyIflLwTUYt7O1oUB/L4HsvTtJELk2phK+l9VijVH9JNT2c66XAXuJgbQl9MT29SYTIuaGas+FiU5lD+t0CkewNdic=
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