9yWs0DzleVfKpjG3O07X3AYad73Uii80sIWXuA7ASOtQom2IOTu0l0Yip8lSejY64ZbFGu+Gb7Fyo+RvXPl3TpU5XquUG8K9zBuOrWXIyttHYKjpT/ciu5dSF/ADmJiD4wdTLtqgx5zcYQ0f2ONIq7SOv18C8ma0DrbG1yyUZ6H2h+2Khp6+9AvVSMF7iS6FuzXxPWO6zTniLPuuuHj9geKSbV+KB3oLAkHL2+yjdB5DwIbCx5+/yqb4QtRG+qiCRknGWn2FUmB+WLPcReQPYAuOQRBgdHrD+kVyvNSwzjLFHiKYCu/GPQfTWWt0Iyp5diz/eXkHqJ1fz8g7psiwiv3WA9PyyN7LszywKVdG1DPwt6wTl6dTr2H2sz1O/lmN08+Ja5FULMUamfc+mp6In+ITFolvOVpsf52ImZZO9CSW4FumYgfZsca2YsHdsP3unM8c2WE0BfHN6hk0RQikJYZ4Y8fAtgptHv5nCAeqUZrLCzWddqh0xB4rXQAaGimVQhL9kKiaqTUSZV1XrhfoUUUTlPs6qRa8d4isALWSXRUfZo8SSwfcPdBuzfsU3M9H8zk4c2vzDSUjI3aC06UDu0ADB7eQXrovvQa0AmfYzoBWt6dZoTOiA1Hna3TNV5JvS5Qv9q2G8qBtOcf7QjwqE6+cOpJQuckxLxF3coqkT7DXLok4taR9t8jgVm7YXh0o1272rS3NgTJRBcXqLQB7+Xokhvd7t95dh+mIW6c8aPwDii7j6PF4LSSPauOadM1sfp4F7X3UYxZIvX/urD+BNRkLW3evlzk7UkgVZE0XqtMFQkf5M1pdA7AztfcKRepKV5DRlcN8Okjv98uY4NExgCH9KqKbh3CDLg9XUm8a1G8MqRgU5F+nNuhiKL7extCSjEF2Tmk1m9Zb2MFuqx2/qMSXSubLOGgTGN96MLLDL3hrheLqUDqie7Q4EknGIVucY88cpuq2RCfh48kOeF7NPzZB0jYiOFZLRIkGwFpAzDWCj+9JGNv+YAiT7wWdcdTTH/XEtU6U7C8bCiL8hmJaq1GS6TIV2FwFwxgr00wL4rUJU/gMsnRk3xS6LjGauZWAPT4rTJQTCMtTuJJnMTJMV//w0ijMMsmMqD4axxY26hkCg2WUAfOrkiGTLNNEStXBZ137/MeSkEoU954t7uLirbA9bQtPuO3cECKaiXv22CUS4L0PQrpYd14Aw6SxJxZ3PVqv0MdaoDMn/tjXXjN1rRCA/Z4sdEcf90uTLacoNzbgwz3dwsueyEFfEbiTBYyHBhjx9amVOT+ORWM1mMSRyTKpoZa8MFKp5yr7unIiomh7oymEVveAqdiuceZi/wNLGYf9wxhirNrSVppX+rkZC0XQoKjXYLB0ux7jpjU=
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