e/n3NsvtaJnUnOyqDwE00wgF4pfynvWXSoah6el6lqaZpy5ew+psYsI5Got3YPHLFKCP23IP+1b68MJqxOUCIVh7KkXH/vzY4uceAe905JkvGo/BfC/fSFYpPmrvtH2mfZcys9AjgEZcvlONWNmfVtLtKoT9Wkv05fUTCllljSBA+s9j28pKSgnRlevuLdXH23LXo+0uuFASsauxjrhvjfgrXyKnqQwu8YBXqXPVcbBdfx9LnCe6vWBynfkAGHhcMLF1KYkGY3jSzLibvsOtmmyN3ya+7rSNxbrKCqLWtli39UdfXk5oLCpsxDnnwfie3t9QeKNNCZO84svM5m0Zt9+GZXu/kls4fdvpmSYaqHIAOk50fBikPr/k2sXfnh9Pj/jQpSx9U0VYUfw+Jotd1fbN9SF/vPwZRYcxrcBDVUUhdHBc/YWPNM9CJXI/2pfA9fB2XOD4hbOUbGdC5xAOfkWpjcqgWtip1vTtKdC3a/YSrfuhYj3eCaTqelsjNMu6ZP/ua2uFy1zk63qKonW37P/+UNNCyxWnIohDphSW3+8ypsiqPvVnO8eXUC161aKyaWaGxg8YuQItXSI1tlAVniB+VbP6Xvs5Yefj8oyILp8r8rwUj2KC2rgGfQEluX/5ebEPTEQlliS1MKlvlA9nzd/HkhyNk6mwSqJz5ZbzbCG1UR12TmQsoq8SpHNGVx+cYcJ6jpUujmq7m+J2DzzPaKLwytV97pTJsKy7cvxDQFS1fe1y9T3yIzFssGhX+YAEp6MPGY+oerEcKvPitQlM8O//NT3TOUFlotKacMaxIiE0nwduhjUlYPFTdHhy6YXtEepnnM7RanLv0bjOvlhPHWFUANFoVZyugcFZxpnWU5M/6wRFOOok0kH4N28Prm2wJZ4XG2YnH+kOWFj2eGg7D8iyzXhSS4Tc5MkgM/Tui1K5WAoH8RcH856rH+8k70Dbp1CxUGwnlNosPPO6YVqIfyQNNV4K0fPWqsm7pM9d+8KirDYXXpLZWJQMr3oMEBueOlRJtU/SHjA/3xSkmsgeicDsafeH41Vd7V612y8fYtXytNLnyiQH0r4qBUYnIUN7D+6tM6ues7946tPdHMuLdtAfVXjLu15oMdglMyMo+ZL0jha9/Jvu2+vvKFxjMG8wVPwafFEXhCbmN2TniD4AybeG7qdVfN+wu+AlhbGGBZxicry7ZMNMA4zJCam0DYJMdkXNeCumklO7pZErtyHnYGKRv6nLPNsb3S2Y+ww7wKc3y7iGEIyCsFIp2yEKywRn+tSs5EVAcflAu0G+YiReCXAXaMuZvt3w85TeGhXqMW2vx30a0XZy0KC2nouvP7uzdFqqePirX8pZ/rNDzcoBNV0PU0pmJHIOeyRNElg=
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