8bVD+LVDV182p7/2/joa5n92eFx8JRsJJ7JZzlCqjr93ZSjP4TWe5Sy6SoW2Vt9g3NDzc/gocQr5zehvgr9t7FncJD9BtHjhHZWzWuexCpdQxl/v90tlVRfvIhygp7rIFdCojk6ZG0lt45R4W4YoW8ukm30duFLNrnX/ob9O6oO01eqARTTj7rc+BvHweOjX7+J8CnUcdpvQIt4kSULyorOJOicjwQ1PpvihNbo1uZTimu9mGY8oSB0xk2eF8INgvk370Xe3oXL6Vglo5u0DG7hrJM+79DM9YLLYuPplRydZNE8r1OFIHRD8xbt74J3BhUn09XvFkF9ZjUReMpMFipCWhS2571Va2qW0uuxyLi9C3HrkLIwHBotUK5sBNaU7Wv2I+Po57uBugf1/XAFVzB2ayNFJOUUNJ3YfICfivTAYoenoUSl2nokfZZTtF7Z9WUF4ia5eXKO3/GE7O0hNoPchKTMNNu43OxWv9E1jZHVag3CnWvGvUtsYLfpPDI9EchJgxDMRBwm0iYaYdFy1i09yHws04GF1lG95WmdLc4XQOSIaP5C3RFhBx8Xjc5ey22rk5UDI1sI1es8XEPRXbAoIcVI3wj1noNU9sPLZBDU1wXFHwc0hUZKzxan5nbO5w/CKXgn5bbaoTlppU8maq6EXTW3s7ID0CC00IbURcU7nVOwebN9W9qP3ohkK3HEA6+Nd+McF1hTfZodJ4//n3liplzdtS5+mgh6YI90q/fn25GO5rq/BvwAfBKVCpw9p6+g277iywb2Ded5/OKCtk9NxqowzmAA5DAnVmIelnc5P1yu6ADqwwmb1InvQLgyg0HizGtYpO1TZxsVqts/qeOmfLk7fyTsFb/qAbq170NAfAJwJr7L12XrncQ44UEBcayo79wViQVzzz6Nv6F0cIzAFdh5TAm2tREnYrVS5IAHMjHs4exetwZblZMgbjvv3zezKcxN9mkNEUHYW0Sh4pjHkWUltyV28WW9pQR7e6c8rCeHaTxr3JIFFb65g8jaummdiS2ugHy6Mu/r0fgAnjHKcFFF81E9iRSQ81mcmZ6QeXpGpTyGVzicuZ9JHJrTendJGig0KKQwybxWqQu3XpDhq1JqdfpEABAhmdjT5FpLonbllK7+9aSWGT7YsOo0DRj1zqOKaI+U4sstV90YOlUMUOi9SDHoH2O+97ecYSt7Ku3B8BElCnw6Y1dlienRxhaFgtksnOIUS+/cmECruPXVtR2GkaLfzT5StM52Ak4t7g8y8/gj9YhoSfgo5mjrvgMLf+QfzvLgQL4c3wEWz9lZNp/8YEZ0LwJvv7LT03I+Z5Dite+2VgydOFmCuHE323vz//lPEm6MlBxqrAum+UyrurlFWii1roSPZCF4=
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