QRK3sUacmfHUExc0QRbC0Kg7JWJanbHD76ZOJQ8knKoG0lsJ8IboaQYyIK9/74Gu5wrE4uz7MEYDMQNvbinO7tfm+iHgNpNwLxXfCGm4aZo/I8fLjBl6XGOGMVGbD8MeegElGu7GLERQNhuYatQSYcvFZd/2qqAhqYt0m7yvhTlwT435otUS8luKq8Bod8jWcfL3fZROG21XgrS3Jrx9F8EE68hTWsLV4lD9gFCKnlDoxN1cxTAzX2tKEHLgwAB4mtLl095hc8mn1QeS0dbU9Q4nTZwrFFDv0hNRjYqto5xAvVaNLhbUeBXDgD4DvP26/LQsI+i3Id4+k6BmIXWv8rvKMgjG54NZJH4i/sCZcEp1ZlPuaQW8yIi0Dg3QQmHu5ttvZ0jyTt3ndIpGkgza/hnx5WjR7ABLlHBEMerpGmoykKtnKd7SCZQQsIcOX1LlSDW1BXVOiUwMuC6davUhU4XFJQPi0+k32iV+UPUR4RdHJ5lGMUdCMWt23P9RD4Zw3iB4vacHBrYS9NDxaWlOfw9Y9f1LUlk//ClWo/vxz6s5AVB/bLwHAyBeqUwPz+FQc9wt1Zn6YOYGbvRovgr0N6pPHEN6shl3DBefupmCNMmjVnHLEHZQMjZtz+DuAcjAGyZS5jj72lIAoCXvdKGTdqnK5LbfPSQZFb9yNDimr5IUue1kPfDr6/CofuflqBHq1kD7ptFBHQxkTqJsrkcQpoN53w/BGmUGrwVQg6X3ZaDBNqg2HP7m4ap8MG7AuwTQHy6Ej2qFlq+o7BssIu+ascGmCgsSwJcngrMI0cep9VjWPWssDgBO144QBMGlPqoqsPCY/0HHz65YyhPRnJhdSjG2mf0N+Vhx4S5APfEwW4GsqXwfDXHtFxx9X4W8dhZ3BA40GWoR5YqM1SUBN8fPK41XN39irBkWHSmBFiKTrMR9JQY1GqzoEvle0+oe50ZgsWeeIgxsnBuzhN5MBxzEjiC+4UlxlOU1pMhVvTC5aBjWSOf9ac7Ps7TmWTiSlFVmD/deaJksFXtZplZ9r4cTKr5tQUOr6ohbIcGsepHYFUzLwhrzqS8xEFoTy7BuXUS+QaXTH2EpLvfXeZapiqShFGkCOYMt1XnQ/0xdaAdMbF9Kc5SUUZfyXuYGlLIUG13pYlx82fLjngLVKwVo/uKSMnJOXwvlzsrRvTDg7pfsBUem/RMF/eFoi67avvKA9YM0y8DyvGAtUo8daYe4zIr1AeQo1WtuOIzjw42jZOQAh4J5XXkipXoTxgmy9o1qTXDX55aEvWiYIjgve1iwI16aMaH6ZTWLj2HtVP72GYtpbPE8nTRc4sNnEIp5ZZmd6vRCArX7tPBVJb0QX0Q9Ip9OZjw/s9ZZU260m5nD8bY=
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