eBEuCLokGSQeLRAlQJ3P5v1Vc7oEKR4tISOxBTd8bgTGgpmF+Hh23F1zXlNQR/PkdkdA+OLFdsrZMXa9bzUezdYF+Fe3CbHHkQDxPRGJBXZluaysVsxmUVje6FOWodRFQXlo5DCPyCCkIWNClZ5WukE1d4vdHL1eTAqNFGXd4gTn5auGgjUD5OI+gu3PDydD1VsO3AxAUU0mk8vMOdg1seFBk0qmPWYj/fHU52+Q0mv8nOqXUYexjkPWAYVaDsJ39u2+hnMmEwdx8LwUSyAlkMctDUJX44xO/9QGea4mkQJkgXybxXUwaxOTp+Ppfg+oP2v/Q/p0BYvtpMlYtIVc6a955sHcmKpwjvXdUyfrv2dcLD/YBUaDUrM9l0doHTodYwXVipUYZ+Qp1TEGJhO0lUfZJ4Xcmca+JgycB68qCgLJAi8TUok1ydnzEF5a2jQ6BOSXXWOsbuT6B/7fuXDPXWnvV3p4N9CZwPJodN67hPX89IZbOG5cQFy+KOOvxvLvpiV6IbmsVGnKZxDnjrUyLfC7SiLzswo/6zfLDLxVW6MU2uERhKUjcVfJUdlqsZ2BLZiFK5dj91v5r6ZjLMEr8lnYSQZleB46GccQXb4qwtLr/TUH12EbpdBF1oPUzOxR6rDsbems18y3ZFuYzZyiY/q7RTlW19kiJJoqV4rsofkzNZdL0e+O+EnYbGNTCtVjZrUgM4kR2V6c7vboUJUWczhfLa/fi6pLLOADLuuGY0yM6In43yNONZRzgSt5LMRd5Ifqzn5KjzHSBhfnOXDieJV3AhKv3fK/hYQ6ZndiGMWEO/jzjPqeTUtR8/ctfGLAuLV5LCaof3ZA+O+AEHd+O0jEOrSHXKEnNU1z1PEEexBV2vuceFcTw46gmj16rC+WCBc6cBLwzWuhuynye2adsKDwixu2b2yU11bysc8aXQBUGTL7RdZc9rR/xu+ReQMlff4XV6yjK9KEsHSPzGYs5aoERndRTSuBmpGkfZMznNeHz5rxtxB7vSYu+vl2FJIK+l953qs/Z9viTPfbKzYHs90bplzppGVWNwI4w6hKAR7oJmEUjsxdEL/xD5Znsfw+VlKZw7LBaSlyQ8dRyOeyVf81gk/e5Bt+kSBjymESP3W9uZE0GegbV/SG3dWrBkug1Xw34SNDSFLqZDiUEaXApU3CcWAbpvGC3BaI8Bhi/L0HrP7Tg60XPM6OG8Zdj3uoF2iCqOXTEjNZ9JW9ex3YgRAN+XAvJF+QzHRoA6RvryJMx5ifoUBTpqNujvlH4A+cN+YBN7sbSM0vpZ069VL1F18DR8JDTJn2jF0ANKTDkBSQykruep0AsvCrFDVnS/qcUXpOLGiofXKje/QCDhblyAOgAxzaV2/8X1X23a0=
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