VGRTGQlJ8Z2fqWMjd8a65H64J2ksjtRFLg7OLsytr09Hb/e6T9U4YP+WfDOKivEdbCUsU30YezI6zs/VGnbX9GPRjfUa6T7JtFGuTWkpie9ipYF8Lfr1nyVJEf581/i8ssDOxOaRqqRmLbc6/RgOMvcfkQ3WlQnVGe22qI5PL4kcxQgDWXfvhgmjp0ufqULpE5hPgeU8WYWuM+DxhE3UhyWI/oDP1zqed2O8SAj6Zr5xSx+JfPE0zHKbFyWYQqbiUp+t4lF+Nj1snI+CEpkcCsUj/5w/jICH2wAjOeNbv3uorVml6+3gvL9Bzj+AfmFW7gSEQZC6IgUk1bFXb9HsyQhI2pmLudx8Wrs6dhVNjV/EPMP4bYYlC5Lgu4nEAh+K6P35x5JAHuR2Km7vYxMzMiGQxiyGglfYog9SnfojIDxVrtDH7oBb8qaaqvTzgWta18kVRHQtK4ReaheC50D3CitKWgFgmNxRjwTmfZXDmoAkBi3x8sLTKKcLE8G77Iw2IfwaiHqSfA+TxxGKaznHm74MYnpwaL3UjdkoIqt8nQeYwhbGH1FB0k2jPf0lSLCEVpacgewvhiR2kS/OGkFpfPI9z91S4sACkHZcXURu1Du0btQvQLRSWumqOsFyQe/usq2VIN4GLcpBW56lnxjZoG3Mr6C1XraMgYT923YfE4osfipt5yYSHSosQuJq4QL8SHrwHxNIiHr7ztgBadEKjygg92T1wx+03FmBe/4jN409U0YhXsgnXMxZGHa25b1ZYPMIdlE0jK14gW9ahj6ukHJE3tZ9YDG7uvK6YlzBfKFjL+5MQN40nhPxQvzrVYRwPKrIOrlogGEJZAF4IvHybGWv43vw3pGpPdl4Sv6VjX5co5hW91hcTpMOwP6Vyh6fNsAXtAWS3+wnhpXyrzBnCBx8R3AOPTDABhJqCoFUiqIQFPJ7LzALGt7INxvHnczwoOityCJRYuxCiyDCGn3nQqz5xlay2IXJK34u/J5Ri7imdtYy1PVDDx37WW6euPVmnI/itH8MBeF819YK5Tpy0getjJRN+LJJcFGycWdvjKRCB+KKFI2Tq6HtAAYZLMbBygc2ByPFe3HVPrrD4V/aHcOBrSBjJyqVfeB7jlyWbT4iaV5ZptCZTR27wuv4np46oHISaNVP9HpUQoZZFiBtM+kw0bkSIuLxM9e68terf3Pgbr1sCmKX1BxkcMs7AuWHiKN7NOZWY/uULyvZE4ZqhLel8Bi/fOqT96QTj0YbN/0huMMBirdNuxqJ5KgoDoxWG+wao0WdIB4WaQthLW5pfOxi3b8+n7QjV3Kp73iKBp9MX+quhoMoGgPAn1jawKnu1xkacptqTrgI62Sdqd4l6yhXnxGIvBa1FFah5Ik=
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