TuG1JdWdJMz8wIeag/+i/QwbRMjhXK1+5mUi1o88nm+20bsUfo5tx0Pz/9fCRf021XoAIyEFqrWHQdjH0qt+DcwvKf+8ulSJvK+CfZMTFshTKd9uj2UbVr1iqBoUWMnd58w/DrV8FnN3kPHrpa1MWCVjsnKPFZmDpqgt05EczvW5JNTwBI4U9qubvhWxhNfuu7aYN2vds5aOMKWbCaZ7gnzPHUm1fLDr0EwMv46Xw+E8bO6CWQf0unvIXUXkFT/jJK4mkGxrJEnltCLLc9hgT6uCwbVnjUQjF2EkeFNcRTYugErpMED9o3GdxEDIpaRIFsXGAHryhUmxQP4xF3GC0AUHKYkwDHQCNWXC59jHV84eQJ9sHeot/83f6T7d09rw5mKOBug8fblqj2bARuX7ZUaZO8tS3fTUH1toODvlDm0hvFbpRR7R43yFmnElTjcM1Wq8FxNMgP9OyUqBNWKGkf1P7EWh2uBCuY2e/0cb7ieowyUIgOcbWtNyRFNBxFjjvU4TYbU4h61TAT3U2HQO/sQYGHcz9KIsVhuysMicZm0nwgt5KkNSgjZ8frJj0yn7bx4eRs7/XpwZ9/xoyPcbH4fJCmCwKBmE2jQ8PnHVGVpMycsoIdYLcBjLG7rwcQt3Qzr+oBXyLUgulpCnw7rr+6DO7eRnTCwdwOR0lRAnVQb2uZ0/uVWDS/AxkCUghL5xmCf9woisekzDy6T7AnEGmenPBJAsQLJnT80+40tzpEx4fukFtM6fUMpipf9jHFHKlSZO68O5IQBkrztTID+uXk8ryVyuDDW+9SloI9kMg1tunmaaw0VHuZ+uNeH807stZBZGOuNzubGYCGKuw4+6lWhHIyhRMGSugWeKxuoJBguiihCc0Ce+SEPl2su9FPfMw54rbm4dBH9OqO3UyUbKYU6mOrqhkp7tVCs7QtWxGkJsKY3lnpiViJRgRlZZU1rifKgYKAgQcelmv5VKeU2dtLL3ZY70yr+QSLUnc1purkNq434q2FiUMRecyvfk+3MCfWN92zVA0LPk1FkLZ4nVwYNQqdaLZSIFOvc9+1tYIDnEDRCpePe3sB+rtQm5Aeae0GgUCwgvB5sZhVu9Hj1edAuAQn7xrPwZYWYkxxMTvnyZEyNZXG/Xh/EqAzlEqK935Ds5hbDJYAYFjCYNugX/+bxnkGNLGIsIJCFkhJrvQE6YO6c8k+v+hXwvcY62RA/y9/sRE20GNxZi6vSVQvm/G+EU3r5CnNSvM/TmkaSP007q6moQ0btRi+aIvAAWGNXgyyQ07ZdCIBmCg3dlN+lXJ3lanli2DZYgyADJgOpkkN/XNJP9b5H0DllhoiiS+ZF1PE5ABFLtIWVYp0rMjU8lnXFsII0KVe+JJ1NpP98=
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