DPhkSPH/kd+mopiUkVPCMbFGcGVBn/B4bpNFBL7fENG+nBT27XcBfvT4bMPgTGcYna30Uf8PygMcGHBFjJGyU9ck06Mk5g07I1Qk05B7BYu8jM8XJPcW9zyHDUKYz00UornN3jdmrvDfMgtE4UT4HVyTsdYAsxnv36LvrrTFUIktnnSTXTbCI3e0ooKtsgIcfWUyJ/KGGmUaJm+8QxsdYtVpEJCEgRICA1vTdWjC7kIZO/nFEurjfedZ2tZ9FcDHCclvCJdbvSTF8EmDN0SnVHHBAtimpzYbHzUGXsVtkBWqpTqcWBOjsPGys1TlXERD53qdUWjgNnBxc6P5JKVT4gs3hl3RzakABEDDVY25uF9mS8XwDkz7RpiRjmcxN3jjNwT2XV9wzSOlvwzGskPUUpiwzJva+bw8h3rcm7Ih/VNyx0eOAcag6lAS0lP/BYaHFfZXpm3vSCRqvMh7HH+eFtqnSF8+nbIDDm/3VoV9sBVBczxZStUvS4ZrLQMWEnFWj6pNXQKWjCDtfiQszs83MAvECPZD/7QAlTz5MRkMs0OAjAOOk+e87e6RxAK/7d5EZLjq82KmVumxub6wMYHyhVqoAeTKL5SjcbQHFL4m9gb20OGexEndTf+W5sX2ZLWTcnT5OxbwgUzgYMjE6PPGdSnOa5RANevQ0q3DlR8o/iXBGb2uts1SKr8O5Qd26jF3o630F3RlZpnMteni82JuuIHoh0wxit/b0Ar3lRs/J3Wa4MytmNGpYtO9E/OwkF7XP0ZJS7UQuiKFvTjGu2JjLgMb0cJtIrMZdneI8QKusLglbf+gIH1+Rj/zvqv6OyHBsJbWBgHDfYAXjBD5+gTumNlFi9svBJATtF9PwuXSk3RqqzwVN7c21dzf1ecmIXi8gWyrcIedfL/uH0uJYW0Pt25r1W6bvthcDr7GQfYTTKQDx7AKNXWefCmfiIv9EzU/H9N8zwyefUxiglUbfoSMDCZRDwM0RdSVqmPRj7loU8QsgU4XzrQuCtyLQKZaN3Z7dAsP98ItqvW7TK1NnLYMEBLkXwDX9dEaZ9U26z3safsItUW3K51XugHoR7r+W/Ore3eP02pvXdFabD9XuAmPA+ZPOg3kkfhI9ARvr+n0qZsPIvOB8op1uOMG+gwggAAZH7+vsaGpfZodsuEjr2ygYKvRgNB9ah8Oo2xcOYJyfkV6xTgOcWkMHvpnZ3bApoW7b5d15S6cYCO3szeriaxU5eFg84iUzwmrJWULwNH2xS0IbBLwHhylI8BsGxnkTWDir42i0pvasH4LfCR/76uvFYY1+RMy+JucpFJE3KoUc2L+JIX3atu7cys9vnxhNlup1JTKa+MWY9AnexzA1+A4tcQ2m3b1YLGKf0vXE/M=
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