AeIqkTCq+H75IVORADNUE55sWqWVn/MyWRdoteEdA76uYxSKIG9kjZkB5geJ4IKcInaOJ6bVqlaSl0Se/FTVf0xkYbtXSfn9wlRyFE3KfMInlkL07ALjEkH6nn6qog4/vYRIGboFpHfpMiX4ijQqCOeAikWCfWvO96VKImO3v0yp5IGDxOqPDSgtMzUaiUgegANQ9NYKu/tbY0Tc+ajeWjfSHuwBBovB2DwSn1oWxmZAm64egg6FX+CV+lmGwTKRXE7hjOnEXqcPJ/sjO+/H1Ecqp/Bg+WrpDFt5SXo9O1OZCo9MRwkEln+dXeK19AZNG7JYeQ848WA1pzzD4UZhIehR7QOlLZjU5Hd0WEpqoSht8yxGPVdGSREtCLY5k6YgRvvMvcAPOg7uCS/7plCaSjEEadXhK2uoGmf4kYQbQYpuW/pwqScTQbdb1lU9kY8gkjQh8gxZn6xXssm1S09Rkdp/MT72KlRfz9aj0pJiGU8W1Q1naqONZ1eFBupt7LVRRiF+9/4jIJ8eHJcDB9LSIsRzhUd1VdOl5iV/umSnkW/rlop/9UeZI/L850yxRY2qGfke9v0abJc52vIR39Ppx9G03wExsl+4Ce/1yLg+FxLJBt5Wif6R38h8y73oaVRK/OXU+zMWI3UgQjET3AZqa0tJnx3Yx5pXh7LVRXQF/EHaVXbH4ZNJCe2GHKuapL8KSMCG+54x46z849d33lrpRQpPMg+iQXIeASM5TrfnmHZlGT80W/rbNCtglzBecucEGCxl5nY/vK2y4Ke7Y+ihMhOewzK2gL/5pkm4Ec8RI+GeBoH/1GX5i9J2i3ZLIG7Map2R0A0YEZ9t+q7B3lyo48ljza4WMXSV5kT7VyyZ6FGQRuuw/eW3Yy0Rqp5R9KivNFbrogxFo4VuoyGNnHFYiim4cEtvURw9KCM0aGE3AkQB358HML3IY2hifTrZd6giebKHV2eRDHnHd9Qqzjk6s27/CG+e8HRuKPJdFpSp8iUkWFRppo6KZHJDKz5gs5w3wT7T0jMhUQXiRWgIw+PZ9WRDTGZ4ad81QdiBiSUWgruXSa3dhqj1xcWwBbP7wsbTa8SwDDymfxSFhV7U7wwneYLp9XK7dxKM/+KnH3RPhIHP1UQPVcOADf0zRwg3lbrCIvbvdyDEYUic/9yfBNcfGnFHUHF3RdiCPOjkSICKxm9/CKjIs8wYbS1/A6vHry2DBNH2D8CE+AqHH/M6669GfERqJYMYjalkftmq5Kvqgo8ziP4QDbjjJpIUsShEcbqaIqgpid2cU6SpRGT2CTihB0qexuBGDubAs3U5RShN+zzcsBPG16dlVcO8aC00TDioSYQKEWJZbqu4hRlF9pTMPSJh01OlZ5t8JDfR5iM=
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