5dXTwAPWvgmdGoA7sR+8Mmrw6CvD4pXr08Q7UfZoJ4lZ/ysVRd01knizgCi7I9v3BXJGhylj8mhFqzgn/lPP45L8CkYYhUseWNaCkeQ5P3M/l2J5y17YLgtMWgCaLzLNwPnMnRV9wnF8zDNIkKBixrP1WOuS4XBn25q2i2cSNge+8wUonvWegr5SuyeoZTshlSyhgi/nGP6/msww3CaxyROVRKPjJkpMY+cItf0fhIBOBFNz4vgeCmoCqI2M1RSy1CM8ADUS0LUTcTTKwjdgsmaGhQ803l4L8L+6szTA1flJF7/MJoKth0VYejNpulu/3SqEZe7BA5aObu0A79ywWgE2zoBTaYEHF6vQGk6IvUp+gB9E1BGJQXeNS6sk3M8E4uImnAjy9lzyvnq2lg8/lyaaPdW02odcHxohZ2efM5OJe1e/BatpX0YJ5uIDZkf1ii0sAXLnd1il8WXJz3UCoIp0Di6zGOa1gq0FeNXOPKrAB7gRZQEDHR94m8Vojagj+mXmUUkJ4KpUQYTveP362bXQcaumRsJezEgWfNVtv5gpLWU3+WOr5MvGOHQ0gFNnYJdYognIUVBNrCHyAdhloiGWaigynnYs85keXXS4tbdtduQJgQFc8hYj1c5A7F/GlQgEIjM/WRK+/H6M305qQuzSIF6nDH2DEpu64yhdoWdrSOUgAyjjr9gKWm9/EFHPq8JGHF6VSriuPD7zNuNzFFsyEut+k+oa+N/6CZXK+e0QwHBpThaO9gnd1wdDDSHlIzex1tjHTGkOg1QbRcexQNl0KHH0xL+yUoAjzrQpyRAQiMi54lk6pmQWT0uM9ePToceKHfMDeMCLNcTtbme7l78TVLkEyoEcSBMA7bxfJEKanP6jaYkgyAHtsyx7ZWwcAbUpHEA6s5PjzeCZTy+7/BWOMyO0YF2BKlPlcwLZlvrTm4CcwOj9VZuyJMVkCVdOf4ybC2CtFOzEnOLiP6soV5HmlhB8GTHC0RjYFNOZKEPdI8870oX5D9UVJK2sklqxApwmrIZ9XINVGLr7uGKm/ZcYP/Y6ycMIBrT9v0LhLKq53cyk0QHwqD8WM0/cCRh4jzZmlBt7+IcHwxuZM54ELs6tWpgrVAJOQ/aeS7C5sRTfMQTq5DVaf4/kqaKfPBzpKXpNEwkxqVeQVC6WlDbctX/l8436Bb90Ll1TtzHj3WE+tc/V6ZiczcgxQ1PcD7JgJKW2QcAMH6oYeZxrmiyN7TmPSIevySbBOt9E576QkaCo0+S7sWeYiqkuiiucpAhD8l8cGv0+U8n0kmfCYa5eEJKeG0as5NhRYZw1JMEl8t1XvSaCUi0Ya5ORrHGHv8KIUD5qJotD9+8NmP3693U8IZIQ5FXF7B/k9kp78S0=
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