1PF92TO9tNbcQzUFRHHQJgFNyWGnsW+w0OS0ieFuxr0jXs/gTHi9B6aD+ZD/hppi5+vsFL+F2veerQvFkL0yn52li8ObHFLWuANxHggSe2jvsId/NvM/MnJl89h7/jSD8oBcLY16oIiqHHYT2cgancHaVmhqZoWSO2djbW540ucLH3oMPjOdaN3gf9hgQ+KT1d6PVpCNKArSum2v2+h8xGkhx5w/KMAesf7RSKzIYnr85id0JRC0666RZx+bvgn2JJqXHzZwGP+STau+8AOiYWk+Jq7USWGD6ecOfRxeBBYF3MiadvCLU2FDdPXzBDzFseNjl4kr6cm3ayjOon3mbHBPEwR6OB7+bGK2pjsuE1UzkIrnWVnU6LawGvYs3OgHTmW7vj1zRHNqbwkYMC6RnjTQqbpB7gOcYvbCqIJpacXNrt3IFvqKM2zrTaR1SOBkWNM9dMn952nr0/wz/f9pCtrXqvOWLymm8LLdRCIbY8Sjd/svtYzwZ3o1gLrCQjNAiVKMSihqbVw2lzIVoV1ow+imlHrWM2QszaTl43Iy8OBSlPWICFirykN0XWKgbAANPJzkVfinIOnFP/1j+ZnYDbYhCpQFRZgWgMnOjhHW2JInQqgy3195AsrFHog/L1hanAKKPCe03FZ4rSzbWQ8F/Ue/7V60+G/lSYxalDZeKnmz4iv9GAW0tDDUqdrbv/LWdoEEJxRYbFVfHZE32XQxRw5V6xBYb1vRonvhQwJVD1ZohbxwGhCaU0hGoBPELxMluCVEFxMatFl9Nsp4dttz/wBsTqpzhxuhgvc4dCctbdDVK5mUtcKXGUzAGgIkUYt7HdMF4JFjdcYLSFlMVyIkjC7zuwQ9HhlrEZElUZbl1qo6yERSrAKgnHqxe3lkKPoHi7y8vmFvWBYNlkrHuxCgZVG3YENfZ8jw7UVBlNkkrF6JwDScuR4oAkNN1lU0bSN9Lc/GE78rk3x2XmGzo6FYxF/rKpUDrqCLu28wi3QulHUGRx5agi7zJv17w9kmzFvNLnUrpUkKLv9NTvwtwmzJaX6fKpuRKCz4Uv8qJGB7ZBJVZOURobTgRiJUBq7h9P1PmxbaQjuz2O6y2Pj87c1iknZw4gvc7vXCZJPP+k7Ev5ysS5UU0igtxHgmrxNRZRrdhYril3EUOaznobEnNrRqT/V4Gn85VZ8nksB5n8YkyZkoF1Aqwn9Kl3QUjZG2Xb0kivBsZr8eWH7HhxvYw2axmcJ36AdAXvNIlFfeIiBZ3tHb/Xmk+eE6w8WzdE301cP00CSrgviEDML9uwu+2gTwu8UWlnaXHakTkIux+gK2xRlSq/nQVYc8vZKvQoiRCaUYpmb2Yws0THlEOQ3XDg7pkcAmaCVc9yKU4gXPri8=
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