f+cJRp9qnjVu1PkgYJZ8Qs2TX596YpAfimSsH11UxI3sKhRE0joUXbisNP1qenJsiAhLFRB6/qwzxLsRD41nO7p9UuHgkzGOx1vpn53Opm2L1/gCBwkuaTEE4mMPSCAC9HiLb6Qa6dsV6KuwX0jJDUtOKcQoAD5kAwI+VcytlLE9Uj2bczCEKxQwu9XijWOEfxQ78cgzanNWicEGULvThwAkmdXLKkdMJrbAo/oLvZ2IMzr5mYvsZNuBv5XoSOKjFuHyPE9oa0mqNfkBcPKB4T1BKO+3exVctIki0iPBQbDIv8ezbnjCfv/pgGReySIlRF/VFEFRv+vJA3KLvqjxC8rLzKgNq+TgPWr1VTJzuJqVgzBmgZ5T9gZI4etu+tq36AjwMoxy9Zq4QqrPD75Wu/sG4y6o8xYGxmuXArWZCTCrXLbUze6KBZSYQBnxJiUIGlD3/Az+L3D18R41pNOiEKpkNpCfyn4j6V2qZhcDdPzTRH3yTDIC8Kn5LoS9ENE/c/ldrQ2I8HwQqBeS9S+oyBaWgUUtzxQk/NMlBvhxsK+joydxllqfsrogf5wNynXPat8ABC4Gm4xMV6bYGJYCxVFWEyd/AC3rR+1g2G6jGtagdDN4lRXkZqYgU/boClOhCP3HC/a4FYXUZtzBfDMKiUidf60t7CopfkjP1FRy0YkSwM+c7TrXH0RE6grE/5hZ0fEqKE8uD2xZzBNxhStz4Pa4Sym+D1yVthUXACe8wh4prJ1TV/oYKSZXWd6Ho5YJLtDEutu/8xyJf2g8YAc1x3fRhXACFMuhAp7N3ykzy1N9AUsHG3ozfbjxrIyJON+lokY540FMp9irEf3GpWTj1zlx1d5AeI05Lg1NCb162qxejUoMkeOPm96tnVHc84Z46k/lZJEu9WvXKt7AlvewAfRpHa4aihQdKa9iVGDrDqqehb4Py44JFnJPKOrlmNDDYcWdTSROrhsVk+5GNSNv02BRaNvlg0hK2LuDe8jydEZ0nFt4HEeQpFZCsouRNKlOHNwcDBn+BRcs7C4UFxoNuChJ1ax3M0xq1j/RhxXuV0F/BYplqtNrxKJWku45vpBywwCfr7N/fdrBuvVAbwclla3uMxKaSzz6RyEP+4VaqfGAOg4+KKeLzYqtTLx7ivKiEjzlyfuoQE6LsdMOQnznSVjvM/rWwJ2zXUKhNODS9aI0ZU3JNFyvgNzOLreT+8tjcSsvfZ+0+DrPNBWCIaVQXcs/mVsxNGGLgcRI8UjCHVtsis/qjVOu9uX+gsm9MMZAvLAKElPlD/e5YBQePhj/FofVaDhZ94eOdYCU3GcoKSnqEVFn02KE3HBy49rDvJgdm9rNJwCpoAmSEWmB5n8kgJh4QEQay5f/iAyALYU=
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