BTnw0Tsp3hvFh6xbenb4qSHiIUKMvWWzEJeVjGbLgfNieZ3RzKWpQgXB7TgdI+dUhWpTAeqmrKptbhE66xmx+w4DqxbUuCXG5Rkb7jOYZlQ2dbv0QCdkuWA/Hix6/5PgzHP5zQQrx/D+cVW5Kxvjavs2qiW8fHmyvBiiDel5/UxYUpdHo4AS8hngducOelCtyrZW2e2mczfeUzkcZehElIaPLDSYtKSbpTk+JYbQWWMLK9I50+Ke0mLWmf62YP/g9W3yveEixIRjWrjRzDD/3nqeO7yNT6CTtsNemIFepC8vRBzQmuK4BCHw7tjfU1hCLS7UyzecYPKbCX7zXy2PXCJA/jeJ6PJZZjL4hgB+79craNadmZZGrD6s1e6ozqbgeKF9tDGeoSeXNEdOhWrnu0ucm8yTBvnty8UjfgW+E5gc4nnqtnH4QysW7ZrQi2OnWLf5Nv3BkSHKQmq2r2ldu95iEuuCfWzud3INvCokXWT07MQq2W286MnYZvFTS4Q4RxY1HGSF9StpqJ6nrblcc28g16dTEeNNk0Nz0VaDOUpWBVplDFVMGL9e/QTqciDH4im+TQhvOesK2yJ8aKGpoyN5KB8VTZ89p7U4whJwDM/Ud0f0XCzRT5/509UQDuAs0IGBkvWTEWyH+1Wb9gwP7QOzH9ZyotVu0TJ61JHitYZjpwwpjd9CckHvuA+X334W94cTTSOR1JX8jt7kPkA3L+Hb6OxMG5YPmV5336utc/knzPMK9xWuXHg8W6GWQg0fNlCMhABtENNpnL0k9/oLjQBmPPm8Y3yGlEfKE2wwhL4ZOZi9/AZoiWPvNlM1kz2Jed7yP5v0VS6qP5aQT/EUfgr2GeSfyEwuvZ+mTTqNFAJ4DXIFy+Ib5i2vpQGwZIcWOzEgrQT4T4DGGBxluL6kGhkNPaQMhKugP63bp5TEtho1u6ePeZwI16UBp5/Kqo30oqywLpFA1YrwZ887wFNr/q8sleYtHPMcRaLjRmOEryJVIRLYHsuKbJTZfKKlnJWQfB1QcE0KUsVwrwEdpONiYiEbUGXDeFgrIjJRHDjLJx+TOxEZbFEiYLenMppn1HQMJNU2mLECDRnEqQ49OtmytLke9zVu5yZyXIvQvaa/Snsyb3879qYpQ5+H1b+VskV5zNMomGZAc/wQxR6EO9QFryPYlcajJaqCE1H6bfbrrPfkLP7vZgyQm9F3+hKYplY9FcW/xlWerM0KlzU8RLN/zR9DaqEewM+Z/1dqjQ++LbarUHtX7h21jJ1ODZtClGkcdFSBBOqivxjdostjlgzyHDbPjIg0jNRh/oqpfUu5xb2+0e3dp6wHPFOTSNWbUvMmBQ+dU562FyKgnWwue22e9EQDSlqJ55/ilzAj8YY=
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