3wGMkaRGiuVMVHyi61iASNRd3ZwKfcAc0tzrD0sGyOMarWGltbHCensfBwQhY3lTBEYYwg6sjxHR7kiZWlpyLTuxd3Bm5NmtxIuWAOmkVKyVcaYWk/8WiJr0VNC5Fi3zobiM+7gp9/P6cDIks8wR8sW4x8jq5nEgjqScEGzkJHRCvJhb/pyJ8xtjf8D/k7EqY9SGVJuysN/U/yB3ZTy0R+v2THZ1ExPbJYOWODrIfirkLU02DJJRPA0iN1hsXS+s7K5xn6uKBSlVsIuK6xk24ZPIPxpQG75OybPVAfAISKE2dl+wrW3V3KllvnLR53e0M+wk/r2Fz6yW6B2UHiqqLEgSq/kc2nJUCwZQFJcszIh+m0NjzoewNHBMx4c0oQO0NcsAGPT3ept3y5z6X3/4KQzG1PYgMDpkmVsTXEkJqlxMW1ykEXAaZvZi/HFHAtNlCX6qYTe6bAGrr/WJkphlbe3MhocU4a3wxa+A3YssgX/ocSerlLsJSTvCajdT1orLhG+0R3BNkQxE73r0BiadMztZppSDnQmb37LbmhdhRJUdFGOp3kepDKfVgeQFKRuQA3Bbmcwvq+ISVnBE0pK123su7srIYVeytaQYrcDqaThXDAWOXobx20A/7ZbtC0l0aUy7oqEVKjsV4s8+/zQRZrWMdLb99bLnkJuWkdX85GGr/hPlqYekDVmC2uZ2w9DY6o9fLfFbbbEUCOlTP+wd66us5EsnqzKx4IhZf6etW7VvgdhYpbwpFU18ouxIJXtuduHtg0gGL1SPqs5qEZedoeZ1bPWy2waDNCh64+pDBAQB9lnYtQM7eSNc/Jvmp3OPLtvsQOmMFv5sHO9IRG44JYUsn1AbyZKjlBLyNQ5+pwNRd99GJimAQLbaxZMYpqzIGqdulqFAOI0/BrBb4cmqwK31hDeqSwtdrSsCsZnkNUmiG3eVWhhQJa//nM/TeviKwsKdOG2cZ9sFJYKzNtznCMhDOIaXSM5KindZNGjXHYUIA8WllDzXGktj2fgTAxnMkG0Sa9zfrxhjMD1RM6D+FgoeN+C7hKiE6C0liKc2jFtS+coyOsXUq/B2AvXXYJjE1yGY1c7YPKJSjFjv3j3wQjMR5Ntq9XxnxPmerzGofgE4d+Cmrcq1YAazbufTYG8VZWrzO3uiVWv2O4EOU4nOl8l9uSUAIxgL2cMhPbiKIcDRJ1xlICoAFBnezsRnbUdlrpXFFf+lqGDJTPISYt3A60lwjS9Yie0fcX/VibaUwBBDo7ZDZI5UQQPz9uqiMMdJFhX5RZo6tnC/8tCObyKCPtptJsO8YT48xlPwAsTrhcX9OGjBGGjdGYfutR1dlqGvRUribJG13bhI6ugORStiG/zUTnMyRoMqHF1Y07M=
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