llv1VXlWi7ga2uj98ED7AvR3zr7Nq3Ukcor/p4USEpr/vitBaoWgb60xgvgrROiZbAqKTgTC0rYcGzwMidHezHeM8BsKiVsaYBf8vyCXVE5bMApcQyL1aUvrclf3ktmzXSFkMhsGp1ac2E2SACZgu9b3ZQA8yuoFQ4i8vBCo0/9QxrIgDyh/Mn6v2DCsBEjkIIixqkJlhxhQXFTnHWGr58yjIDUAvUrEbkRk37sjmtck+/kjfMjPavkYnFCCSahZjWMfa8uuP3hsru6X2Sk/akrAB9yHy/GTubJzn336Qid+I3mD/XuF7J0qkmT1xCnPHQxdrK0i3GeEIKKA7hPq68HQKyzIFQRTKeLjNkiY+ZeXE4BH5Ud3A3524UxDSmnuuA5Mm13HlPuyQfyyGuj//sqGBmTHK9/B+vLo7clfYzH0E5WchOW3MOUwiLh+yfH2xfn9IulFqhx4zKY0n2I6FqX42+h14fYBKRm0b1/GMMAvYmOahgB860mCd+wZCQI6Db/cwVTaJVhFXTlPVSRgs1Luu1caeadkMYHh8VSNPBvrKt12GScE3/ZkrlUa2zLYHwPSpGMxQsB0nVode6MdOZg0WQhLmMbfunkqUD8Tnb/OY2O/O4lZH/nPUz1x1ZIeG+barvYXPoCQb7dnOkv2xJVJpu7rhBna9wMCIhd2cqouB8tI94ko7Z068p2/ZHGA+H2RuX4a8O0/LxtJLB00v3PEenR8Vwqed3U7WcCpAAQcKO+7Po7MRbkppj22EPhhYTpsqHZZJQW3D0w+u5fBrZfqtb1MhHtNhr7kYOI0nfCApSkj81VabeczXayzrvcw51EAzrhtQCAzQK9eXlvLw97/lpp41E3IqwIRW2s/yj75aiEqGFX9TvxBwFUm/rRHwAMaxmZUyIVVTNnjakXybq/BuIQmRW8bGNsGvedM6w1NR8tAmhouoRPn9oig+F5Hyt41IBmTejpeZ/Yec3rHx7AdlrDEBZynQNzLSfafTBhyy9svnFjhhe41T6BazD+CLLzQr4FdmaiZFrYDQou7XP6/dR8hSVKr2hoPmNm869dk84xK+ezOZKuCMvHrib7h6h+NSxgRUqCgxxBLRV+7ojNcjdCEOqIQGiZg3lkIwP/CwGlgFvo+J08mkckQOd/uDjaIIxC7Ghs7jyNhVTwuYzkf06fapZ4OjkWdNLu7/sQmxjFwBMXprkqxV4GNekISdR9Af7SWH/4L0qfiVQUxhWmYNERA9F9lMRZ5RsRuVh5WH7vF7NbEHkdLd5fWeZ/jSoAMBxD3svXLAvdW/u7w+pyzEL1JG2jNLLKouc0O/dKbJyGP/C3Mk5nRwLcfMtKnmdxLLaFVIH6OMIMv+Zzq27fpMnpGoWH5qk/iDSA=
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