WmL+oMGwWCeO/OyCU2v7MWrp/c2M27BiQKdgJxg4l0fWu4MIC8gNpwTxAx7iDtk5FLDOtBkxc692EdLIofYNG8r4ZSHUu0cak3pqc/89kUGyStw2QWZukaCOOaMYHRowTw09i5I5tJJexi2rfAqf5c9FXTYdTJC02lS+/gplLoe/FY3i2+lDl7mJKhUVFCXD6Z6c0Ut73RC1wOsvpBCWogtGOhJ80mVWgRhk7prHuf7CrX1QffA9ocS2vro9nk68vq74pD4iw1L6+bigJRLDcWR5bde81OHgu86r+syzWuuThe9mBiYPmor7v25BUkZ97n+ACc+5kwjszqY6r3sB0MngfiOqrhzW0V+ESEIO7qGRdgJL7aPRb7dP9UZ58XnbiomTQpImzd2mG7lrbpJ8Gq1WEKoVUORek8EFWpH3907008+gFfhU+mVSF0O3gCeL+uhtTnyl+8apPPy/Z4TV9FfCleYHLeu6I+CclcwTB+TKTySPdsp0mJbgaE6HuOg+QXMxs7e8GVQy1gemKj3IZIZoEWV89pC5ZiX9Mp+FAH48kwJyrlbSgPCNs9IYgumRvh+y9g7hNqi4HfJun97S8yhYmJbei0KLctRzLkbRcHR6MfvlbzBRKEYkwalABYgcfEqKvbavbfUnQJ/oaBk7Fh5eSi17WksJwBUKAB6un6ChkEeJqNWiz2wYrdhMUm98B3IJ6uYACGeHXHWDGZE7rddGMxlxZbXGv/g6ui+R+mSWgT0YtaNq1haG1kMXWwx35GhwjqrNAp6PfRdc+XKKWAurQvmbiSU4sR6o6jz/RPBc595gn+Vie1EJcsP6eUewYZiS7hKl/A/g2Z2MVeehDXvHQmrskJPasoGh2WVn9We/+EdFRQLnX5KHG37Brl8Ee57ch3U2Q06O5jMgF+HAWjGDoADSMtKQp3WGdeZs/xVaEza0OQjPK3wpfb2Fv55GL13cLFoPQFQaYhuw1r3lMH/iHbHADAeDPWa5RguVV5cnUvg3BRJFvUfHUMORoGVvE4QWmHHo5H4p8S6I/oWjho3nar1n6UjfRjybjg+Q9hscOnM3f9HqfitTIwvy2pVKhfWuxYfaZHJkmo/bL75hlbDeRepMUH+hsJ/BrOU0ilV2nhrOWEr71rPotJUDBUvXuRgwu/pRwcVZDqsd0n2verY8aaq4f3uOD6XG9P1255YEzVxHPmTBcg+UdDHYBVWT+8n/U4hI9rR2oGQR79Bv+7/fhbDxGkdyzJ4bZOQeldVAJmKCH46G65n7uUE0MvR4vQtUiEcTzaNUUvq0y2FcB5JYnj5V40VZxvi0LuVCUfe/Uk+vHVIYEHNSab9hd3F+mhqXxpJUxx2L2y8Kb0MLQkcsPF+tUoaXBH+fBE4=
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