j7uN2Lq/ppiDX/uEhbh8K+0pCvF4h+FYLtrp64FdsW1EFQzO8rxlVE5kTlHRg9VSBkzSnZ+hBULcV9eLRhxk5ZNpDgM86Aj5+g3TI5/s5mmIdG3bi1GifWKDpT5bKGyXQXL8x7ZYvW7Ap+jB+W0aJbCMq6A2YETZl61iDW4cfxiASCpROVafSFYvCwoOW+led50nCiURdDf9acXwgffjjqtM5FQFLG7L+eroS+L78UZKVyAFT9hm2k9QWMzl8vasSnFgGbLH3h94Aae5D99H0jsYQupMVeSOBUKnPxoxYwc2YOLErl03PxBfeVvhY3dWXvNMlbibl1BBdPXuYVvSB1lwt13MV/BfXEI/Y1XMsapnXh7MStulqDyIVXIA/s21NncSdTQk1tU+1kTIdHIS1nFEQIIgGMaiRjSL3eK0N9BKjQTRtGSL04dygJKTmF6S6pbUHshLPLFhFWn4ZlqjCydX2fGBDssw8dmXZYSKkLdBaPVLk7T7HORhQaIb2/zyg0zCWRq65M3Gi1VuBWIG+J6ZeDQnixEz9FRiq/lFeTm8Txfy8dnUi2BW6cGzwAOh0wHR27ObxWvjSIIZueeg2Nl1nNZv9Spyhk6xCvsV7zJ7T3PK+RXZxzDFwtOn7Zndi3FQXi2xOGmgh/IVtBBlL763SbN24eKTm3CHhD0uv4aaK3Wo47b0Bs4m/saqe1s3hAVOZB3cz6a+2pAUP5Y+UfKjBQTCyoqxYiPsOgmUXaGljm9waxo1lffgsj/3mbWWR7UeukaFq8GWtGLXDvwK3RKVHLZsVxkhvynJguDP2Gx8YC3gd73uyC6WGkTXPyq1JUg5FA/+ZKt3C2l03DFn4O59It2Bgt+/q9LgjRHnq/ySIFRAs/HXWHOHDQhdS1Iki1QtNrqpcXvvfVOEgddbiaOLx/rPA00BAj6zSzg+ux7S3rjdkKA6lEY09nolxtfxjKXzb1vZ5m13S8Vq8DzArUJbCXUY7/KbF68a2ToCPh/XNeOaQuVImtHhge/3bz+Q/q0WoItTtogKnyPDt44fyoaZmVEWcxH/eTrl3zC5KVRpBOclTfEJ/F5bf2DxDyK2E2GvIn3tjquNtAlQRLPuUS+/rLJweHGIAVe2uieKtBr1pkfGeqxOZWZHTdWfhGJF/A6M71fMyEo7s2A6jWGlo6d0liyPyoYuFv3/PsjfjkF4KOl+bJzBn+VIH7/t+swkTgPNBDv49gKpXHVXY9NPYX7i0Wuv1wQhBKIfmAKwmItUErGoOxFn2nVjlDkzwgj3fD9VjBS1CI8JEn+AKgJIAYBZGmcPs294YXbaCKjPaBjyNslKaKiqtFsTZMhQxHIQjrVRlxfWc3PIYsQQ/9TAFINYSRA/YHRHgFZVa30=
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