m2ctXXsBryoxFrChEPVvBNITanuqWyCMhoH9EIxsjggoj/0twF9ga5qTQclMenVq57hTD3C8Z7ez9WMziLVrWpKIFGG4wls7MT+Hkhv+Y2ze+JjZUz60oq11rL8gLXFDFkDaKaFCBP7qGoooYdugQyRUYItFLZaEGZ2nVGD9u41nj/67JfqQND+m5Xt3zmTg7Yyo26O+LSx4O6FNW26JyT/JTW+6z0bqMtIesX35zgHWSypRJ9rebs1ADLNZb7KIAqo4qr68Fe7WbCoOpmq8CJtkGxgofT3Ky1Wsgg72H/a/s25HciSMtJ8+q++rhK3CpRbweGOh0/F4n+A7aA0XTE0Xmq9RDviB6Fx7E/4KN8hMLmorTdAHR7bcJ4d/2bbvJdKWU60WW8v2782mppvMrGqc8amy8btE25c4AehqfzZpvzGgEYaKKHmgM+E+GozH5WwujYfqm93GNNuPYYFWseKdONg7PU3XKEDWdOLw2LzjgXpkdb6cRkCf0BzLZZPkbz8mHkQxXGFrjY73kkHcqwl4KJaHre/U+0KZmFAXy7AkM2qGBnW4z4Ukgu2kC5znJtc8xD6gHMsG+5CTS+BB5YaTPDsmSoN1WoIpZAiq5uTWmJ1/RSTMNOxKS+IXOclJun4M/79rVITfp4nRbhihiOVB9e1j3v2J7uR7DZ76uL5/Uk1NwedQvq1AhAZ84OtI1wDaaxlZTGFaJc+u8etCSWOdosiygiFSbj28tqdmnJ2kDvQFgaYjW0At4MJl7wGyRGBn0tb6E4EoEN+rWZTfjfvvgnehEKBv086zX6HSzvslgK1eLnq2L+bZMGbU40a3HaHFez+cKyOHahDFIXg2oX7cJNvbIG1dTdNLXhUmxflL8Mr04vZS7TYE6gtNWfk2nuOo0WT3ziUpdlBLmTXhIhpIw4puI5pnqX1QdEGElJw57hFtQ0nQjOj77yQZUCS+vVRkrNDdfe/MmrcH8Cl7XEXdFqHTVqdwcK4q7cGHcYdm8mQlQfW0EUS52pAi0y67d+MLG23n0hhdJ6nL7f5uM0bRhXtc1FpXTUTIa26HT0UmcIw79oYTbwunm24HNUWRQi8pnn7moIYgg40NR5RRAJE9iH6GScU/ymlkQimSSr3TIFybqAUU+OmKOBANtLw+kj0xv8AFJQlxzbbyeiEmD7Cw7ZklN2t4Zi1Z+tnnhSJv+6Kw+c4BJO0QChGPS8/2KBz7C+eHEIh6I92rAMcg6yeaEKIkRjMxW1TNP7N+0/PWeTWCHsOIDl7KjY7cMXBEZ8XtjLjU3vE1I0zq7nC2tAcAEXUDyt0djyT8SWRqpohIyliNAJ6SLHJBg2j/u/FlUkCXFoIH9cq38o+SMuZB6rNZUWX6t2I2V+GDugI=
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