V8zEAO/xL95y2j/TB3shsZdH5rDQ834Nl+mHJLKXkT7h7xRb6MNdeBE8d4ZQ2NUzliY0kg+RroMALfJI6duxymj0GCebaVIBTaQGm8dNGVv9XSfCPEQdeVc6q9TV9UXxOlAwxljdRJVQcHoQy4kAa/PWxYsii8aZFVQjkG5ypmzMnsjz3drGjOypLrGH8P5y/RUSbo4sKAKtvDLj0J8OiLGQ09UxOrq5cll/uFDqr4+jHhGlcDuAy76CaB7Ot3LiaY6uFrjAhTF6vgSFc05FgDelu53p0bO/NXarhc6oMmBNNBgKLpAyoH85ns3lu0mQGZBIr9OEwKmzNvgP5V5cXw549GW+kov9SCoJ2/tv6hcG/1p6BBZcAMsQmi9bGuBVr+Vl7rNoC5gmwwAl2nMfM/lAcY9wulK0+LI0xzYOyz+3lpVAULkxT8lhIwK+2PKnYzeFFNtwUeRGXsdVPaEYrfdgqDKbTVVXDYxthKobGVdqvI7jWZTNdvUY44gDhKLH8gyIiuzQWsXvFW7Gc/n91qIBBqBZ7HGDEQ2SiPZz6ymKZG7eiUINaad1A4VpGliQrFvCCijLlaF3SPTc+gOoHyzvx5T8T3AUDmEDe7KuHDPfUGQa7d9x3IAwWhvRCG+Xtw7epZ8hjDMTGilHX8FgxKlaSzr9S8/FrVRP0GBRrtGBIkHZrvFTfwzhFKehwL9EWxQiUEtZGwmuEMtBU40pQLbYqSXtkqtn7CKC6owuKZXcVFRXURNERllvUCTQLRZB8DOtI/wyjwPXWB8R5cfmZPUOSIm5f/i3zblRm5rHc7Bjp12KRezhtjMb8RuunkafwcFR94D4pal+n3k4nF6gLj8eUGzmjiPk2zs4v8uRRl71oKzIyv+dKUnbPBKWF3YvRFevXW60cfvNBCpmMi980KijNff5hYZ0jMuhrhlhpV5Yf9/VTSCfaYhmeGbVEz0WNOwjwRkeMvDzv2qySjP9+gAPXwUdmJoEC6dg8z+8RkmBwAHhiXFspJApHmiyk3Tq9No76a4JjQmHiMOb2nnYwITUODcLjZ7eu+3tDG9/5g3R4j70cGciLzz1USBm6Cwv1sNM4dTAUlst12pJNhgTKkEzjaVI9UaesNfBdtia8nGL8yH1ZlOa6/rpUF+IkZMTYrpolzjjTle6xUwb2mnpj7E30/yXUUS3HTsjDHk5vvigqWacn2Do5Er/EJB2oyYo4dpLjvZZGomxmSSCGOgsScoAXONxXAf4eAWLQU5gpp/dy0yZ2v76NFU2+FRHSCuqjieiYJTi0/nRlYBXsXB4iUvmKKTm7yVYhw0UZg2j8r4ASUxPKv2cpWeHua/CuLxR6ZWHXeE+qYFFx2z+srNW+FMINUHmJMBn4F+plIs=
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