U03EW73hFnjdKUmhIg4gq/tYSS7HJ7cF/zW3Bf0fMF5znAHHAeUkuX2iu+lhOvvo3b7koJj5qzF9cCY4CmnBFJbhaAyOzDGhx29mYRmtr4FFQjf+wOc7XdVx6EWjUz38zF0Q1rNmBc1w63YMPTaWyNjn1PBpWK+obblBoBiM+uWsFIqUNGkhRWWFQ1VgoMB3V7DxW3+vvL9T/G4x/H996fEYQ8Q/+xjdTQ3oZnwpEP5aHJMioeN4PRTKuInINIXOSx9PZuAhvnGeEGP2uawuPKWXksKaoOgafoet3NfxjDS9Jy6Igi8O+6CpeFqi6JB8o1MThN7QjWPOrAzaWuWzg5s6GpYUfAdVM9ln6Ol07rAMYEOnKEmfywRJFlYE08Scb+BO+EjakjSW2PCBXCpBFkgyofzda8j1plIXBuD7V6R6UdC6D+vZcnq0+tfaa8lUvVZLa4WMpygIqbPWIWFMutqrQaEqVDemH65qjmt4B+BNZrWHZ4ieeBE9YyKZoiAXMAGWQ6FXOwa34SbZtoy0ePTTGANDzKv00CAJnWwOg/T5DLiEUhTHa8RO7Ca1j97mFOcxXjQuExDOv+ZBEIlt05Ym/9QK5uV4mGXqvkhXbgOFnHk+TlztlFu4V0QxD7N2Astr1CGUo8F7hpoJJ94FOfmAZRe1L+O5BVDXsaWT45pjSAOleZydVojBG1w+mi+tRY5Jhq3SB9N5tjUWPE/8P+wyuiopiJUoTkO3Xb8B4Gw73X6qvW44yEQnYcYZUAhs4pt5NTod5VoJX78IPydruVlAQdeRfZesfPdhqujQg6kmuMw0O+BQDQtInvpE6+HtooAxSVW3K4YjGJUyAq5+XauXwQEJTBJwKQwL8VyFFetSwHW4MTbbKj7GmrpemSkXZt+eY1jVoliYtLXslX6VwrOZ9MbNJbuHV66zilUdwpfVA4wqln3ZLrX92a1ijZTOve2EzsjfOBXeqS5P2aawxuwp/mJxuThyf5OwXnbMk297ZSmFxvDcX/o95r3nc/ZDCCK0tfRe9N/qBeosisuIXv+ULTz/SW/X04V3er9k4q1QsUwIeRuVopFQZxUh6wkt7vRiwLwLPhH4w+ggFmhRRtiv4OZn16hPpyW3Ihpc+Wyz5B5E6N2tnVhjUZRZG5wldn6l6n4G15UESrMwVCi3ZHkzQ+zOmGnNo0B+VylYFiq3v4VvcQDMjBKWy20z5SO1oUAse0jt8qR+9mAl/0jV2te2AdkYHrh0hOEc2oV0yp2N+Migf1+Iz0Rf8tDDzJT9yKNMuwnlruLiTHMfncrOXpc+dCAiEXSb9328gtL21r5hiR6nnEltTphH7dKSQ03Is9mTWCocReeOLohVFL2nIgm5VjZ+hkn/F7Zqv3Y=
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