1vrjfGBF5jZ84bwxBgVqUu60W2FCZvDG81bw5YkI3+IFcFrIFXXTovVMjkmlRTNqXTcmMGwjYjq9yGqDvWA+a8BrXxtTsXeOsMF7BLAUG9FwAL50bUT5TuaohQMmjXTp0dRdvNPNrSa9KOpT6nO6QsbkJ5iUjxpS3gVEPPhSJJ+6PwRXzQ5kh0mWEt0YFuqsGZiW/SgDxQOpKIUfplzeSe4+w4eb/fXdno3hRH7KzAZjEqwNDfKLTmPRGQjijEv1GrGu9AxztUrIHzdOoNkzMDRtWq+HSNnXaDS/fbgquR1ulD5AymQYXnMafNqhhPK9a5Ru5769p5oLEcr7HE9FyQO4Bkfvzn/9x7Lue6gz0QJYKeRVkMBUVRTIvFMZdKxFV5sk9sWRGIZj09jb/Z964iG3Sj5a/pWMCI5IVxznOSHr6TTpO1gedu7g8KgvsDdVk6VO4G60RmiIL5GY5SM7wo7uG41c8dCxb+OthKdFdf3s5Y9th8M27qFh8OiLM9bUSWTftS4371frjLHls7AcGI/85kr+sA/eiwJ0YWNykHQoejJlHFOhoD1EPv0CrnuR5XEZeZWoN/p6+MEX4/8Y7hmqMYzCQTJQVvcmSBvkIh6iN10rZLQJEetj9AusmvDmTQpHCzDLolCGjsf4kwaGL5SW8C6OQ3uF6ouTXi3fATdDKPdXn5uJ9oJS8HIGv3tD9hXy26vkIodmLi6IK/sHvh5z348Ficg4NQZMOGLIdbR4RMx1k8Tt0PL7xFkDdzjO7UNnKJZxiKWtDp1BgKKPyBVQAJD9/Q4uxq694GAGjs3vX43WDgHxErdpOg6sotec5oAW+f3hO4H0VWSWM73N0svgRInGqe4AVfHn549UlQQvIAvAm9lPf4EgaZC6lCmHNRQQ/XFGN2wkS2PnbnUO2mRGC9ZYyn5PpdsRd1R04h7GA/USI7Mrx6/jCABvo0sg0IO3wdpBRit8IyX/9gf/r6cUq2NvLZ339uTHypQMmGINs5cbui/72jUO5lReg9RlEjiJ+bmHKB6qnQKGmlsmMjyaDNgpKcYLZUESzXF81TjWMD4V91E3sgoaENsdpI/rjDmD3UWoPG86vtrP2gIbJfkvujwcY5OuxykdqDyEMy7eMi2poUrzbwFoBeckcvJRbtWOUH7e7eWym7bmqXO92Q3PJ7WaXI/VPL2IjXCzUZJ84YCitdqjYVa6O5xzXvLTaGAapmVSYB7iciGkEr1K8ijc1jRymUkN7HfYW7AqZXl9EJiwYHKUdDZMzxu05gbXhoDBXKzcepOcznusuKGqr81wAQQT4+3FMQ4FsLiWESPpo9/CzaJAtpCy6BmrWbQiMPRB81eAf17dSM0ZlabZE9AYlM2RWisPw1nPrA0=
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