RHMbIh4+jTEC6kO8YkKU98YCw1RJiKfVESWjzF8TyCa3G05l9y/dZedGvAm5aw8SlNoxg61t1knx4eHPdNagDf1udDUiOlgvCF+zvoJKn7GAfXT7NJks8usbjj94NmpVvah9wsRb0Edyhh/WN04BsBqvKSyADffR7yr1hXYgEpKvABf6cwKsSnp6lf0P+WHmUH0AL55VhIHriwFILZ8RybLRVLQmDzg4qrTAxwWrApzyWq1fH+TzKsRqZ3FG7xgLq+/P2rVbH01C9/GIkIUDObSq1VJ4LTYYnUht2c88VJ928WlhRUfk80/lB/2FI0ZfIh25WBx6Bh0u1k09doZPIG62XfK48nqcwO8Uy+Q5teHHmskn8Z8RB2BmAEiMhEyCk94vp2FGJLaY6JCXoEgLejrdKF0xK23g/tBwRtszKDxyxOassTF+1V03mtUKzskv/fmwIAD6YegaG/8uiX+3vdC5BXzl1z4yvDD5u/9EN2CqWYDwYRYJ+g5REbBMulaL8VVdDyg6CXGV+dMlr5JYEblNc3GKNMDHFo+Zpiopyy3JvADSM3scqV43LjoQw5mZa2LR4BvR/PQn/5p62nFB74oPckxRqH6EJarnPsWrbHjbO9/wxZaNXo8PyIK5lFKzznCNXoUaD0ny9YjbqehAdYvFG/+NKFUTlxjeh4liI0gflEaRV0TbVSpUxr8C1J+cZtN33j6Ue9fIXwVnqgFp5IjOR4wNJDtW9OIe+QZ+E/D3eglsIogUUahf1NzvvLjZtRomd3WfH3gmC/Lywa6M+RRFo94E9GE0G0mH3KfRk7zqojDE3G+yq+TlfqYQwyu8HH1CSvAlSmvGRtbQWcd9hZsuRX/miqMUEoq5yVnFbGPonY1MVt/awx6ZErYnVlHd8s3qtkqGLHg9Ik9/NmMex6rM/x5J7NzfKcGmOnkbjeV/TD0AZO9/s9s0DIdM9Fq0YFZg0yVxb20acNBS8khihQwyKX+pM9KGmhPxCTHXRS03eoXxHwttrlkdVHfhdYpu2u2zNDt+2u2dGNlSOLqzZZEKx4QvszeZbBLswhzs9uKts3WepyH2mlF+hyI0GEeII6wT5/YO9UKdR1yNfXYAtYr6BlFzJzeMHAGx9sKITQqa/xhC5avr3sUy1EtNTt2BYAwqRMFlc1kZjOR3ePGO8ONwKM3WWqjynOnl4Zl/oHSZJDadkFGIxPcrwwCOjte5plmi5l2vTLGq4C0/ZEnhunLNIwuv76Mcrc7B1WioD9pcwdeWunKADQ/4C05jRAnh864DHBxO94LAGXaCQCB+x7aZu6v2gVuiiKqK0LyLz0yqmpkhZIwmqzhemdmI+OUNOIZFgypikqTzEqnRO6GaUSfFQ+TW6wTIAfAzCg0=
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