yVtQ/aIKnD3iuzAjWmJWmqqZ2VJzhzz+aQmqn5P4zRvwuidA57o1pRaUM4zWWKuO2sG5d+k+e76wCSKJjTkjb/FslhP6XF9JYl5j7ZAltsHFq6zyHeHrGIXdGD+sador57s20CtFlu76x/gqM3XRwrf0LmIReViDpG+B5mffRuuGCc1gUMoMqirnhOyPAUkEejRAHkoHvrfeasxtufHdeTcMtrBObHbYlVF/rIk5oACimHMbuuQrVipea4TMmZhraZ+WXiUjfH3eSeEKFIaMCsMJD9b2cnbX1yIGUWBASrCNydRQkBc/RJa4viiqRXLeE7jvXgI+bmd56XNRpOrZ85ZIWTLnlID9Vd6NOUTepdGAU24KOxyMNK4OiamIQP/+vhou/rv9/VRyGuF7XVr2RSvu05dhRJwjwaiO5ibvX7WWHj5o5oAe+SJYLzCzV3/Pg9C0YRhf08r02so+jNS2D3WU5wgLDw6XT2GzWZdvixCIgZ3lyj/jV7ddoTwJpctZjpMHsL1e0TmAqmi6ACnivJzvHFQvLiUlQWH08H+Y8/JVmTd3BkNuGZrbdiJ8S8fhLMjNzAEyCjA/uTr+2/5LCVFPuobCH2zQ6hfwSql6HJ8ljkjzfSnWm13W6nkINSTwu2PNIlJk81JcjRZETPgojmQTim8s9BFuQ4hogi6ohjJ1PPukWh2Q8goOf1NXMwUghJ46wq8wkhOsIcsxl4wAacE9xk223Fy18DD6wkSBEg5SJqsmwOWcRs0h6VRyKvIqmFGmNmLgDWdUHrlmkMPxmsmSf4BCXZmYsyMMzRYW7fEA4W4PicbDhlv6ovDi3TY809eQyLuSkAvV4rsJOS+b93XTuN4TSVzSdwohdLPXZwQrFtVxf5lI9q/5b57qVuZkqvWoL2YAET+uchN+/GhVfDpzrmLdnD7R2/qO3tAheU6Ivg2fJZIm+eOvk6OA3bj4fkO/xoQmHdySEyeAL0jPZ/TAxGTwCAH46iWKU51YQAa9JUcryJQWGUi5bNHtrzO9h2GcS33y/sjsQmbGLvs+b3tsEb3fG6jK7WfqGcs49TfmcQPk6+mqz66TWB2K0doJQ/aAhVlEgeaXIUjfB/gmIAuaA9RhBhCO05CLKKlusL+/jrrzBc0jXkvbEYhu9mwcYI+KmbZphK+isQnQKY3CXBUOIP5Cq4LQsKdutf3btRBLGsUH3shS6XL4340W0KUPfQx+OQ6sbGIzcenL6lZBdsg/WJ3mL5WsEsy4goPVWSOs+mkmlSUU4nalCX7J0U5/HmrkX54PviM+RKj44vmJdEFCjMf2B2LDhsMO5EjnENN+GwjNqT9KN43vyotaOsHhw7AcBgpgtT7sqt5N0u3rHutJWG9fnh6w7vQ0I20=
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