xMkJ/WIZiXSS9TM1WkGMRZwAHw8PRZPb5NjCA+AjCo0UKr/pMXJ37v0gvp0LcDQVJvwxjuNoRCVVWcru14JTnk4VPn2jbRjvJeYJJQjb1NNXPBHz3atrqj0q1wuDxxVbNUaamybhVTO8ohKJ8feaDh/M+kKnLAjYImra/P02D4QAh8Zx53i46npfojTxrnM7SHPmXaKZNtY7UmzmxlZnFtlbu3TYRAZZQXZirXoZ5oPktG8dVYqPcR8SQdXK8cKL+j3BCbEXXyjdYMJdfavzzlv+cQDHSdNkul6a/iheJollqNqMRww0d8PVA0ss9sW/YyCzDFp6j+eriWmKomkq0+2wvu1BEW0zp0hHWW96YY03g8VeXi0PxxXnox0YQvlK7PC50PClVrooDPg2Ub86fpX2GTZE/RdFNAAKxmKXuUxo92/c792xQvG/KcWbCz9Smd6bCKjl1DrjdRDsASQBpi9OxHM4nkZ50qWfPCA96QbMwaZbDa6jRY5EhiuXu9bc0T6VtV9+4RMFdepeR23GONWxfWB82Zi1OXj9Fy+2K8BysX6nFkEOYk7bz8553HlUERAI7OuFvANPpqLcII/arTox4GtvVG93YiI1+s0Z4hThR00l/pwcI0atVgSaJTOIsEBsooonVTYtx6duMBVWP0yHtIRSIuQoCr+QL2tWkcpWMIA2RYy8UGJtGPsihAzswfg6CJ8JyRTmBE9PfyVzgj3pxj5Ar4mWyC8vjNl7b9aFAZFMkKfYoE0QUW6o1uS76c8Gota7itMYR5uTAY/Uji0y1j+FmZZg9hC5QM4TtZvyR3RHgiaB2uQ58UxxIMPyw6k719Kh4/8QRHcbvbF22QO2E/R+XVZJE6u+fWmNPljdFV7bsIjiDY/W4gLbYk3jRDU2SdLgJyCvh+1RZ0m+y3JqZ2jfTSFgszEt8ICNe1rIKHJ2jq/ZqNZ4DIwCRBoE5M5rvJHASyxKJXgSHBkb7JnXnx03TOEfz0r8GCvi5PzBOWOR/Ld9YvcyqGhzj4B3zl2BleuMGWMUZtasoBhZ9LFIuZdHUIg20b7egZoyzJr3bM6MX9442/Ul2daVy5tTagejdPZG7IKBQ+GbI0Zhr+3CnVRHEGq83pylBfWxubgrDNb1S7v1EcWAjM3iJLUloDZyw6udcW1LZTqnoh0Rwo4GxE2LyAv7TgXOxvswY4LtW3M8QyQw0QUkpTPgn6b14w/gcekUaQDgLfaO/34e/DLMw4K9tqYHObraKBro/594mECKOLh8ehu+9/5+rvhfvVrlpLh8y5BqEWLQq+DMArcxOiP2v9plDMGmo/TiOavcc3CJTNvr93BTD1HnP6hdLbqGg3bgDI8p7X+saUS7fpVc6Sy7+wqu6cvCE4U=
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