vXQ0aV/5rZktux4uoPnkZQF6rA3UMNBS9oUEgbDmxGY10Gx8EmjeDtOAAjcYegx5DYRE+zLocir1cCSp2C66F16/4K13c1eI/vB7SjLQySh21UUR5ThqLfBoZqBy5Az4ClYrBiGbY0z4NtHR9+QVEDKSbaSsoSsoC20/ddPYvpNGq1iFLMYZTTx1lDG99rvqvpkYWID/6Gkujx9n6WZVS1fBTCUJrHj0g25ExLCfa/9wthXNS3h1U1C8b7mes49cIbBbN9A4L/zERa0cH3NebqkySA7RB30CbSiLGXaQ/XBhdMgyyAEIexOZ5p7Z4AB3L2WrnJLCdklPYRmXAiDbtNtbTzzTWTDEHpUs1LaplwrNGAFLIAnA8nB4JCI2d6GOJCQ7lUlZ+kNV1yzT0QvDpy6zJfKRl+meI2tlDLL4H5XH8bArVKj6rQE3OjGk35p4RhlpANtmlxKhzduYxRO4Nb5S2xO3llRHdpLPl4chr5BAdWexDfHsI0/jxc7WXb6sPQP4RnN5/RrCizKCqVormuNS820GvkTWhaYy6qWwGy3kXY1FdshNVbQe1yvzzcL+trpvXeYyO9Tv0ttS9hqLf1nn5gSfOcuckBNdDuPzXh7OI8D29VzohQruEhclvHrHWdWEe08O3+3zzAr5Eh/qtUB+tuCkn9zOMeC6gvea+Vytml4hgggq/CchC8gViOgDHVC/CEHXRRDMzLMWMk+hgd4aWLPZcj347m7T/nYK1nkfr6SSEENS9aeDZHPEPGaHqBxOQLpM3qfAEOnSK1Fnk6ymVEO4VhhsQ0IUx7hn1b4XP2Ei7JIbm1Dzmf5VyLEZcKUB5BFyK5xx3X14lW2V4D14vY17JtBcgJhKxyDOTttxx8jG9mgfZ5gzHHL5uEMXiOUfADZRoWiNEd35rn4fXCwzKe3pXwNTF3zZm5OQYC14/Eif7H/W0cewrJ66Abzxdl2M++l221D2SxwYJXDad40M0/ie/+4L6UEZ+GD9wfYQJwOUHPseTW2lcrX2pv7hc6eA4ZReoJGbfZcBQP6yGOTeUbiH2y317+8/Aj9DCzciuD5d3goacrLcFqFpdW0evv4Ea1LNm2v+pct+lwqyreZhFxe+bMWYT90W2oz6hl4MmvddeN6aJdd9aidcCZXSlHAqG6q+OZ0vGqF3legZi3Wr1CRYeJT9jMpu4aRLF6Q9DGGvMzRTed7KEI+/E5JeSRhP72gfS+Gg5WGzMWv8RWzhMO5g8JIy9To/OplINhYrRQgC6ZVNBbLQQol+k9oQK3gBUeXnl20iuKKb9IDrR0XlkvWFtxuYGf/kbCu8mjY4lw/vfMeh8lTkvMk95dKRz0O25CgjPf+M7li8mym1jdpa9zEr0BBBu8wAnAQ=
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