RFPhfaZ8jCn3+RSfDrh7Z94h+i7qxCqCeI/e1GjzIqWERUTx4iNoDoOJsL6SzeziXwMESw5/FL1AAeIJHrOUtP7p3zuKeuheOaRbzheg/5iI4NhDp76DPwp5tr/gkCo/x1bRo//E6Mtlo/SYSij/Ouu/GE2jyzknuLwHdsP5lDTw7yT64ZomUo9lT+XKEcUM+8DR7ni2NLv2pjopTct0GamyuxV0rg2QKEXTZduO1XDR/Mhb+1ck45xP0ejcfS+eMLz+NUzdeaOO0k1pFPAzJ1prM1Gw0oZqeFOYdheNFxEs4dePKnYNLoelTOZHd3gE3auOMsHUZUBZyHA+InyPgIBmu975ivQMoe1vPn0wTeKoKipWtl9R6ix+0tyoDleITO6jYh5HeHJVswLMTB2IAulWZqiHcsJyLvpuhV0O4QCLw9YpyqT/ILDT8OdtpxqgNv2m5sTn0SzM9PHEGVOm9lWl+X8VXAGACxYBk//+X/sZ1OTQVz7gT5geL56nBg7IoNEbmAhG6M9KnI4rB7QcZIENWEev/13Ff5NaCNBCQNazY5YFylI4z/CgEllB4sUcQphBXSx8GntM8h1N/RzWfQXmVkbWp17LMRfEpwxZP7RpyQcYVUkVwvTyZIMK+GSNC3eS9Khy9ldm8AJm2plW2hFsH8QX3AwNjHJ1u1/7nrHYmmsAOKtQSYyMjV1nyoaYEMPsESyrfjJf4fUE3ndKRc9O1ZUZ6p+o8VuES60eol4X0LxkW8zf5L0Fwrcqprgg+gRpDCmbz/lB23Ng7Ty0iYDkg6cMN2yGMkkv3i4TDwimttd3wO7pdrAwcQRafr2i/u2IyLP3axZEtek0ieTncIKVUOlmyV2KVpE50B37vzKJXP/0X6awwWH2zJQQYw2EJyOY5iViZOSJWEy2hMb/qzJ+DMp9yW3NvT//m110hh/E46g3eVjYA5EiknIwfhAB9Whnx3o2jXP5+CHQ8gSKG4XVHXD4u7KMp7S1OKUJ9oc5/LDuY70LxCFb3vtj35m8B4fON2SZcIhqEHmCH0kqpwdxrS8N7Z9W/pnEpJRHf6aiLWyhCY/Zw6SI9fu2JxqeC7z1AbETA4wxoaXhNjFHpGhH2ESkdVcf+WcF60EHy4w+e9i4dZXZzptYd0uc/m1qlLvBS3DRfdCajflnhWFwBXn3FgPl8Rug5g3U1G303DMryNMtcQmp02f3oV3DxcQBUGeuYhXeklSxAtnjJBsn6vwC1+WovrHjucEdFzIwWb50kr+K+ZfhDN9vN0KGscdebeBlrdMDQ9KSXNbIKLE1XyrDzxZDEXVaWRjjXz1GdmesC6hqMK57RkJzKVsKRn4ZMs1wvTbk/GUTcEirx33hiAJpBJJvvUO4u2BVYKE=
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