+8udzmKv2MNh6GdKLJJ2rZ5z3otnTLHDssSi32vyTHkRKVsu63ffXSvkgQjxxEzuYAQlPh5pdcCpNFxc9kfr3zZJB542Q1da16oBnwum46f5E7wV9gFhwDGLbtfk8moBBL908bsJCCPAXvU0kedPjAOevUoMkYi5IFr4ZBVMFVlmTxQm3wryTQqHkg+jellyysdSR7XN5BikIiejNmchxLsLgYDNPPvDBpiyHyL/H6h9oNL9m2+ydbGKM1CaJAxD9wYBaiQ7KjlP5SY0qq/ZApWW1rSEMxrLZFqa2wlVN81YORzEZq3CuilYnRpdc7+Y1yBBiu1WyDAVp//NAvAT/Ifp4boVw69nCAQ08Y6Rfv7GOSAptQyOhp4COjllc/c4b3rBiGRMV0Gt6rrrTbHFvqjC2pvzJJ1aXCo/cq+dXOot9EC8Z8oOb9bqKDXfGPQRkqsnI5rkkqYZ0Lku5tbh1ZQaYadgXZHsL4Uyj2F9eIu7EMcwygqIJr1dSOP0I/lKub2m9JUs21RxnTboyiT/RJVy7rtLF1jYtuD8yjXw9vEU10QH9OUWlSyoF4siwiZR7bQLse3OVonl43Ul1zSmSNSt6LsUTfDOAhPvq/6PmGVXanL4jg+/oHuKNSEsxVQq1CY7Kpzg7OgNNYB+fnNHqNvEpLt+hsbouXnPtorFcsNVbF5+DZ6uLn3BBoJ97AjLqJCjdmNztl2tDTcM+0mYzwvqLkQTN72ioi2V+/+ztA8DseDZ4O/4Jv8PvLyq4pS7xEUZNJ6xGrSMLrZWOpzmdxsOBUyvjr2gDC0/Tg+/nKYz8j6IltY7aNCvdqfxvXChvwQ+rEuGPNzl1wSyZaY32FCBHgIAOb3iJd+cyey2wYRllZIgN4AB8ID3AeeSDmW5MVSfvmi3REUWeWXsvVfDG3tD5as3BDkngDYo0mqXrPeVfK2KEX8xGnGnkXGw7ASghuWkiCRiEyrsvWG90ykPC2XqzQeumDC6/xkftsOzt0t3VaW95Uf8sc503RF8meElA40nTDJtuyWQbnEPFSrj0m44jOyellvOAi4dzymJpcAyxet6bcQhQIS4ukjTlQi7+mcxYl+sVJTJk0ESawy203Dhzua/7KuZsIyUViL+LHhWj/noc44V1f3kUhC4r38S7C2zdNiSLzqT5e4B/E6s92qt21PdK2C55zPkYV7FPxQP8cgoLOihRXLUa/wF4LnqPK4qpVirxlNcUp5It7PgoLOkLS96tzT5r5fLYMG1ry7ZoMxy9KIQbMOROLAtxgDmFPwOIQzh3oqCe9xsrIIOcldesjhu5t9dmyWMZutPEPMXAACvUaSRU1I3QDx1MPAwHCPCv8Hx1bG0sTswL/pOMFJ0nUdGzYLfP0h+Rq0=
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