XFjauzoRXnK7Nch5EWSCOCC4TqJyzag6Pt+j5pQZFxLlRTKn+WGIhc5Lgt68QHLhkIkh51931vWN5FSkaUfO1CG8NFU5A7MntYrBs+BRrwzcNAuR0klWJTNlKJCZQ9MYblnnCR/oYzgXLrFR+AD6os27lYbVqJEzKHbtUTsCiTpidZl3/lWD2oKrDMcTHt3D84r5yHK2q2TQ02yd6WTdYgPfc18EqmCIM7ffKFTC43Q/m3hKwPFxe1A+l2iHVUIVPxOkvpjP5ijPuU4uJEgxvqHcKZSjtWBazPMYYlKEPcdSA+ykz+ialubI9bj0NJ/p52HxnVZLN85UyoMgUpzTpTI27MdZNJr5l9BlU6mv+vMSS/H0IIKsTsURDjFIBngXw96IZh9ELk4IjPWbPkjLi6ahewlwvKnFx4OUgob5xI4LtucU1oBGraaOyWan7ZWc+eKpVnuuEJ6/xXYAzZPS6iOmlyMjJSYS/L+Bp7M6BygSW5U2Na4jLUBLa1g3Z7uYsLd/kgRXbwoDhb81eAyn2Qr7McaECECbH63xUQ82fz139eoSzBYaS0LDFGGEFsIF7yE8LB9ZAKKnq6uRDsA8UxP9ot9nVYkpORlqHqeT8YYzkrIug3EwZW90qPkhrxGqQJzHPSNMFCv3GhXPJjq7LOVe2q2RUHA9TCsIwjJemcWJ4Q95nMp09LTkjjMEaRWm5ae1hLKQkKp8r35UAW3P3xMtCf9moihHA6JFOv5FPs/+T+DqQDkGIcUEG5iU2/fTyoahTqNG3N1NtUIjvrWkkn31Yuze3Od1VS/NFibLNO+swbHM4eFE7ZFSiBcjSOL0NqWIlR+etP6ktdU/7FpenIkC11tw6P8SMq/XI5fZ0iU7sFUXUYL4shKKcyv5LJNtIqjLMnb6z2kaGCnpGcA7wUumkSwIbTjFg4WFgAUdWwjYLYqcfs1oH/1US8nqNC+Fa37W5ZoCqBvDEyWcIZMLuT1xE4GAU/VSH7UErhSPmM/U0iuC4YPwq2Nx+iCHOLS+joOTy27LAffhBdfAM4POBjQ82r+wltGYvZuU/DlroZwJx+wUPS+UX/lG9HNWqGws13Ibsnu57yvaha1g4Kse5NsgoRRleq9ogvtQjMSYD8K8pzDYHBTF+iB4oXgOfdzLETybwVLkkXxXuuO9HU5XhHjXFHLF/d79x1x4ERpPbURaJEqyCBEP/dIF2504spyIzdBA+Gp31GjUkxh+ExUhnj/ebtAB598cZjDSnPzYkvRIkyIOwR30m4UPlOPLWjSu2C+b5esfdYwo298xYQ9hW7+dd56mT2w+7TW3+ECiA9jA04eytZThpgT8kZA/G2RYfHx9Wc66xfFcPmVlq8tuj7UQVOgxSF6IigbD0lM=
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