jHfBaeSZnSr4sXakjmrz3zFX1Wn2dSLWpL3eJFFOVBERWnZ34DzRU0CLNNfHMhltAA8tJ5M7+1/ms+PrpsqhYzffLXvCgKHf1UgXZOcCE+azSbpTrhI2sU4JNtOdfj9FaVJ83EwV+tyC7LRNGKFAJBG67Bk3bVhRFZD/+14A5sV10MquBOHaUliZO6Odux35lKtGu6p58vKhaY9GaFP9oejkt8W67mMSmBM+sCZAJIxWWHxaOBBATf0eovt1ijg8EmDAOZuPngcejGAtTNlVTmD2aco7sxOjdUo1nnl4JA0qhSpzp5aYza+2DJ6FwLpiF/kIhGwY93SJXchHdL7uPdQ81veeWm+Ls4UA0iz4pwvHA7NPVjCWm6BOtq+13GRf4zK6xXBJqvzZKhLDTggBO6D69NrGHqy0QJVSi0wDMjtjOIIRcKoTj6byoN4dWIUedN439sQo4DNC5+Law18EGooXqfT4v0S/p8GeNK9Yp2rYEMb4q32NZAZmpPLUqM44cq9ah6vnvUs/Vc+4TAJm5lXW89IXcfFtC7PMtrdznk8jaSaM6uVf+azntjmDhQvL1+0crJbJT7tPk6XgVqnvln5kq2x1AVVcE+eTYJqFUarUJQi1CBy6Qcc04UvyJYjhPRQHrfMfIT819qdj8/aavFgxxB92E7DpImEXozE8XVfUjfWfsXXoOTVtqFMNaAMqkeQJPITBy+FDAGEYT1/y5lo2n6WekjPrSC2p0Fpg34QMoafFLWHXIXvsxBirY83v1iI/IlD7wlJX51PplFEXIFNWNKLXq5EO+mQa2jc2XyGebv7sEMNwM5y1Bs0ErmPg40tb8ZoVT0XsICMuoRtCWAziULSwhnDS6wuvttKoRmGpFGfN3Jb1jh4iEetqb0gVx+K5oBHc79v0cWBls9Q4226waIc9Gf1gapyVcAgcSoZw6witd6N8Htweq6mjZ7mgJ4JG+m0nE02fbofX26WEoKNdmh7GmimEXAKVX6Oe58j14MJ/3UTMr7HaNUg+5MiRB6OAnMg+34+eThv2SKpP0UNj6vzm6tBoa/aj7Di7NgIxKj0luOhMJwy2ED728PKcSd2Q5Rah2Pn+4FhLZFmHratTBc7ME7tjf0TxKBJIrIK5tihp8SiCefC8Dm+t8m19sTS9deQGXXeifbZAZsRSErrFc90o2bajennZTr/lIc02iXF3b3lLGuHtyT3brr56dNfENywcjn/0JiZm2zpzYZNeNNyWTG1lq0Qz1nAxsUg7EFZ3nau2rui/Oo472nQapd1smS378+UCAirzGOgj51YRpvuwH3HLY09CwIedcdBgfqh343zhfmgbJ/XgSsnK3uZ4696Fz5HEIIyCnp/4sQMhUcr5DrvQnNYNp8Q=
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