rGBl8pqS8AEvkfBPy3Zka1btXP8xEkanj20lrpPwM0S+1GM1GEG8eZtL/ChflvQnKPWPPIikguOUM/COWJXDZHrg91iM6x9CHIu2lqYwH3nTKZ6yd73BuhZB0Qqi6CGLhh04conYQS9G8kjLauX/TOutyjunVOgRr+kpQUTu0AScfq88p228X7VOVErklJ2AqgZ6+gnbzBr8ttNimbfu99u8zMxsPlZVCfMmffEyXR8oEOl6/GzkwwI78/UEm1IlKu1Pnw21czvcCkBEiS3LbznubrmCG6VnbHtpQjxZp/F/dY8F263NIb/mbqbkhtnh8/WYYpKFrMiOiZVXgNFd7w+ZCgj2VErMWt/udx7F9pdIrF8Xe4OOr9sWCLynnF3JRGzNLJZh2Lx5JQcIs1CHlSs3XvWEjprkJ+doNPHZPBvhyecNvtqGxcXIClhZXqpBWS1u6UtOt338QnuZQRhBkQL90f9VlNeXp/GVYaeN9K2YuhQbt6hEaCAFtfHwF/IqQMaitCn/ByXEKM75dg5e19rVVKo9tjIOQqxfpCKGO9NYRK8fOT5r++QIx/UGLFTZtDzzGpDgvj1vj5ZJpxc8oOmsAq2eh1I417xOmk6fhVaSowutLsuh9FPkDxGp9ERaChH/8Ds77DmUF6K/+rBXojmL2ps9P0e68nat+ILH/lxtZzPefEsg6oQ7vfBoP9mBQpXQ3xOXNro64sGx+XtwgnLih8lWdyO+S3O8j4OzL9u+GpFoX/T+anDBNt4cpkv0zwgqR7U4VatN/u4CmDekLpZLNT1Y3cIkNDCgwAqQZ+/mEJErvzPrg3/2u5gCAQBI3OwpvzZHoFY+28AlJLvVZPw4BpMjaK4aVv0RIkb1hfKMO7rwZeqvdmyL6IV59exLCrc7vnfW18wn2ZJB/o+tpLn8WNgil8VSatsbYi8SJbe5W98+3PBYtubY9AUmG67pGndpnJblhxvFuIw/OQ8Lfu01CX7284aErrwGhn9cOV8niDxCKMug1OUbk1J1c6/AERs2T1ozUxMW+P9HSpLZjra8tDAeDC30uNmSanXEtwD97fm93k0xdHxynhToFPXhx2PCEr/ZFLRGN6JL3B7hj26LOU0NQ393FkuwcGiBjbnfSz1F0Rx+0hlDahvZYi7ndl4eiQu6xDuTvIA2kZZOBDXDdjzph9VDuTWyYT/vaJhSiBGMwHO1akendyUPAPb/MW5e9ji+KgOFP2wWdfogvmuqW1Cg4tlO7RGnvJ+sqnnbyxvEQVr4pSmdu/lKFbwSDhQ5+fwkI+anBe1p/TZc92XEJ66V2UlMgFAl/Ajg742FXYe5CTVbIMBuWTAb+od9PUmIlcUPE7ru5fkvE6TyUMX8dEN9C9o7x7eKA8Q=
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