5wvmN4mIg8GcuWzVJ2fgcsx9wcAn24x8HwsFTZwF612n2cfyC66QsoHeHUO1GPRglLIchpkyUuNzYuZLv+0ZEvbLksvt2PIc8dQ48AxgvcLSXffRuiF1FtYoi/mRd8cIHv/b21+3oizVEK3GRVKh2YCdKIboiOqOXc+u1RhZJHsvwekOOxanxZ3zCWLBBEIZPaS2g4MC+r/lX7ZZXDRuXt6QFot6Hi6tqpiBVlPk4DiEy4/Ns2LxYjT91OkEdL6GwBBDYORqrtTuvnTJXCvqEgQd24LnkmimYm/8bs8QM5R8Fiu/tt3He/DXZbyn4aZ6ZOk4DN4auVE3xJP0ic4RUcEN+EIiu3o10W48ifQ/CMLMfjnsPnnJ3ByFEvTmSz7owp9i1L0s5hyF76rLKUvAQzPzjzytygC8qF/E4OLJRYFpEGOuOetTZiTbkk06b0fsp1RJ0c8PJfPIgEL2AEuv3wLfD4eX950VE+EqHTbsQzU5toygN+TPommQXVFsQAbb/4stsm+uRtfhgTq2C27BGQAsfOfI2zpGWr/zF2Nbe7ApwSJjU6wKy8qftYz2bz/xS1j6xmJ3A4RiDPVOBuiDY1+DT6rntaqzE7HuXOl8hEO6UD75OAy4Q2lJ1B08KuCENDIQ+d1xc/IkaF/LSVfXvvOB19AAM7jdix5D/rNHviKKWnTxFu2t9dD0/5LGAsTpfqlAs/68gNuMMiWo4snkssgLatUnvHxFx9UUj0M3/BZ46z/XYJyY8CF9GzKe662aVP4iXSn8SP6gjHGBEWcXCcTapopjNGvxmmcSauLyJEOOBhkhwcBwOle8bpg5KF0VUGqOY8ExgG3Dcu2jIOKU4ZwoOzYDTPWdxqJcuwBopVV/N4LVlC4rzIbxjN3N4Raslxg3R9SuTGbAP6BVEgKoqbPjHjlcCRdOWgLHcAbAQmCT8oY8nyppnKeh0q1g8/MUWytojjR+yXvTTlkXA6yx+H81cUYgDho8/3Ys/My323LBrkuBfOHRu6LuNu9IpQuYUmqkUMiw0cL1KXHEUfYBAQr1Ct+ZRPgk4V8DfrZyF1AOkP3xVexrV9RpaqHRKt+h5z7GlQ/NQOhwn+MXsSq0dFbVUuId0icjEAI+nS0Y/+U1WGh8XrpAAZpowCNQWyVqQO9WIu/0C1FeGy2FE4iK70FeWrUrpVYbsEMRolZrFv7hgQs9g0R4lOeQ3qaTqtcEIJDElSx/ZdZ3Exjf7cN+CHZ9TwMeQozOHOFKjPrF1cmrLzLqwT5MM36PtToYBapB1QYlyJAWOakJiCILiv3knFTqZjlv9064ikynKEwNTn8ePvzuYpetRg4ZJK7YmZEgCrRdLUzava1f1A+mC9VTPwv1aRX4nTWXXAKkzUg=
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