RxaN2iNVwO6iGu6ERxu4cpzx4Td4hetYem0jlYkwazY2eAbe73uY/qAWr01SzipZ0v4fxC2KFYSIOQ/7lFjRGImG1sBfPPmcntdTJfxTL4jTd2Tw0gQBtbx5REjeSNtYGDa6maarLsGN9aFBzow5vb103tI3RY8OU+a6cLLRoGYtKw18HJQbX/QTvZC91hnw47e0hbqKQQt/q5BLnyOlaPpcy9TkIODsXMDneT8L7cLx6R6iCMGNm5MdsGXE5mRvirCNsy3TcJlbCt/Q5EVFutJVSAD5glrz6fJID/yZYahC4EaOpHYhj1q+Zy5OS68AymtM0i+/1xacgLk4JPVrV+Ta0JEwMO4DDHNQSSlruxwJDRvgmYyo0VRd0N16eUGk/1CXfSBkJBFRkF8F2CFURWW05a+3Q3MLaUSBWXhGg39StuR3jkUXYpEh7JTVCiKnkzaa0lN5p9RYQ44Az+hyesTiofXe0rd/c3XsSBxhsoC2Rm9n7NLs+9SCjeUBJNiVHzbrk1QIAxfeTozWyobvYRQtDDtkGdfyw8XBFil/TI+rOyjmoyTdNRFqYQOmSzpb27mIw7/wxQZhtFoMnz8GrWeOEbrig5l6YFaR6jioPUbfLt44LiBYsz318ngEXq0RbYMeRUmc8xZYQTuhTPpVIsNYylIJsM//DyA7yGgitDgqmouFRMn3pZBapnoMN4EztgC3kroHAf/VPFVxR0uXRo23/XFLQkoztUeoxWAfozif0FxSVhOfEHxnwuUjuVxLDGSBiNvNh/V4KAf1QYPsK6pCVX5fu2FEcu5WSQ5va6ADjORZVSxR8mGIqrOsxWYc0bfCmWGp5g9WaSCWV/q+4+mdxAyf2+EuNcEhhpxfPEFmz/mIwE56uwe9uZguR0G1lNxw1Y5lMK0EXEh3X9waohHX+Svi+ydNWwVMs04uwFaGDkYpQSXPJIKDilpSUr2BSTfkexo2u4zzu9ubOjMrbqrWTDNHA2F3jOoyU15mdFH37YzXst2+2b2ghByxS36BvmqIt3FxMcmbdsTDHrLa2JiHRPenTFiLa6DrbbhcDTPYkAE124VB1WZos07od6nKJH5zDwLZ4Sv26BXOr7mJNwKpM6ECvNthtm00mcJlYeEuvI58Hnoon9JU6n6sjuBEOr8NL6dsoiTAqm3uaZTdy4wspICe9vMuhMR6Kyk13iOcYs0LV2cSmVXhgVWc/EbZApdnHZ7TqZzA4N1ITf/ATOF8EVyu9fu4pqkIAsCPwoYWfzq1G7MfZYXQyfzkBO5NdHm9hc23CN2M4JxExirC++TBy19HIE28YMc59dOOtqW9gEiLTFcqHIykftI0+bUG4fzFISQU4emS8UeQA0AWAkS2LsE3kF1Z5ois5lE=
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