kTnw4y6OPqdVDGpEikEst2PTEYheKD3RZE3DfkZbgGaqllhuikJqtLqu+Qf0UpTM5NEGf6wByWejcxFqIjpZ+8D09Lk00KHxoaP2ETlPfGs3d9XY9H0rPSJ4J+1AeiWiJs7rNKDgzrpt2AOlJc3O5YMO3bsdawgsn5JAnflPGQQT5PMbbdgipgVa+2byQdMpG1Un6EWIeB46I0sW+a2y/dxH1sLcQ+g7Zj/sPksEKNaB/u/Q1Kds03UEZtHFebmNdbwpnKoVbb8AfpXvWpPAyhCxMB+ntoJcUgQTCp/O+b3y0J1JCvkC9YxVkSVOQ0nhfOYDoj/k6nH9dXLkG7IeE0nSDma1/QaOoI2E+avU03WWT1FhF+HPEQ9k+Y/OAvsG7glMmwaYt49xW6qadP5dQ6gd4DlVXxnntX1rSBzagbvh8fqROnbRJFy9ekMg9OnYorWF1z8S5ytXVjaELbV9LxCXCAD+OxhtEfu2bjzFQZzfp2tjU+Sx+NMloapNgkUIGwTOsK2MaHr5y3bpxfL+cCSqqau2ZI222YhEqwQTWUWaxliip9VrEhfD9R0EIqFFeLwaa6ga/ozVXf9kjFe/yQhOyWdCXUfsazmJ6MKWz3Wr+RUpglYhVisBYdmUXaUG9Di3J41kR2sK9JJHVxYz49TWCuIbf6cLH89q33Bwwp2jm4wWB3xvDi1qJfvvu26DRdwg6bi+Gy+bBYyGmjyTUW/GQdPmxLBZk1FInQELv2LyVW72A2XEFPQ2DOSGkmwHEoakLCMxVF7J4XNukHkD72rUSiPzK68LPTanSbNVhOIpocUTnVOi6SYzXwzE6jkVUL4pICuo3tGFh/yz/Dm+hTJwVXrlQOOCyJDzX98izZwqf/002fLuSChujBrWP8jhoC5JbLKzY+zPTEyHiji7bKRjp/VIL/U1aYC4e7ZxaahFa3XT2tbH+LgAEvpRkg2Z+6p1uRwhRPWLVOoQtlZfi6Y6+FvkXF7xT5z/OKuKD9fursF6gYR68rYGmWh0lKTGU4V4JdCrFNlSaWaLQiKk9LhmulbK0i9+ACNKlRJzE52271rUXldHQSDHc8DO8QEYPbfes1Ojo0X5cEehkJwce+ynQ8qWBMlFogXA2h/ycpf6bpNooFzHsb4LJ0VF0vGNN4LD+al3Y6AYpoYS+39wjT/yBEQzXk8A6AucmMTQNZr4x7KwfIymMVaunUrMrXJxoHqsT2f8HwbFwQSDLq+K58KYfNvGTJU2Oi3Lm8MnrPCZxyEte/kncFkhw3dOzYh7ZIWBrps7NEU6ghB1zPRMsH0YdETrtNU6EpZNSHLj2knQmMnlkS+kdL69ResoNUaOT3crIqgZ3Z1Ytat9qg8mMFGNBs0DePRupwN1B+s=
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