NmkBjyZ2IiDKrvtz/zb1iZtcojsGxcG9WqTa64jpewvCsaUiroBeAEDEpvpk7vd9uNQNRAwOAKb1KNIrZYBNaq7z4ivrDYlpGbbHrh5wMBHTYF704W/U5s5C2ahsHrgQm3T7PsWvq7xK2CfO+1Egx+ybihi4XoK3y7Ea/cDcVvUw9I4t1iWUxYCdE2uX5HdyQ4nERCNNio7XrZRVKEs1hkeMfYttHqNDT956B08JZQZyL/Ra/ITo3zqMLtlJph+my46ITQGaRxcBdc+K2qjQcbjoZFIlunCMpwWATqRJxZ95SYC6no1T35a13AXTW1LXdDDQhUn5VsSGis2Jt/4n+N6krsCs9eje+4s0TDr5gQQjOURwogi32lSCSOyBf4C3gMgX+OnM+8s1Il5SwaYtMkrzlEzBsVJ8S+Ns/Q+5N5b8H3V9O3egTQgixxSxG1YYSwVFP7bHPNjCA6xjVFuFbiBLVo1HEoZsaUsmD9XiEy+j5VI28q/FgQtj8yTFwhZ5VwnS3yl92tm9CJGHb27psipkn3P5YbffN4u7XZZG3JH80RRilfybWtXsR4Hi72xdIl5c83r65SY1hD6oipdGPHTPDlDR3jsFG823nMcgoK1c2K5A8CF9W42N+L0Wg7ZJyaTHFhaTHbnIsfhaEfuPlG4Y8yteo0c5XOmz/Rq8H8ujbn4emP+CTB3yL5k7RI74olU5gEjBNH/tjyLyddqNtdeWiipgx0z6fCcdxtNgtCWTvqYRFTX+7ApJnYAGxp0/feGNZpD+SEa5gT24CjRfIDdMzoqMpGy2kkdLrlCqyYmugGgX1EwLILT7vCf6rXZDGeSe+0+zgBfS/2lCaYK2gbrOcvvsPrWqbPi8l9Id5UDVzdZzwYoywzQD0qK/IiQp7oYwZ/Pm7FS+dSnHUUak1QSFE9LqMpFN4I0x97bGJn27GsV2jIHV6i95ukRLGOsFCOb5o4WwiF4YS+sJFnfp43LZEgbVR9sQALkDjrd6PpTIkqAGrH9FzWqvetBYkX0gCCbe5szIo74ORCk4mznJcJOpcIvBGjPHnVX/e2h0WAFA7ViEaceBBaQyqdeLIgaaJkwk89zlyzgZInzexawwVrHqU2DJ/+2I4Tk6dAxDKEUhQHf0zPhyf113ZZZTFqVk61Sj5JaNLQ84PHYYCg+ZeyKfJnZNTP9JGtxROojfUhjdJf4gy9KJF1qW+ujigOHpqa78vPg8KRcoqqdaGzvqkctNkhr7tsxBDYuWkOTnjRl6eAYCnQm/gq5+/EoyjtP/9IR0LgmDPOr1kKajx+eHUz8q01HSvHpkopSXi+7cr+hjRJ8wzcw0F8MdgZmErhMwLGhqCHwTwu0KVCAglKmfu60uvi+j97gFm0JVn68=
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