JAAN1CX1/ahKtLGg0NdXSL1Lv69vLN5Qc4PWWyvNydw9JCGUUBsWJ/9YtnyezWVyDwKOBtxU/nHVJEpBNeleKqqBeIeRxS/iQaP7CgmBqHgOO3Hc9neF3K9XLyqfkS2Ht3Jr7IB5+bmH4oQoL8t46XyMdDyMPZBuw5L8P55aKRR3s2UJfVmriSwZdg7+Tui9C5ftR+9rq42VPH8E5SBxzTW/uenakiGgRHC7kGHEgW66usvrEf25NAEm80U/h2Jf3frmUzBkoCTSou7m8ZkbvbD6Sc50CNDvT+droMYRSuGlsaDuPBjxQSZyn4Wmkw9ATSAYClsVu9vwJY68UevB9FeOFv4I/XAJvakaMh3KMSgrQm/HWEVgut6LGaCoIyMYu3L6/fyVFlTs5pUk58Kw7sbDiNL+pwBHUvvGh5XFp2rJsloh44chETwMNOFVV8YlS8LEqb/HodIPuFxW6Rj1UZNzZ5hIa0gKPBYCJ7XD9FTtBMyPw1jU0CBbhb1wZX9dRMr5U/O9FUZJ7GQT6DWAqU4EAFhuY7AP+o5AewPHP4SCR697EThj/yImz2wb4lQUOgos7uJLgSqi/A/EcL2sBJfMEv99YcWD0CoZplwTp9cVJQglwRFZdJeBJRqk7Rij+qxzdFXqzoavOiRDdtcCsXsMox+9YsGoMp/N++6GzK2OOSUTiIKFAgZ6B39e4klJqwHxrockab5gdfw6YwCy9hV2POTJxgQrGjTXRHhRdl2IO97mkeR4Csx7PLPmXtZztPgOZK74dzJ82L02iIsSVZsdxIo2GKuAZNS/TU4CO/kUFenHFNsdYhCRyLu8X2hlAJFIG+nZ10/zKbxlIxhfahZmGFqlxdmQfW6iZPc94A/XD/G6U1QZuqcbQc7HsOmN+JA/kj7bwD41L3uwLjh0uxhLM37ep/CWtLJ0x3m899ij0r8ouUE7brshIJ0/Xx4kjntvD054AANVzSQClGCqU6+eaK1rFPZfH9zbXqLq1hNUubIYhgV3Fkrb9efdVIOI1AXt6GSwpUXTiOwCaGL1J1v28Yw2hnunt/DlEGpWwjWdHXEp0wSBGIMC8D9R2m/n0fB4O7SpafmlmkQVfnOcmcctBTdOYTusJrLnfQj1gj6/2NttQOxHQJBGe97xF2FUVN3QYnFEgeBJG6M4UjDo/jg17Em7InaalZhN+3SrNhMxEFtmNYKOPBUxiTzPoBbVPZZxvKyqnVK6SU6zCSsaqf+mT8vp6X1XG9CHZEjTfDvpzQGD65wVwS67gix13GiPeznyrCprLQRp8w2WxbWDovFjimbrtmi8M/hroFPNpT/Z5rf0W+SY4kUcLs+/t0yu0nc7Fh0Lm+GyqxHt+SSOyOUAjhpRjKULFAtK+/I=
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