pBX8lUYbK3Xv2axypmip5JM2Z02xJKpfMBOPdk5Sw+GCmD5k8bZZ9rtWykP65BItaADF9Awwaz4obA+0K4ZIOpQrsLcjYsT68Tn/LtQlKkPTSD9DgsQ0KoVqVfbCkMs6eBvDyB4ijDwNnwK4Gl/dFsQeL2z44M0hUrPoiGD37sgI4p5faD9JOJyOgdNBHJawv+gZ6yB+SH9cwo0XnfsTwPOAPd9zJeYecJVY1nJ33SCgVbGQcz0UkXiSC4Gw47FcOhvJgyJsN+cZQwZMapUOzyOcMfHIlJfAyD8tjJrtF50WE7/I475PWmvA3vgyemWxWfU98lQ1skKGffvIEL3DcGERM3TnI6+1Z9OhI5VvJHa8xxSPP8OA4o1USCM0nZhx2bcqlP62c8Z5vLxS3dcD6IHKOwhUMxUyOQIEAZjePnHMvafhZhZLXib338vwvmlntqlPpoJPm8zKZyJtZgQK5tyXYH6mQKZizyIqADkdS0K2rfCuy3Ae6LAUOXLXoUnqT3y/oBY4ac/9nN0E0GnpHEEHNNctA+7eVJMs7OfsJjpldYqsWcGxACIqyU98LQIfmxYsSTZHGkTayYh+nQVb5mc7sio3uDg/4xyRnefRfrujFZBBgP7gaQnov/ulTlYuTuEembgkBbZ7ZTqeYcBf1yCcb7EcgWzEgjp30+x84x2eG914wwBDkUzz/s2GB5nQMWiRAHgDvxXpau6e7AAoYNhorTc8UuyKecd7oPLEgekHfLtwMkrpC8EIjeWEWLX472b0jZjY8NESltHIKEkZ0WDfdLzwEFwujhSgRfbuoAys7CFc4yMBOXixpD4Sp7ZZZ1FNsvNQ0xLzeieJT7oZywmjYYM/FLt4AqyrtnirlzceI/RF6kystY1ULaGOXbU8hz7GfjC3GtBVkfBrmLi67ubRHMm3SvA3VGMN91Ce+/dZEQPHx/Osn76jJzwWqRz9dab65xw9Zq/3IJod6TiQMWgiso1zpm1yyJGS/9inx/xty/wTnErCcZCiUs2aVznPoPyM49R3mUvRquWS/oOOuxib/5+hoBeVsorVAQDCkMQhV19AuxEETFdi7m+0rYWtqtS303Lnhtd374PGQrPFDL+aaLkLN+kQvf+AyAh02K/Iy4aOAyRmANaqS+NcvFTprlhnscyOan7xSRJWrEYcUbUozmprSOFnIggENNAycSf7nozK7MqWARZZnIL7fLFjKmTKAlBAe6eB04FZY0QzXATnV3IUMWXOySdwZ7U6k8QuKeAgu8Pnuk579UrzD1n/0yifxfGbN4YhIewOxanb+tZ5isaneayqNNaGlUT+erSpj+04R/qQz8m4M7esPm1zNCQeLLPQUxGH2N9Wzo4sEEOa7a+KPm6QyPaQ3+4=
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