86mB437MRjB9J1MCejbD4Uxf0nefAqC39wxmLXaFVNYQ17B6947jWcJhJzM2Z3WbMy/UCRZfaIp5kjeuXwE3akqlvh0nSsP7lgNwbGaSCqcUxznNEcjqRFmXGG3TvJ4wvLChoOh+JT65WFmCGIQex8FJCgD8lKW8siLQPUU/yupQW4L38tYZEUdKK13wIiJS8ZDIfvRhcpT0ZjS/jZ9megjdmLIw5il2qhDdwx8PsI8e/wY1MxR/502xU1+mw/HErWKNwncrmf1bab4HGHJIoUmoX4QaboUoQnJn1TATDo/XdSiZ1XQYl7K4brZaqr18/e2yJDI/lV4PiLWQqUNpNrnTUb0QGUxl0f1jwxj7ria4EEymbrC6AEIMRq1TfQAZ7m0JwtVF54BswqtvGXXXpDQb3278s4NSgtPJnGWngErwgqgSECiSxqe1t6voV1ogKXUPdFVWI6r5kcaUWQ6V6f5XoCVnznP8ra2/z+3HUgGdKgFb7qutO8SA2+A5WPmvZ4hjsNc7V7yXRJVlP6PTsuz+AVM11lpSvLPull7bsNv8g+Kyzbx6lCrNKW0t8jslnHkpgZ04CVtvFXx5IOdWe/xtutecMHfUbNwSkWIgoLgvwAPZl5XF88i8ErAgxCaSytnrCHnqky8ntM7A3bLLtOnqiaT7YkYoAB68/wL7kU8cRuHWb6+GTF3GHJCX7kzSaYr1recoAmIKvMXbRdqAGwVyzP58FgazDE/dRSXzLJpRbGSQeRovoWuwrnEVWP7s2hOmT0eBn+fojGc6ahac1RLsu7SXXuXv3abOPbBLQiJQ2dU9s0jLwp1Qc9tOXvarYmONvbMGf1waGy3fi22H8QN1YEp7wANcj9Yxx4ubLuVjY66jZK1ciP4OfforKmGRQ+n4galvSF2VVkMx33NOVKFoBSQ3UrFhmj5b5Rsz+7wJdPBr0WFuy736DjF0w/weg3JrPRIyW1EOnjGvf5EXKWh7KtXmKkRDqNr3lljCYNWgNeepE+EgWU3qOD0aC02N5WE2rvmyeuh+Hf5G9QHTfWC/BQKH5wfQnHBKPzWffIZAglkWT2QMxRulRbUkm1lqRsuAivOvQG4w1wM+n6H22dn1h1Jri0iuawMO8rJkf9JsgFjiwphGHiBZ9CTLOqzAeiq65ZGZucyKKMiPMYeMi/8CebvoYRFyh7rA9kNKTAbj+ocdqsCGYeqzpJsgZy+koioa8YOws5OGFCdKp34J+/WeFq3AA4hRKDAuP93ovMzE5mUIOGXhRPlZa6wjPXHcFEaXbDTuMXpX23sdeUSEY62/DiLphXzyXFbJ1p6KLULTTbiTBQ3m3SqoT2XWKIJbFRAIql+XlLJD4qHXoQKLg6Jd6rXYXt/nMyxwW1A=
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