jITYSH8M0eVvvlw7JKT8VH1MuEvkrFnbx5iLm+phH4gdq9aHe8sg7blioaREg4cReL8AzVgviNr6VCrcFj0OzFO4BHij9WU4ErXlg99VofyBBqBi9mtizJhfQD7L1O9d6bh9G3+c7GW/l+ZKgX3SYrmWs0V5sAatvTOTD13vJid9PNOz8ICzwVLyfgScXH0gyM7+ar2IUMR0R1DoSsQervB1pxtfMBposvypUKraXfWxtD5UVNZXYBNhmmoIMtqIOObGqWh49h1Ol5vb9EaYjbYIU0hTYV6eyEFXokvbpe6ISzgo8vdivXMPs/LYpY4uLEDDp7c+o09khLTVEq9U6NZyB6NpcqgPRHDUBJOrtrMkn/Si/jviiX0SXz/hK3ttlRRQi1JqaEcbUTK6fH+1INHAOGpamnEZEAWqgdEs8kktqkQF6HbNEkReKvRnr9VJSDvCIQ7m149Rof8QWsZW7EL3Bh3ctoAY7RqTx9gzIbv3IB2q4kySyLzryACvPBfWuxxs6Y/zMCSPUIey9usCstLUkxwLYzAJBiKIx/sYkFLCATILOIANH1Gdj7c8wCmswhsA170gARWTc7iNdtqjuYUrT/nXGnwn/OZDlw8mzgET40oeCP+8xpid/7P4bMjNrEXcb2cE2093x3hszUKv++tGYlPuAi1CpEcj9/edU2xKrXKnKT8s5KTBXRp/cJPuYqhVaV+WZKCZ2hzEbIPkKYoO0vmnl9azwimKbiYggKN9zNhX8NKE0kCHiYRlOcYjsV3+cubiPDpzSdVazUS9Pod4AQOv8bXVPDF3oqEanP1lZtFJInAM6I0YoVY7GJzEywzuO2u2ewd0gnRvFM93DzNP4EGyVAy2qNHyfTPq9MFvq7m0rYAX+5RfsAXz8kWZWA+l3TgivUfxCzw61mCOR+uA2/dPDTRsecigrJBtChtI0n7FYXWf5VltG1MnT+URQFrZBJVu6oTHlA0EoyVRUTmvo/835m11gOblw4kbrtlxRS8dllnG9iAv6QPO+ykzuN4cSUlOgprFq/RNh+0DNZQPM/r5r0vUDrMTLXcG03fabO9FLl5MPD3IlrWAg2ntY3jUqNadOXCLFgtmO9FfSgthKil3YCnJSVCVGTsKSgQwOYxWC5oNJPtbb27iovtUgE/nPf69Ga34PyLpfEIOeedJTv9sj9Vh5Cjy1MLoHA8UEXjTk0bTOOZMeuCih0MJlSPh+jv5pAaANtHAiUCBIQeQnhnuHsKszBfd1Dc360wiLU89TtDl574LRDzoA5Vjkx7tu4ZLgW5k6ckYeOXlV8Aw0iiz+uXLvXftdZWRq0pWBAugo1qx6DmrrBhRhJquxR2//H/50aPfwHAc1Bz995WHkm3dgTAgnSyXaG0=
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