EOXW26WZyhUNL0n6jEt6XJZhHaSFi1c/rhZ/ZJuZAaEut7LEMvzPiOhxg8bvdDIzYDImK8cViZjo94fe1EARgfu6PNz9odzZhMNuHq//wqVVmlT7mKcpaPrz9CdXbyLKDRrodEHSezCEqi281znay/NsnBumHRsk17i1ecpjEPPxKcHOi9PxP4IfO4oJG/zOi882TCvBE3BgCRrbeNRJ9oajsbpKAKuYLtBbHHRM6lLam1D38jap0RKzEVIOuHIEjQZ13UJNXU1F7gu6UrqRwPrTgd1muf01a2R+22kxolJnzfD48mkOwZiLZOugon0J2jgpCSty0ucdhX+oc+H2m+uA5BCgQeJlvUj4eDgOG1tphGAJj01RN5s0Gsl/+a3jpWqU/VIkAvy+qEZYYwT/0z65Q/G6HYOpzci2kDZPB5qkGTTDTtO/sHAH6m9t/l4e00iCcdI+l5/uBjfEQKgby521v5GeDyLFKz6BwO1h3h2tSFDtKAU2z9uH2q5IAKhhlqlByDvLxuJ3T1g4kIPYQ8Q7IsRn1EjE8oA89IDqcwN2Ta2mfbypzWYUvu5JyjZLay7LdIDX+lJZofq8pmja6/OrRxuIkfJ1dwhBH/5IR/23uBJe+K50Dgxh6HQy7e7if9gENenBg/OKNAXbNbEpmYglwbwYESEFJwQ05Sn5VqZA9LznzkoFpLAiRzYCMZJqYYkjgxcXS/3vsJ1++dq/stzf6EiwzMWFoBYkSs04uzlhf16hynWfZCblyZ1JSJ3gjekCJ7Qr/070/XtwGFHScMZ52BlDiR0A2/HO1IK7lfPK5+fHBW/UH4QFwxyEu0cK5nfvEmdDJos3mc7Q69d69GQvGj2yDeltfk/+S4ItkqBAEAAn8+yHfehSnunfruVnbX+g8GA2CGZz5WAVbhQTkukWhVKoWhIvguCZhcf0/lCe+StcYjq1P6Y8VWGZMU2oumTzaeQigpjxz7haleWd8iIFIEuP4YutIqcZPLhwPdQsKMhiFIwcj7R5dfUnBk1tRiLLeExEie0FfrAf/ydBQ25oLvIzqkVz5WJ9n2DYyrT222cVWf1zSY6Ht88IFcTsqJKYlKD4fhxMiGA8xGrIlFMnd73V7EVg8dugUsJQlZIfYcz2ZUqw1jcrVJSuilUZDCHcAbjhMGS0eOPnkfoYbxxhbggkOczZw4XatS47/m6AV/wEzWBI+FT5JP/GMgpjoQl00UJrJJXwDQWC4fDjbzmow/oFvK4XY5LdbIPQsztaujqjfPw+LAcuelLhtb/AH/6mnX6vtI92B6Cfoak+a2OwkyVMwf2zV+2ZGAR6jPS9gcWK/FCy+YzrqgBIA4taq9sHh7ousFVXopZ6vg1vfWLzbfZtf9wt1rrfzEo=
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