fJUZ/+KyKlyQkoEn+cQR6X/xUfT4JTUW8VYN7hMIm3rcfMQK7Bcx4kiTg/wTRtCqTbHAi+pYjJ/OrRncrsmcclzNDcxj8RE8GSUBybq124M40H8F6y/79V2ya+eJMM65FyCTwqIuH1zygd+HR+EegQ86YOid+TjnF9ZkYGIl8wGban5EzvFHsqhKkDTiSdGYpXgA5ZpzW6WWHIQbqr4vaVidPficXWL1wDrc/JAHfEr73d/R34V5+tFDAndRseWeziGTZICCP2xrgQ+bmEMq0jnlpjpYvUwchV6BcQ7uLPA2URQ4c8tGWvtVL5H58aO6TpM64QEHYGC/J8nNP/lNK5pt5hG8oDhBwYZynizF7rseMkqKjBb7rphuNgAED7MyjPsFREO3LjTnUbiWRi+mbd+RoksRdLUleNmNOdZOSPYbplMNpVniDaC4Oqo0qW8EWVwtiUuwyW2HO6G4Ffwl8bOBlq84Wp0rvyeuo1Qz7YER3A+KLajzUTuA7UCbBHE8H1J56DngxEdaWz5iZI+3WfB9ySCWzUTaEmrjlqyEwNGwTikcwOK2f+2ITjS9u5jXzfMkCVfzShPZ1gQfVJ/PhXdAuxcywhnpJnSCKzwT9QbQp2FoxteZawbncUz1WnQZWtXI8gS/a2U8d/w/H+fS0mLj1VF+ZmdAZvxOeqBPq4TxaqVEGblib5b1SUBIvZun8tsYprP3+Kkv38A7INnfk8zZn8+UJJ6nxgruuGrucxQ0gtBZHYTqWRkXd6HDLZaMKjJHTQcOm0N7u6o8XeWjcieV73nbGnA8i2kVuM8LXW5ZOI8tze0hdTBIjCoL5hR5meMlA8wAGeQ3RXv+Ht0IUlrusG6GWnCOjG4obz+9X/+387BykfgoEJ9O2SpxTih5UjH4zvb4p3jF4ZyeTLnjh5br4tsfK4EV/Y7JlIdaXeoyeQ4Q6ogAjlkMnVT3vz4jS/6d5VMTCPGgxglSUhXQcJ5vi9IRREnIJeS5pvo6tXDGoD2m1d/fCDOj780KeigxwhzQTRBxWjKq7c7pazNWd0DgEQ8eCBBjHDb7PGGsp0k1JKw9HXiF9ogtfR11aHSV43hekXyaoj91c9tqSVTiF4+lbNPVHWKJ9I4/A8U69GGAKPp7wAAzDQ0DT7yrfI9qE2obH5MNt3qhM6aJs41fsYss1ppPeFjbkxn7ewzwjuaR7QND8oQmzTg07HLNYhKTPwZV1iytTRRoxTUBE5zCYO2NF91rtjaVeg1L296426oDYsZhu+nCbzXcwp6r9C0T5wgqILYOCDQdForWEwwK1oHev4rrRjTdVQ4fPQK+o0mZ9iAY+FWIX23ksJpDcaP4+PQOXyxK7ElxowpqmFpOZhwOU/tRtNOVYi3jNHA=
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