e3kRvzRss0jObLNObGYDvqgaqO23XX35NacD6TN2b3sKpFWaKmYQxtikiE8rPTEt4EhbMLNlMK8yk96GNeT+di7Ezu8lqQ77Mlgkn06Z33uhACCYfWlYHSwCXhvDsiCNqaEGF1puriaJZHHeteFn07/97BcQK39lvsK23O1Wv8eJagXAGvviwzFQ2OMUdxCXMVZxfPcdoCVVLxMfpoA7l1kvrdOxXYuVQHKekSkSyb0/kM00pQxu2tr3ti3cc8CtEr9sDCNUyC0nP9c3e4M0mXAcIXvE8AUYquVmimV4YxcA6mK8YwKJiWamlNagoe5+TaXmE6WBw7cwDdIF9tya3CltNHc080uioIJUdzvuCewZ3ezIhdr0VFx1QJf6fCgCEdCSx4BLdOI+AD/suvF58o90XSvl1XUCF/09MYOnE6pffu+xhKoc4nyFgpVVEh0qEvtiK+5jRCCYRXBUZ3xhVM3/B2DoG5yW6aFoY/TDeXMySsqbdqW+NrihBVzyN/Gbx18A61Pua4IiE0P1hOA01wqGJxNuHeps19Hvw25MbU/y9tlgSiZG7hfOV+EYyBmKsXnfnnYSqeKOUkkGVjIuUGvaZaO5waUtI+7awHdw9xr3zFN7PIwekAi+MY1//bUnTN5l6WfDN51QeIh13sLfCqgb/921x81sKJ1khBrJ3T7qa0XeE2dtXQi+nFn9w8iq9PwJ/KnFmCo4WlQgIS/txpehMHzL/7BUvwBe15DLjsfGLev7gATmyu0w4JzIPMwjQMYIs3Wgp8EG1hWGo6Tlo2Tw1N0IovEqImaVmGrFENvXKOxb109BHPcf5WPLMdJZeMAdIUvyBPYNIPupGfqotiJDnxDz8W6paqaiznA92tfKuM5hESLlyRCqw5pXopJtF+HGvGCJdR65hQAjPx2Gt3ZZoIB3z2TmCrO8BBVtelS8WGfH6DHDqhxKdrZChfs9TTJSDLh8zBk0QOfIE2Jdh1hbh48hqWaFYNR0nGJUckgF2MHbbP03e91gBaVOSbL9JRjEdP3aFJveGdDzx00uYIfI76a09HL5ue6KhrMxMCvEJu89+DAluBWavwbeblaJrStA2bbkqIpaUfGpAH578a+v2ohK3xqJTwkhmdlLp2KfQDjbf/5oT01e4lXm3BqclPoeh0/Bt/g30bMhpGj8QAwwTr/r3Y8+Cs+Ohj7e3/zG0rV2ptwTdo6WpNLqtKV7qq+z5vYKuTyrrEP3OLp/U190ztvcr/+D9/ykd+o1+zVVrY7+vCqLHpjTPJC+aj1rh6VL6Q3Bw1EXIDNza2lLAFOiMWpNWQ2vIOWeC8KRP8kboCvvBsIyC0jYFb7o5aDgP7QLHAI3h2y/Ie3vCV1H5dqTvh1BzE+S3CS+xN0=
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