3E9mBqbrf+HyRUzNdvbyTWKCbGRRQ//SjUavylTLfg4PcG7p/GLFYAfzFsIVapZF8eYAv5bu4LvzG1cC5ZWZ65Hz/bSQ/jeXqUOaRBP7QZKrcClw/xPwCpzpuD2bhB24NLus3MYLOmyGQp7AzXDrltaeu8Cg0b9Lzd4/QobbAxyIyrMDeqZqiwqlyVwCpxqgPm+yWTWRRRu9BMROl0bw5zUZkjjKBemzpIedNwRQS3GIoPPy9tY/1D9MA+dV84SD/Ggif/EyFnYh8U/5lwX653dGqJTeOhau7PYMKnKMhD1JbBU5Lyulysao4f+yC1aFiWAB13HGxTpj2j+KvhDCIl3L7amyZzMtMe5r4hHPkQkoulc+hSZ/sNSUNB1H+5QlhIDUzEzbLszzUM4PpKQdRfiVl1o6DBCoOIJANzbBxpX7jTr62Yeejgr+heLcQE3/0vlqzCydc3hO2Wx60KMp41ymAmpE+QYMZeWp8j+TlYirhSlL3OGoSP0GieYl5HA4GjGBhKEc514A65FNo+huRBSvfqTxMlUGF93JLobPLp1HLk2iViyk3fipMCkviha30fa+8yzgCdedKu9ZAtCd1+NI9whXJjhzJXLIFKkHbkDcF1kLbWuPAsPBogiY1GrDsrkr1thHm0796FFM0t/Hi55Vx11fAsrC0weR5fO7OxFpC4ahdAQuaS+44M4fIpXefJCzej3syAnrKr0wlLqDbpbFmhY6WnPO/AxbxWGSHan0lS4ZlvWUydYuHKBb4HcGOlOfP6GtzcGDGJPFpNhtjB26Sr5pr2dy+YmtkdOtaZxukOaDNfvWFd9RhgeeeLh0ekA88hluBLT0zJeV2Zr5gegkzNx9ZN/u9hmgVLEB1hnS3LCsuUgcxp5EDaCNxPbvvkHvFbCbgN0VsYqLX6I/oOcgunYSWZzfwMEzq135xHf0apxKCsXKUAggpaCagRor/rHEmn/cVUpWs1QogLtYvcWUD6RhYvXwhfhcQAZyqIp+u42mY1eefL71H8I7+kIifXi2d6aqnun4P5I8whs+x4rdIJ0ZqyDMu+7Vw5/RMoOmD0njAKFHf1ImrPJFk2l8gGliYKNSssXMr+Y2yA9aBeWx3IOJnCEPsyscqIepdA54WBXfTO6kNJ+2oNxBkIxaCNiJUSwq3JsK3Z0LWuT/6kqrp6VyF1gipvOQd8TIRXyqKeTEjKWxWFfnNSirSmsN77MZ7/2iaTTMzaSic7RhShPq9UmNz4E6dvac7rAFnvfuXGdUKFQ96nlb4bz6tJVIuSbvxUcWisw9hClID4PufQbnKE723WwdYMS6H95k+WELlar7I0s/t/K1C4m5bEsKRkLGubeAQaHAzGkIyZC49li7rqpUZn5kXF2WVj0=
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