zG4jrzz6DmPMW4UN2T9A4k4aX0eDUfz0s8vRrjZw19AuSu8FVth+oetjICg9bj3XqR2jliE9sDOGaIK7jyihJCcWMtIUbnAlPbtHfoB/L0UKYL36kY9Gpum4fOhuI9GGdOL4O/V8JzN+wg9nD4eWrsbwOli1IXMdV6J2UDguHc4Wjl9S1QQdMYHE/QATv6j55gP6bQXZ6+I9K3Cpu6nqvIJYTliJhY6asI46yfexAHAZie2r9OZOo6y7LmzGbrKzoa1op6kMn+hzWX5GVLTAMYa0zcn4PVr4OZ7zZ43diItMuWhxhubXe1GygIzxIjTFOIDjd9h0yrbfFt5Ll7IbcT4PnSlSuorsdXkdGi4DPTIDj7DphUaNJ1E98crw58QwPvr0FuMHHHSWiCSxDTCvVmGvPZhaZa7XvMCa0x7bKMFIeQPJu3ah56s7mov2ODt8zX//tcsnAmYFWiQPf0fUd/wYkeCu5HyQEqnKQtn/jcJg03TH53UheBwULEv/W4SinKWO22/e7+AdGH890dCTiFM9tSDIDERfvQ4KEdWe+oLkGmyfsCAYPbGHGG5b4/9Zu1rJ2Q1LfnrV6v2zcR+GTY9DA4MxveUhB9XXBlaD8BKRjFO6SbcIIlbEDf0tZ7csmdgKZp7Bn045gl04IN0uej6VKcDSyGQDtkWAPv/HZQX+00Ny8OiLPM+2OEBzQHCeAeZ4+jFu7BUMd2mACRBGnHb0jSS+eaKWqZ/Pq4HW4kaEqdoxvx1gWh1w25JOBpB6GFfBGYjEJcVczbwlsVupTk7SScjaOj920FsFY2TOR0b2LW/gROyfvLRN1c4LR7FgtlDr3M8YCmPbYtUIyTcrQCGTsEorjdIBjP0QfIczclCHjClM/8SHHDms0dNVEuPrEd49LzbiaqHoZkzIvUbOJ0RCuJ5I8K9mXrWLrfW7u4Hfe2c1wdBJ8jbtmEtT6ljZvCWVOCI7CxNOFca/POpjtjV4NYkWLGek7S6nE7k2cov2N0kRH8NwWQSG5Ddbc3KdrZ08chwgnVB3xvT/55oQNsMSbtNZnH2Qs9UrxSlvCmjoqiofU/LCQ20rEw/CqALWYvH3FDBeYskh9/ttw6JMppI6PLSZI25kxVdmvxIhHG0U4ssKAc/AYb/ooKkYQY5OtglNhlXzy/2hz2YF1vzEJEgv0A6fZGSeF3/9mPV2x1sQq11u/HeIMNx9pE351ydSohIJKOE7gjMacRMEfax/fKKDZWNGm3ykz/DOxKUCzp3uzZ77TgWX0mtDptAtswnysiTW0B3pbNU3t98Aebwncp6FaraDu4iFLXMuzAk0UHFFsuSBxiJ1PG08s+b1zeNBG6zI0edOdVN2mZotT3QuXYcWPwV6NEz+LBTCW8g=
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