WfrKMxhPANBLjwEuYc9vCfhxiUfqPpevReHghmbwDM6GVwJyrS3AJ8IkZOwrAPaBQsKRwE+Wrgg/x9I+2SV/8NjqkRnNJBrs5wIBaKmpHIOxT1mQjqny+DHRkQcHpa8/58n5Kh06gcsznEHvj300zSM0hAkVw2haC8Y4Ogf7CddvouqfgDZyp6+wy0DuShNSPw2suq9G282A2Nbz5FCTPYc0k3g0E/TMVK/McLRT3oPQIZK1+MXxDdwEsbL8NL5WO3zj+iNOtsXZCFAqPAnNgKhg+mAr7s/uReDEkzi3vVvNpyWrPRUfBlQvb8lYrWR+jVXlXloq8MhB5WgH1IYE3S0L7W/adZjQ4YjSkBArIlKs9qeDgdzQKcHa+teuvxQS6tsfxCipbjuN/3da096zgKTVdO4frtHGSxQJeOo6hYAe+HN5K93NESPRsGzcJrK1d3UPga+Zy8QeyX00XLrEAM5RN35lta9yuqOsUBt1GnTTEgP0YDH7hVMr/igdnN6AEdvtTVfcJLGb41trzrJXWCXL8j+7joh8wZZLjRc2N+7T+h0vlW4+PSEYirGlFmPznRkTMnx2VvJc9IUcjVBM93LQy6PcHah1XaBW77by66k3s/2OgvgCNQdvC6lRJJM0MQtgH1rqIOQ3+QxdUmvBNwHkBakeXIVXl63O6KZ0pfFkgXcBtniIUhuXVzluRK72vvqSWjCjWFOMS24y0+czVTjKAsEn5q6SSktZmEhAar/sqDB44VMJfdsVQa54nOukK+DJ8S5L9+HJWs1P8yflXnXNA/jF8mFb7Y6Y7vWuWlGdyEF54ZeI5M+9pXWhLSLuFNkOZLFg6AqNhH7guyARk/KUklYbn/f5Z1hFg31wqjCLzAsg1J9LLdCg1igO/vHtp3AnhGKov/IaoPQwxujW4LpwlavGZi9Q7N9zGHXkuDqDgut1kJDhqXh1JVGAR4n6CKmxq6VgrmweX4773LLvVXOYvPiMKqkKu/sFUt6yq1mPlZ5H4A0fzFpwptGrVNGxI/v7qh6K7zVOhEE4wXESmPBBFWu5Qxx7LN1JyD7B3xrnJJlkX+oDMxYZbclGIwfGAOgJsV6rZUkbhcYWSS2/0O8+0RwxggjLaLRK1W6sEiXbiA4Y3BiF7m4otHBQEyYIWgf/BBGQYgQ3qewsa9WsaEoxD4gar7zS3P1q0Nfu1M9xYGMp3BL1D66Lol/CaoJ7CkJl+bkvID26oHqINsW7VPTOnhNZMj0Gjpc0GlcLO9S3Et5wGDmCICUjS/wQ/uc6rvpYBT8cfao63IKme+VrpiVPig069o1deO5Zj1J65EZ0jXzEJz6o0FDPjtU/HZqn2ANaPMlYuC+D0iYv+r4KN4Tt3vUOweRpa7ymnaI=
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