qD6jE+q0EgbioZqYzoGl6VdVBFaHNXvOhVguc/jZzM8snompmc3GRZPxOCP0flgMRKjHoq/Ij7bM0TAxS0bg4t9RsVZQiKsgXxS4/zK1kpWu6rUPVCYzXoSOdHMJmD6sEFijgYrb5RHh3j4La/72le5G0CkB7ygpSl8sC2ScbuESywLtBp4O4EVpvFSWmbqsg+IMYAMJpMaX/QCuChCaviR0KYm+LvTWrTwr56P+gDo0ThFOC2dCwtiC9upxCZQy31TQ5BZW5JECHPlunfKubniLDapHZbAYZ/CfYZ07j07qbK8NMCUYA67g7VtDFVg78iHtoUi1qmPA064HaAageN+jxQdWdTJFAhpPF+/7960U50aLPjtDxSjYqVXNmB6PXaKMkzkB78wTa78isb1oMB8BoFmxcJsxpQWhDwZWRbdcHJHor5EpDBE9JPisYJI3Hq1Ibo7G/wlHFva5k6XktFIRTpd2BIC093i0267pbPxhzV4Us5AaESuRS45oCJrE6KRUqcWXU2bxgG2LUUU8lXOe0iS+ToMP0BCTgYXFN1G2mWku6a0Q9vOPAH29WDN6ylust8fWAN3M7KB2CsgtZ930gcuKzhZ9XxtX+fKPoOLiUlVrqn2KM5YUPezB9eZZXJoERz5/3cseInQznythlTU01+2KTFwTblDmA6vUHKLM+J8AFTs+JMjVqLq/ZwfveLFSGTIhjbiuYIIVtcGdaIzMPj8sIuVzlgTsQQOrteMvMwmCwWF1Zv/vyYQnx05rYW0+Ktm5pHmggVzZDItLyC3zmYideL5BGfodHqRqUNnxdHgebp7+hJp4Xn8zqRRIF7+3QIGkOetXnP8RkXgtAaVHRun0lS9pv05BU1ydZ/sSG2Wt8qRtJYqiPmpqbvHDwIZb9+ooT28+O9MSVk0P6KIYwrENMv6GgVcwq0vPemZJ/QkXVS5dZpsIm1WpPk7RxuvMlWIJxM9skrKYbqYgTe8lPYoeWN7J//uDmVEee1CT/uu7kxLqxGxIugh7G/L2S43jOgcukwjMK4swuwz5e+EuzByexl8G21wm7YVlAUdnYwOF1hTL6NpdvJAmAOGSzrt7qa/TG9dSE+09MwKnfK+q+CLh9SktCkWuePSpHenNlmN7EOd1+ZKdUMxDyNu4ewwoHxICbADB7VVkLINoDFei6DBN7JzAcAPncA0WCSEgLZQIcP33mKJ3Yt1EqPWjiBJSquHY1yS3SKBzIw6Blvbef5GsbNjn6YZDXItnIo/DZkWK4E+b/fq/We2StySeimJ8qY9zfMJ8t+1T/EM3j7HXTrlfQ9/oBkZ/OkpCODdHOYMx8Wez6J4r0wY7D0rGsQdEKWR8UC7d5OPmMwKdjieFhv7vowLu8IVRb5w=
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