HGvO6/7TJ9Bp54h6YlptawSKrp7YHKTPKO3qY0RVZ0vxiLgBtmuScoVyd2bLapPFOrcDxAbI7KIZNI9sqwS/nwdnY7VQQfL3Mv+C1MHzPMBf7PHi4DCy55kM4Zd43meHAaB/R0KCWY1Vfrs0fZlzP/Cy/OyXXtfD0sRLwIF8PuzENlpHsMqYX6+3Z383X82/sW6NCfDJo8jdVgcZyevs5J29T9cRS+6fkbiOEndUCn/L8zZn8hRaRWULC1pqm76bgiIS3HA6gEEreJS7M3Mi3plKYzrLkGs7bBHSfpAzIRC4FmUCwMQEEYUxAv8KDb2UNQ0ru0spsumVMafxjcvVEBFqDlexmtuRtpXRgJsWJKxGwNBjyfv1BO8i54BvZKMFefT5zJoWsUJscGIm7IT9AsrHev7wN2DvcxFCBxP6DplAZsLgJ+wETivC6JzZUNZay7VJugepQE0G86rSVBQjHsVvYipog4XxVPDoj0ypLKyOQM5funyt+RsmsNipHckkEhTw1xbtMdONGdZEUQHpYoqdUJV5+r9pYaeUFG6GTSJ4IzvLQhN/ZWUiAoXJ/5Ljqi7JZTzBjqGikZ0tMKP/NimPVeqDdnWPgUU9/smI3+EhcFdAvOkb/fbL4WCgCYdVS40PVXSzS5LjI6iETZPOitwdKR7o2K2+OAQG0haP9AeM7j4VvN4PbBuyS9MKS7ttzVjDzegIpRfxP9r/3AhjomEFyN9U5tCQ10u69PJMtHMgKMA9Pb+LOS8tQD0ZtB18+nSFDM/HCg9gE3SSWwTyOD6mYd4btdb4yVFi9neLjnrwIoVWSmVbn2JOamXi5N6x69WA08RrWiWhqhf8slh3CpsUp4JstGIvsIsEbuRbJKqQ42D7lWrIindQIPcoTtCXRBmoITpFpcykVVpx/SsYgIPVpiExgueCtF3+4sAoh2sZY3zfzDlsuinpMOcb5YdcG98ZhgfwrSibHVTlQKSOgFBjmFsGpuNsbXKfetQob4DZ3aNG7w0NJGiivGjCJhZJs+fqFvtDXGzpVk69QqcNNZmljv8Bg+kTRdvydE6ksnhtmkyiqEHBc5NK74PAN4D8EThCO0h2Ndxl9GZqrZMvB5mHYMdQX8PlIzYHU+SI+rK8UAyqe6x1tnlCHyVlCwZBquv+BitH2lrCdJ4WlMc/MNlfiX9Vg9SRFLwm5vyY1wHBOr2mPTdWwetO39JhmWndGyqeJBPK1Xic5riC0WdqWG6xTvyF3jAJwVY5wH2urEakciBzDzbmDhQvVAePVf8QzMEuV48LN62GC1SgpaiBOaVDHew5C/aea0EEVuV8rQ5kkiCMA2CPLxlEl7Bpk7mQNHFS7INZtsR2XHh6wzv4Sn9yyX92aWFsY8f8IdE=
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