tndrjQhMlYvn9HMZTxer+cW75Jb9ToZDGKjM4mEDxKbBwKTWjTCTfafOj3+myBlbfMGajir4hB4vUQTDfYbZmhQphzWEC/e6WSNxJddJBG+09GDbnhonJVW85h2Vf8KTokvoN1o2QCWZ2JvBq3JJd1nNavrj0JV8v+QzW4qstdGRX1RwVA+V1mr8Th6OGSQroFo4enysvdgvLe2y8hNTbNQjm/Ic8XoUv0eCHjs4O8vaeP024bmaFN29G54hVSDyIItdGr7bGbDCE4wCKNCOA/u3PKBcrc05DiS9HEK1SQCngdTclzYMmad/sLC/w2yajHrgRhFP132Q5TwMZ5O5AZanT7IAdanz69P5NY5lNp6OeZnAR8n8D2qcGfpAk2rvp1OrUszY1DSwe/RdApJDkmLNRK9HzS9f9aZutyPX0EnK23jW8PBUWfidX+cJaZmIR6P/H2J7B5LJo1JdRbtzTvqRtNRXk5GiRD2NSvoiUeCVf9V2SA8ANoKVCkKEa91ygAYPcK5h0FUMWhL3mNIUokrQYpOW+Dpzd6XMem/zJGedEt/AUzwaj7+lAouVOKhT+Vj0Q+XlavaprfG/TaqGH/qafT7C0YC/ibi2eThThGEuVtn29H1By79jeet7vvkGYl2ayYLpnR5087yQ/bxbB+kpdWyKNsQopa8zys7EukSXQHKLfYbW+rO1VdTDqaA6dm+qeUXusB9OHRw3EtKq0zkhUzQzEeQHzZcBWBjYrBNF7pgTFUrLKWfxqydSAKta9vsFdZmfUuuJyuKD6cFr8Q8lgkXUNX7llvYqcdScN6c0ZblgbZvNk/WNoXPrdRyK7s2qFB+lXqo2qdtbgLOG9JyKdu2Q0XNkjF+pUdJvBBBp8q1h2lh9eNzzmhuRYFeepov1zI7CF4PPSkvpEQQVmLrd/gpWtQy3h8jjy3+EbMS1vLX3y5/EBrkTXK7MTZ8g3hZ519lTKgazh3AR+DR7ZCQv5f4mgg2tk9ISzuEgqxAHAhqCKm3dQYw18fnemoTFWrRpveAbhz9pmwvSjtBrq3bt8MXypgKOi9mFL+6G0Gw1SCMpg+6CZZ9bL0CDN0KDxnnm7SS410kk/PK3K4FbtluHT0u4+uZ1dpo7bxduhhkX4M5G5Mz0LhVCyyc73EB7YW2qmdaoqebLuEaioyBa5SJIKeRsl+fIvS/Q9a5wuSn5BeC1DkYeAANHbn4tMSND3yHLRhZPufgfxKfFVLXIDby+8lUyEUui0uMvddVvPi5wiJ5ly9ANzSoo7k//I8odY9frPJAQWZKwyKIakrDlvTrcdb96b0MvbYe733dK8hHIHwMy1t1ki7pzKDtHxbloJI3VqoMVz9cIIpOx65kKya6XYVNfXfPCiYhILrw=
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