PJ4Kt4B/ATiDzxnbAdlHkaI4QYjurcnpe623t3x/ciQlfTIty9AN8ZfeTeUSRJQYldAUxfhNS5nuwaOe0ygOSP/SLzLxUxwugxD48Hj1UwyMKYFafvrvsy9+SZEFOESyN3IVs+nt7/wcI9xjgqRHvT5ZOwzp6vzTF6/4BKHk9hNzox3baYNePjqGvrZkYCzlKJkeJMGbHqr9sRBOE13jTtwhlE02VJfDK37QOfIWKnFNMOTvqSzEFY5CD0cPBmOnB+R8bWracYQrOdI0y/5sfWfQUrX4RTsh3pUCbLV5c5cyJX57ttptynqvlKF9Aw9eF6QEd/9DYy9wMyuSnlW6x4c1bnVXpwmw/Ep5mN8zyZdehpmpRRsXj6W4gzx+s1m9AVCCT4VDNUEYC+3gXC+07M2mchTIkErJx152dmAYo4RqrK2qF+Q9EwhL2IKGJhGcmyeFRBQyGHZ+rnWejra+RM082Ys5mcwDW4RxeuHVdvuGiyVEX6JRZ4dI6KW2BgP26VIZ3SyISStJBoafNM44Lgz8II2uVbNUSpGkR1UpDv/s5j3+hYZJZ4NW0nn5A3W3+3tZ+Tt7aVskN+dshJhZRR6fgTETJKASYTk2jR2lOmSHLN9niiqA452cshfOiNMTO04BnjvI5Z8FE3AKYKMQgjoDADxaRPI/IyBIIp4URozSbhNuXIMqw6zs5NmzEYHd0UlK5OTP3L2ug8dz2zhngKWxROIZhfBLoxIzEe5GqTZDGmq5lL5FS2LbRZgoLEvjgPeotT/B9zS7MsSMgIN40QfGDFHJgazLMlPUEOWOFvX4Xn4ghIK0AaMO/Jtjg1vfMzXMYuJ1J55cCXlxSU1+uSUoVCPnW5u9zpAZ1Xga6l35l4ofntsCXB5IjYcmQ43F961kkcC96rPeum26BAjCKVZYOtSvqS6qMlV+vnlu8E2FKaM7zGGDkH7mcy491PYWpnkUWiuGmsE7BJbFiObiNxvvPocPuagqxSRL/n1H7UL5y2CBpzpQOT5LVXOOxrtqf663vn9fOJJvaLrtm4TT9Iq4+hGeMwuS6HdhloJHy7JvHjB/esgmV+/5G9CMSUn6Ovvlx+CKwJuPlEkWwnPiYeV23b3ekqxAEOgXtbDiy0CeI5z63x4AA6SCslumHjHorBKNvJTRlsNCjaNYVUyA322NIjeMvXI/XH1j9xgL9GQLt1RRdnDarR8PcF8tP8c2rRRajdgXpz/mM18QdjfSHzQOHNJWvLqtl2DMzN4mpG1ZNFVkG097gCJ6/Kh0cdRaEWRj6MMZZHPk9Vt0Kh97zBXLBjRUTdVSybFwXM7G+Fi6oGkxKyi1LEnq8MidpxYM/Wl5+yeuzQKjhSgsoxZz05Qaw/RAv1LK8ffU18g=
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