P/tTioBHx7gqPQbkg/VxgVUkWBjGswy0IjgXzZ/alezDNM7+ZE94y0KI4p9HTAZ11bvr/+fzE7KbG6sko1s5qX1R/IQUm5RgtrTqw/JMGfifQQAQDuUs9RQExYCrR4FB6xW0+GIh6OeZeciCbKSrrTQ7SVRAA57W2XjdwiA893z/kkTnUTYX7pun3yYaC2k98G88HPPq8MCOMCYNDFLUyOPO4P8MTUlk0Jx+B6TpibD2ATq1CnaTPhd6fQuwO3lvpyG77afwtrlIURl4SGwO5wFbGWYODyzAMIjCMnMByaYQU4ck3teFhM3gLe2kFIbRSmWgQOVww1QHzZSDFuQbbdSKyXNAHY1dMf9OIzvAeXjcB38SXMDRtNZ4Vj+9e7MrtuUWR4X9B9dmn5JfOxQncYU44s7Yys3eUXy/08iIJyN8djF3JSRXshcykTamanMWoS3WpKjFbjRjhEffSkEu4JUXpe40/h1d8tk98H2gpiVAs+gBZoxq0QmZBCstdVqPS/SJs41zw22FcHzXwPrsv7Yq/8kgyB1519XTf/eB2MS+5FLpc3OvJ9/3yr0THEjls7C5ItzkcVFWgYhzVPlZghZw6sAl71dQ/lHSDCVqrfT/Qk9r9PDVuX10HIiMjDZF3aWCc+WMC710rMb4hnQxMji5oRMxS/+xsMDpTtZ0ydF/RgyPCNAORKi88fQ1/xUk7nWPOx4O2nuMutByEBq2L6e0t/ggi67wDxLBjMFM4tsjo9zFbZA0Dk+2BDaKWAAq7/5uZ4kOY7lGEFlSODQqKFbylkR9j5dg40AWa2/F640I5IMPaGA+B/epvD0OAuYmVRrkdp6DotXj/0gU5Ms84NjlgsKlqG6KWt+0vEkw/U4itRFaWQeByutDSpqrX6Q4Dy03kli6Fs3IW4iiob9T/H+jHVh+JWJII+0sYI2zz0Gzpwljosvglkc0mcsK68c+kt9/egB5KSkZ6NI3CdAh6i03hgIdq6lPKylH6OQWNkBkU2dc5qUZhEalTUy1zp6lst1NWzP5e94JXZ+vUR29/8saWrVsrtwrSvAPMbsGCC6VrMfPJrqsFrlqtaujFUUdgXIalPu0GdmmTgxZ8g0NCOg0IjTtbvG4ez0v6vISwwJHtqWoFYdv/kWv2VoyG0cqYMK68wdUz36GHFcox8ylPg07SOz3l+mEL3CQ2FFRpyV+05NYid2vl0B58FgYqldYoMN/jmHEnbzSwlC47ODf+mmG0QoXye0mgKnRlMMSYb2vFTKDS42L41n7I4cvkzRFgqgxsEQs5OJrQervzGxKHPvr+sLBvAo0NuKarUUCzhsIWgVvrF+jehFi3OWNo6M7pUg2jClhUmnDcjmDOPUjHv0ExmcXq5Qr4i2RcBI=
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