lhMuHCr3rETr2Wrtz/Mg4ztEOEbCpwRjbVqX2rXiU4zn84TqHtVB4z1PYOjkP7Dus4Sm4vG9/gf1jTku2ehkdAOWgFKp+mHgP6PjlOn4CiaqAqKtlqftMHnOZNruX2BAZ9vksuGWP7nIjfP81jWfI11Xp5RDuOC+dhL0qWHYeF0f7jD2sPUbJn0S7SYGVwMPRtoY29xk3T42LJjW93s68NMELYYMq8uZhi5QC5gxnz01zi9EDTAorsIDtFTxEN3bT8vTAu/rN7uKyL52EvwHuSPWAGmgV6lWXCNzI+e2GLHf1QdgfSq1Ui4k2L+b6Ry8vLz/gnVxVGelg7ApA41wP7LbImf4VdnMG37z3QzGS1JWJqCCpB2lTBfTSRjrcMdW0Gu9Tj1lyqI6hFQdoUPN5PVc77/YZTksdRH/rFgtoSKnyCgQQ9BMILHbGngf2dua1BUUI5fBsU4BQbBXSolNsuXYtfBdv0vgU9zcBf5P3ZmvHckJ7kT0AjuSNi+h9Taf4hM7ujBj7i8YryNlFMQvvCF1VtAdFg6kTEvXzKdHSgrX22N7mdbpYJvP7m2Sx2RFhcyKZ8RFkC4KQQg0BR53XNMlRey2+Xi401qdSv6V84J1Mcq6ngnUYEGwA2V8O0TjytFNghg7XIhyqMhrWwBpUzDBQfrmocazCBsqIQWA9YDSqltThHzUbnyzdtU384fRKaNzKRB56VVXIdBE++lMEo9GnnLP1PtMy9gSmknCaNtwGnO3rcJBygbmUVmG3hs6O8NO3V+QRnQ9RxoHahjN8g51z9khvosSuW4d4t1Ts8KO0LTSnKA/mUQ3kz2fbJhqRVTxxu2eXBLZLCn2fNaJW8h1NidtaCGqDnMd59FSqjU2UOMkouhK7aHND6QRpW52YYa8kc8iHFHJBSmcrJgU801cYNswcOBz6nrUyccnJ1k/Hz0+ssdiAJ1QXWHxvnWHHyh793u3LuEqpvsE84kqR+Sh8T9ACXip7b0Njk2RqK/i0UquovuCs0e5FBA7Hnp4Bn2QmZCiWmt021iE6ThdNgvgZbu7sFWzK61DY5bfjZPBiirEn1sQ9Q/61BvR6GL62N8CNtu33XWE2uq8SY1gFU4KnlSu87MC+gQso4t01vKCt5DeVqwLHFC0jMw1+yxlix6l4Hl5dG+bPHqkg2VFRW93gMixO1UT1a+VrI0iUw1bNhtptwGxo/X1trhlqafbWuZqBqsVTW6iXuB11Kk35jvD6mgmPplDYaRSecZkXv+RnEgpldlzrMDjFII5VjYJy1QO2MX27aNfAZy8DYduX1XwDwLoxmrU3Iox+hoVwmLafZ8F3L6YKhiz6W6iVlXB2QEvAX6g1HA31bouLHznaunLQ/Tp7rCy/lhtsik=
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