Sx6aWPN3Xr9fmHF+MyasoDKZkgyZbndiscbXobZn2E64NXjgi4gBypBRAyqcwY/M8cf9ySlv0rwHplhz+8F671AJhV7s6gaqDyT7po0nCyHP/4EdnJn0FytNylWzACYe5ZlXJ8kO2t+brA3idHkE71qHDY79VTest7krSD0l31qxJIUsvcNnd8u+u06iNr1d3efgtSR+nn4LklYZrSRVNrZ9+OPSjgHtNIrde9gKJDzlg4kNAJD7TOSQJoweztLSsAV/QPDUTj2FW12anRYkUgZTFbq8S0XDP44SdhS7wP4OUzZqHCAmIcUNN6jK/q1C2ZmJWpeMC0/7TRqzT/judzglPLjmVkvLU/fIXAzjEzOcsxvFCmRkRb/ms0V0TrmEW1XVZd6uO2MrXZEjo96Wj58rqd7CNfP7TtUJhRPIqQO2PaaTZja3/vpz3jeCtwoorr3d0zTiW6/qP9eBaOTQ3PhwgJk0B0Uw2+Ey4vMUdgDJWXrcfDaUD4VdVFURCHVcAV5t/6+o0cDhkJwMh0vg4PUPb/1O/71FC74mhKHuRLsLkbnl7EpX0GkdSoRL2WS/58PNazO+gfkqwzZ7gqfG6VIn1v51/q/c98andIojo2mb4qCCZkYNUUi6Bk6MOBLf1AoWu1+cJ4mNww7xZ8cNn6lDQMftYwtaY9WyOcuuIQIUhTz27INvCm3GO4aAPlhPSc1LdhaTqSg2DMtCNl0c1fcSmh2bdCDE6hJ/VUOFtTsoB4n4P0rAcMOj1UFFElDy01tQTVIOWMfF6jdAC8Wx+7eUlGqKfzRgq50AzB1e/E1bl6kQLeCb35DrKmtOLcpFf7ov+isVm1GqmMLwi/5j6S5MD1c93H6527OJ5amHxFDCRvFw2dLN6Ic4bnYjUF0y4e5CHGYsOYQ86QhKMXSYi5P2F8tR4x/ckbrLLqs9MIQ4+SCZWBYKz0qeO3wn7Exi0jS+TrEViJBHDXeBzpb3JVtb1afIfjU/A+5jzUybXA9oK5UduZNNhwu5v5WrDBtMQF8lZYjLxdRz+s6NYkP+Ek56NYHtDb0HUc8qk9BvwqzW5GdOsV88aWBCYGaecg1DSrI/nyG6kjp+gjQiYiqkz0JDwo1//j5UX9arIZ3lHGIkRBDb1AdBpAjQZz5HTndpxXNwKXeHiN9R5lbiqu0nKgsuSWlk0vzrAvdwAcQMcKp6oQaOa13cpu3vfxkEhudo8sAm5pPsdUYz86Jzb9QGAPBV5BcEZmDHtk+SMseGHl30aGny6t7ePExwVkVC3AQbsYZqSBIKN72CIBmfT64mvxMui8NPSra9QMOKYvg6frfoqtSIngbJfZnlGw+dKpPUyVdAbjhPsdRUT50VJLXGk/5qiYfpV3WP8As5GH0=
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