PymG2+RvXdD5E8XdNIxucvf6Y668YTN+A2VCCOHfHqurpj/saUb97033nsWbixLI3qcoQAaNaBdLgSK5KypAHT79Kljz6IUHTde/N9azAc646epl4hPOAAC4WvCSDHHY2sMy7oKbBCpoT4/7GKphLhGVzlP+vuUzV8R+9F6GC0/cowS6xtUx5kEWxoxqnyP5EMdlKehiJ2L8THRqQh3BK0V3AizlW4q5uW74z4gzoHwYS/sbjhkIk9OScjsy7ceNt4FkWeBLRwOc1Rj14lP4Ph9CGebcVcdIFfFQmS8VRcNpT+zZEILQDtOl7sUp/FYDlAu6FEC7PfZYUYZtc4v5Tj6Wo7lKL234oxrkEkXN82meMzQWJbOaOIer5fyB3BDDzpezppDMEydYLNkXounf91I42sk/u0Bg08a8yMe/ysxOGPvdiip3oHCskYUzwnd/N4pchRraJYfm0yVnHNVbdi4p81yVw0zqmwQaBUOeNpUVbHlgYNmuqZGyzGica/4ZQk0OHEUl+HlGdD71k/+KZwSzceV+FHBjfhrFM00H0G3dJAqltbxuEjbZI5agPC52FLZsBXM+U0Ecm7b6O/fIuey8Zf9hsQ50RrJhFjf6N/WMfCRXRXpWb1gb9RJfjVsrQs2/dBGIKePMXS49xNTEnFul6k9pAEmUZ4wFNVAGHoyhFDo9jhLtUNc8dWp3dH7J9XU3sXzkkfEBguYQeyJcv8VWPAcZo9jaaxqs4oAgtFbcHfxszQEUnAOs6CIAkxqNyhKaLE4KZPZS5S/pRQvPzq9+7M57L4RjO827TmSZN3kdJT3jFGqc7GpQhYLoQRZ03S4965TnBT/pqoTLqoQZvS61Nm6K/+uX9zznIgrCS0MtyhiIuKloS5GMjsV1Jr0/wAsGyZnG0qiyriBwzH9ZNpyFrcmknq6Nq70DWcmJzqpoYUWS1VktpHl0s9roJ69ImZvNt0wPx6JaQoBDOO/9YXTjGP/8Clv5PQfTs/JT7k/vmxAGd7Da7ffLYbfWSGio1o7zS5/4KmleLGjeekJ+ZgfQqwdKpA3fy2kIml1UNYhBzmSy4dgVqOUrUFPhsT1gfaVxyBrH9uKHzRBWDkOZ7BpmVURqipkaekADv1SIla0ttRayOAc8OAGHd3WejyvAWDUc70ikqXt18qnuDEdYWjbZwJJ1rwVwz39CJE9ReyfMoER+U9olKHeStF/E6S6hlfwobRvTmhsy+Cc6EH7vXaxBAosZXT6FpUJreb1lltjSfO17nitFSk+Zweg9BOJnIjhCUvTsySQJArqBMlilYZnQwW81xtwREvQXQ0GFi7bzffIZ9GoTOHYUVctcGYxYjgzjFzikQPslBW2TQiWJGOb1FNxSU7S7gx8EQj4=
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