NsgRfNx8U9T+mDTvcCUrfYH5A89/MgWtmyUWtlbg5mSTT9VvvKEK0WkrR5wcgHhoQHxf8OPyn5QSKuO13PE6/hKFlQ3VHBk84S1SS5HJPPm9NktMLrt6t9OWB5mBeEqFkgTYBBAxkvjBaifODBjB0SLpWMDYZAVMf9tV2ANqtBDMCgjdYZlBkuOtVV7YCB7xVGFBN/LbG2GkJAiwKUHzAn0fXoRpcC2/JbTVi6fMDkvCmJd6005Qm092aCrKdcWXTj2bCTqBmaCijxIOUlD3jgN9GdIA4akA0FDFaYporkEKMMcDyqhDKMhk6IzRK8za9CRvLYSjjZ46d6SBb+113yiTYVVc9uQDrCKKlhDPfuwFrieJXn1AaxkKLKzAQamSwuNP1qZ+Xobg8bNDHmuMlTXpdn3bKkviOgfxmdLdgekrTjipJTJFJYGuYImrsmbm1OIVqb9rQpzf97ewijESJ4o4yidVJVi4XlcAT8EiH2onKqKdHMQEl0OJCokbVxlI/heyv1HBDUgsies1NECfBGyFy1h0a7US76LLDLURYaZ58ysJBr8gi5xfyxt1tHgBIeM5Smk0EV6GvwfDPTSuiIdcOZKF+CbDrquDdluLKQ426/4/Mu087Idt0QOJYtJFWLW6az6XGNQAMSbzB6U+G919k4yUYq93f9ZaAwlCWkhiJZ5fGIwKBYpniaPj9ZZa+0eFCgaL81l9yu3vPqjgDe7rPPyf6QXwiUf3h2BaYsZxvpVQ8GG8eVKZPSEvcnQRmlYOb5JMBrVGZ7+ptJDnhLVQxmkBD+OM44CNoGsc7Eamy+Whru05ojMeNhbKV9AKWP53i0ckI47YRk6P6ZJYZ5Tk1quTaLqy1jguPfMgdoTeHq90cHSKbCs6iz6TundXvI4sCSujv5tXDsnwKmQkdefobW9lSZlAaKbrdwcpQDjxarAp1kDG1KYHVDQeL/hPmUm6YjhYAacWA320qm8SE/RuPkgf7N9UCNh9c07Q+8tFa4n3FHbzaQB2eWANfLOejW8GdCpUYWW2HuwRWVqbTiJdfytLIiwEi/3b/rGqBG5sJee3K0fYTQzwFI4QgfSkVVIjtXErSMz3L6HeIOvx8jpoTQ+vwco/meoT1FiIUUsMsneMJqhFS0sJLzKjsFI1T2z4k2BZiGu6DKEkKMV0EjSH4dZzAd45ZTJmGcqQixPw1v1LxDpcNesWr9ONxT8sGzbj0yLSbtqdi1PpvUl8ZuUn/IN8UQNyDVPjSXiZIi9fbl7isrzml8zsN+AQXOuxkhz0jziAcq+l4kGED94xFcqXXc0gyjBRer+GRuk+wOQhKZTj7DM+COn+l0HbGSl8PFxUjEhz8v8cK3xkhW20wCZGwRftzIUcnC2P/Jg=
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