FixxseYjRyXqhmd0tzidBlkR+zisyFuhOWcxAKkTidJiph7yFCRdA2CZ1lSAHC7dzTf0zqoNYi/J+YOwQo2a611yWZInywi2UVqer/1drprSqZqF2x8+8jcQw7P6TDoAh9UhqCN353GlpWyWFG2tdMNKdaSlL32rsb/3dp+KvAvYYbheYwOdR3/EF95Vq1bxMWWzWykqXHjry8S4lfdFrUl1Kmwv6hRhzDGI3SKkCqceU+h9kCgds37C3YcyPbkGX8ET2YOagVwQskhRj5XeVU1PsBNf6gBuA1YiUEBIy769UDalA89zh7qi5v2hswhqy0mqNixkYIneD7aMmdv3Y9KDtQcuzWNEoEZ11eh+CHjqaDZhtoq41MhlmrYHL+tGCly9xXRPeXsEz0gq70XD8VidwuMelQw69cw49HieSgIOk13hhpJJLNRC7L+668o3IsnX1Kjx/IuHybBQas/A4ud3hp4pDvVTyY/7FLBEvPchHjS7xytHcInYzEKKZ49JMq44o/kNkgdmbuy4mcqadQ6UPhgPaU//h4eqJsdnhqg68ZXav6ql0rlWfLGssNr/gXN2IlpKWr5zRbihNVUToET3SWU0+Hte6eSnsQ+LVj9X0JwaVu+ypy0VMBTVylOdi6F5pe6cqVuWPDkYaEFY5Qu2P7OC0iQvBnJkRok2y9tgzDriT8Q06adBKdt32CsHfrurOSoLldksQlHhXHjWTLjjecyPe0B+skGKbOGyIvQqjAKlVxY5BckUDs5hBQ9CP8JD5YUEoyKKV3vkMHFYd29So3dTINfgFQMFK6l+RqV3/tD9EbGvVIk+QK9NdaXfLQG0K9aA27Y9G1yoVin1mpqNexzh5RdIpmDiQFBbzGVSHga3EmIzgtnyMUK+aKoUHaLON4mBOXWK5ZP5HoHWBoQS0IAfOH1UIaUfTIy2hL5YIDUSJt9bbp91UDkTaVzIyIQwoUdVvCcoAkxkmp4w77Ra26WGCnMplsrrqSdQw2N1UWYRc0U2vWODe21WkUyVeJB/CaYiV/9Z3vb1XuiuGG0CXQ9nPplJnXTbb6ow87c+KUgq4SzLmlzYxWkRjqZ7yjM4X9Aor1QBao0a/23Tyv7T4h58Ly0MweFZsdOsNzCUA4bUpZtGj5Z7+v4+8GAuz9j4SjKk2aF0UWtzQUctE6wQFAReDGKtPFpDBH4sPxUEY1daobY9UcLbI6tDdQZL07rwpY81ZNZw5lIP2wFgluww2BdFNLhbmdW3E3CaQJpiB5n++nw7VktQG/TfPokrmxMbyx8MeELSXfiIwIUkLgHNhKHnegol8/v1dP8bNnBhHdJ68tzxMoIftAVdVHxBU6+qBTQD/183Qkm/xy/Z0Qo+FLpwLqOgtkmviKE=
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