9Zv8MJllh5cH+WLgZFT1K/zUqM67hDoBgvtdut4ztbWvhMo49yZ9qlXx0TQ29zxzveP+ZHiP6A2O77VPzGo/n0oPS3U2lghnHplZCHt+28g5VNavGQE4pEiCOWpgagviij6JM9INyKKuSUaJW9moAE11olbupw4njSfm7sA/UGoIHnRvHSSvK1EhzLvZqDeTIhMssQ4ea2vbXQ0Kd4PG6V7kzgatpNDHePcBMdsFeD1gACJ3IWjkewWGKjUjj3YBbqtHKr6/DWGkrKEw/XIEj8Wzn7mkdzXOeFo8bsD1aOBeDcbGMD9cbJR7a/BlzN6ygB8sIN569T2dEMcn7b2IbCu5Gg1n1U6cV5HEXi9p42hzdUaFxdADU3wuOmC08IgxLtgd7JtO/G8e/wa2kmP9xmPw5u//1kHQynP22YZ9dtox861m91hSyJyuy1PfDqnW4Q12auptoCzke9Xfg3psVrpC7xDNvPZhWDqhO2qEO2/IX7Jyjf7EUFAcwmKHIaVK6R2j9ZGgdWoP2pk5y7+qHy4LlFqpKU01XbOOzJSFDqmIdBe8MvnL3+ZEee7fWZbvrsRVCyNrXAgiRmKlFWy9n+tfB7Mg0xPIekmffuKZIXGNKSGJ73vJ4N6NNfC5qgkdN9oCj6TjjurOoqZdY7JR/5tTB/1EE4RtQRmnqjPLZYi6ehUjLPNtZr5/33oSck6lhBo7zvsBVXCkHUIXfQApOF/LW1Y8uApA4XKm4H7eXZofHCTRiPXCScpCEXDzZ9Fm5XpDtGwJLwtFApQTP5/9Sx8kCuF/ru0HKUt2NlNM9A2MlXkELu3qJAwalZkPQ8Zers79cQ/2LOQCnHia6+IMfXWXi098sK0Xq3ik3yH9BAX7JrCP4CA+lZMq73ofnE1n3PNMoUhcS2f4XG2vE4SpXGqV7RaipNnbwQICFQnh3MwKmTA1j24mZazPZKMMjqBfNZFa5KFOdoZRLw5fUA7kDOgKIXQnDAaEb0Wk023+26Rh0QvcTPbqAs3ibm0s3DuEmO2QaMwzsoUMvpq7XrHZq0mmJ0ojafvIKXiHstIQZ9TnlfEtw+869bJ1AiO4d8k5vAJlkbEoDr0jTNTOFZJFSHQpeDeQUIyFT86bUi7p4OQSF7PiLxKGrsV+hmq71AX11XY112mCnqa12KweB7dxCk3Qx+l3udRMVFIblmE9crcXGPv1kpphUPy5Nh6SBpwmv+exG6EJXQkUDpwhopdsNLyKTQzGNydct7KyCh28ukru1Jp91Ge+cWEWWzC7ZiIIxhwh+AgGiluJhBLA2cLdpvnDuvZwNJOQADQWZmCtFxYrL1fITvlWK4D1CiW3+mt5tmKCKHdiGtdJJCSUdlViZoSVZSEimaHXefwWJ4M=
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