+qFCHdUVavslmbfQzzfm9QmSxkV2keZplnC59ZdXLwG5NZOii0f4kBhIrN5RXxVxRVU/ADO+pGFmYwLwpuySlpgx4xA6ZmTa6+svj/xRGkd670LozSBpvcv5I6XZmN5PJT9egV0wCeeS9I4o4ey3VRLw7VVvD4KSeNl6iv0das90Z5SWy3/BRFWs1l7MrjzHxOm8AEP3PFync7c3i4+RwysDMe4s0YBlt6gpKGmxhdPVZ74TG+RNU6/bcT1RYxT7XlXtzDdzCVZm2VNVEBIVgImCVZjvJBKiMX6bHDGYHpPpAZlcWQinHOXYjqYFprRhYH+sG5OsNphV+S4HwxZiqqsSp14TQUphObo6KouGXfCuvMdDXjALpsvmZx5hJIfekEJWkkVTrtFm7J4fEb9ao6cH1pxZA+ezTVxburP8ivA4LUlhUCU9GArbkLlempcVm4n2FFFB1ICDWXrjppi+6H3jpzSNYY8FcFk3WjSBwiOTLwoKIZxefBhycMU1YOPsjvmlEYELj8O5Lh4yIjQUhEWN9E0HvQrgpB+4VXdvq8VLxeQudAL+lUsperID7Kqp6VgIfcRQM8GEjREyP6+Ph7UZx976tv8cCAqIf+a7amv6c/DwrP2eku9l0rQ62JTPwZs7uXDtbEuHrr1b/gmA56/4MtbCrpSUNiqhG0mupCutSjb+uI9hu9MWRMIb9kkW/iw2lB8CwHOujlckJeynePS2mmnyoklzRFBGx+401WldfEjIPtgE1qmiepnGBD42lL9bofw95UWsXrgkAqfrH92uaLzTu93jhS6jXgonvjbKLJo2BJ33LkQlaKmKO+T7S91omMfWz7pxFnA/2CY+Gd2qW7Kt2VVDcThsTkH8i6TaiEx600hbDvQ7L6tOZZ3LvumDiUlFD90RX6/i2mjiAQm/oksHRj9ZuoWOsjVqDRc6Jx4ExysmQZhrz+vlRpppPUOJfMhLeYK7tljYIhJNXW1JDqUuikhwRf6OKWFOTWVIa4rhBwoXZ9IPFn9omj0CtZemOpRXoJHOBAzqZxlWjm/3ZTvYXoCRw0nUhxwowwwwO6VVLpCy5b0JmwehXyMkY6DqUik5uHI0mN04b3pZxKKuwvWOdE0hwg1lnXG5XKBxRk46V16Z008kCwm1ZkZSvjZij1pzsFy5gDVxVkyEh+Vr4FO9NS3iAHTc1Y+pfMgV4VdM9bd7bx8DvQ6O3mSE4m7i2QkYpq3h759CH0G3KQOIL9GOZSjXVscGB2WxiM7G8volLgldkW81AvHAQDzwga1Y4FhJhg4ikDn4G8PLGHCTbOgQsI+0ZR34kHqz+akhtNWK/c96qbozZUM7lLSqUsLMBhlp0PHlaq+gZK+xzNk+lca4uWEWi8cgS9Y=
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