Nqgmhvl1nKHqjdUROoNhSvcZjFC+6y4uSleqypJK08eDPvMWErPfgi9mL72zG6fx23K8uoK3Mm6wD1G+jch6j2+7d2UH6mm0P9tUYsZgyrke4iA+2RBnL2+orZhjZE9uBlMcNAJx4AE71ro7Jgm3wMRhLU0X/2nZO7vGDmv+LK+5on9OiJaQmu1iHBP0ZPzwaBKkbT9DPq1Gu6wA8D6ErL4tYavepSuJGqUXYob4TFcqTUKtRxdKXVuIcajBlPkp4bXZ+giAbpYb/CQ+ST8863ztN/6YroIPCnR+s+vAsEp9MRYFHQ7BikaBe8AMfZUvbMdkeJy90jwOUEC5RCU0QXajujRLlB07EgnJE/j6Fwe2rQQu2lo/uVaHv6KgB9AGpYbhSFl0cbbRwBB2NB/6N6SLT07W9rluOmDtf5cnz0VtlQz+d6a6KGyVKi0jXvrvg3wMHj29fbijUMQbUX1RtNsm9AcX5hQbEF2fV5J9FEMS2a0vPkiVWAc3lFpEMO5pxdG8GI1bhr0NunU1p9Ggv66kwx5w64Ev8dQF6849dcmqUbptdQz1MuwN559+RGP2f9U2YyMlVFPmOPHstBL7ADf79J04QhBro1C9IGAAFKppgzz/PzDbXdsi/WF79dDuNID+oJEPsXLJHLImVTt2LpkByjCnBa4Sgq0Lexccjsjr31wCgWfgDSnDRDTjJ6g6W+j3EoP5AQH1bHEUvFl8MAw62J7083fOgX2LysUinRIC+G7t4/UB4Hxi+/0QFOa1T+XoZ9NN57Pu+YC+7wPmB+2YYNlYNDvKsM6sP625QXa0zqwTOsah7T/9e+9pVTPhleJC2QoJTfNOt+miNO5Nsow0kyZL9+9aUKbAykL64hO/0g0Lpt+ec9Nyd/Bo6q8AsCxyMmwZ3SRg6cHE12HFZiqFgICY9Lw/4hj2HyPoUPYg9wRYUAzuSm/LYGYkpIaz6gw8iUuW5tgHPgwJtoOrmmovULOa8eILehS8fdj1pU4Em1aI4BQAIfUIrySVtvRl3jGouPC0OqOyIqIcVykoVj69C2GCyn2nbGsdMjjrFsTfk1JjwKJV5F5bMVGAgLP+0lOGknZ4Q0qfErl4IqhBsAucnSeQiK3F26O/s/NYRrky5QEX1jdVpvipkE2Zq1igHVOozeTCe7l4yRBqjvFK0+7KUsEpcq/OffPZlBO5OUmlG9AVnAXBboIGrVIMeMjCKLOZL8WbgVa8w83ETZvNnDFjyZRaxSeOgALvtqWkV47CHRv6FdJl5rGhIXX/tLKgglW0FYp4Fn3oYvWFdKVZbnmDO2O26ATYyPeKMDXzYA0liXEhUIbbqchxlXsPo+/2utsRoZp3n1rX0R0qqalqR88WXJaBqKVQ7tfxea0=
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