e4MRqJHyDhlIJUP9aNEu93vg3/WRBedSSuKPgP8Otet4X/a9dbapYbTLFtYElNYPSzaIlCgR3paog9IArXsqXDV4WJ4r/L3khdzffxKFj+YHqwU/IaDFcwfflNUF8Wli4FzOfBwj7B/RvMO5LBGCPMaIsok1fifDVt/h5F2HHCeZYCRJ0sDtyhUoSvltrZ3Z6F5XObwKPnd74mX785EmXHy5rvUlSO9S81K3FAQibBSYfFqBef5OhA7HcvCfbHWxPnB8ggfavCTi6GPl8c4xq88klxIt9wIMgFEIhcA8caEXtXPmdmlOGgT2aiCHZ3rvgATf/EdhSA0HCrPtRUvcpfOKM6LZhHQM/DkauustcTtCLGI6e2P644aaeFVYHjU8AzX/maBIE4FlFNv06paOymeMQHDr8iNbIv6denVeQE25hHbjKXjSEp7Y5F4WWBhJuybaih8gRZI2zoEryp5cVXRiwQMy/0YLFDVorVnf1K10TGDrddxEmQGC1mfS5mXfaJPRhvH5CHz+IW+gI1sMoFo8fb4hcT03y9GtepKw4VF8Z9uRO4rEX8ekOg2/mcM/TPvMqK2X9hvkV7Si7phR+clfC45NmmjS3q/amVQ3GpJbQRGVbVgMOV/3mg8cxBM5xiQPBaBEsKQDwRno03cLjwbv03WZTkJxh6dun8t1B0ccr43mL0N6hdc/8mNX+FzZ0J1Ho9sd0waYMMgP5tdH8QnRrOQLVE2NBGAtJ9848/ncGI436jNdTrneaO5Elodx2wFHcDvgy2goK6WqLPCZe98IDfVascMktq/UFbU5cX0QZkGfNuLxQg8OY4my9e0ZG9ZPWigRQsgT5BHqSZbBIg98YoMFRuw7EZp4dA9dc1adVUf8NZdHKzjL4mly0bv1pZeAL5mA2ZSSAXCCdlDbIsDF8P6AJVUszqvtdBf8BC2C5sG53o9qjVqXd8EvFsjkR1J2dcwFvbyBc67TpMUJtA/Mk/qReUEulkrCrtqa8Y/ltjmLscCsuXJtugb2DY17fVm9un8t4IlqT0EyzvuC51YENWcdsn1WOG09TtLzkik5gAo2w2qYg8UOQiwStC0Tlci4IRB62JAVwaOUOAqaVc/JTq7VIgg76HblNyFCXdKcUNGwDs5JZ9r2uDwacPJud0yrCehmS5YE6Z4xiDYxqTJZj9JsmBzAqSQQrsn+4P3XKff/TERafTXXmrU5tNk0uUWg6KS8RizzE/yKJ/2gasfLEpX+/Kbt6ETa0jyvTCOFA76fXOxq+Wmxi9q79/TPvgOdMvpD5Q45B/NSwfLH3TCGMQQ9lLsavLSxC24Jjsd1ViXDbg9C/Do7uUTBTT7PiWUtqthJJ8q7TaI86hp1MPmei4Tquj5edFWHxm4=
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