ugeLAjyxCc8rWCvoW9fQKMFsRZHv2fz/sb3AaaRsWnlwFC4uWdN5ef4+KKfm3KGCtJ7U/r0Y+v8i9FOYtC4LiJcBQrh/8KpJ6pWaGNB39LI5W88s5Qk+ebSxOYgJpBTsYQOjIsFi0zvujDhR2JZljVENmI0dQd1UaGHtVKazjNxgkxjk9w8h53N7H+PaUnIQTEss96RJtwnzfHVK1zrzyBtRZM1/Dq+o36RbqZiptFO9n8lrRQztGxyyeMK9J0fBZ3NrhcitU5jeIEnWiPeOeZZa84iflJ3rcBiZ9ANLjOqBiTS9epdnywBgDMyZ5G9w7gblusewqDBqiPfyeX7jN/Bz0cNmF6mxZ+8sHdBb1s2Gb7Z/ds2uDYh3vjJbjwuRgT3wGoFvKUxVKlsKsJ1xtuGCS5l9cmly6D4T/7yp8OkX/v8TwFGbV/xs3Q2k3eGAp5RDu8zaOCuCkOXCqMb3kC9n6T9tM6wUfSeSEI6Bo8VJGILbcO+1ZFX2Hnd0AZubRoicW3qxV7qu9LIejR0yTt21jtTJeXTKGJnt8+F6fhH6pNFC7UFoJf8ORg4uW3rtQCZl3aDqG2ifLwLiIJbZg8MbmKDMmit9sjSGiU0gsV1LzV8gnVYFS6+AwwrZmAtR3R6k2IOmc/ZAHf6PsrA/iP+zBQLUUki2MLSgvpI0LDv/eChWXWwiuUH843uMF/ytwXsgondS8UC00OSBi6qYt9ukFSFTJRWGDngogIjahgpQcMRLgP5xlYPh29bLCD40KtGeJMs3SywcwmQ3K/qlG2rUwx2qon3wfZZLioXAldHcEPlSdw5jjd0HTzvHFRcj/9nvFndPcZ80PT9LxlmIC9g9qBqM2a+OIMjX9fCHRpIbIaDNBBfjshGVnX9xjxZwIJIQ4xKCQdDk+inlNLvO4u1/mS4U3uaxW8W61ELHhXwc2hSZBAbmDgZoZ9YIIft5JTljI8zksWAHmtubf+NRle1rXGk/yvqR0JInJGiFi3wjwlqYccxWVibL4+K3BgBAIloUKF9g5J30Gv5yXqI5jgVQjxUWv0yZLdvA06vhiAUCBZHm+J+9hxe7S4iYsPCsYCkiHZwraHN7P7wd0ZHnGLtIv8NwXBRYZAlDoPgyQVXde6dws6ZfD1RSOrGcnsfUo+BPQl76r3lzbSmORjhXFLUn5BWilrqGzHMyu3vXpNaTtMuiaBJmGCQT2y0lHCEuYRdYaJyBi6PYQK56nc6wckMKJI5G1qdy3tcFyB15Hxa0Ca9o9PfhMFu8DTBXsjKrsuOzkBy6tISy0Q/kPhvTGINzpM3mtNH1MSJHgPmHB8hQkrG9rPVQtjBIpKEOgZmG5SXGOngLZVWT4nxjeupI0nbVhO6ZtYy4eki8Rpk=
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