Без ПНООЛР

select distinct cre.contragent.personalAccount from rtneo$ContragentRealEstate cre where cre.contragent in (select c from rtneo$Contragent c where size(c.realEstates) > 50 and size(c.wasteGenerationProjects) = 0) and cre.validityFrom is not null

КП без контейнеров

select r.containerYard.code, (select count(w) from rtneo$ContainerWaste w where w.containerYard.id = r.containerYard.id) from rtneo$RealEstateContainerYard r where r.contragentRealEstate.contragent.personalAccount = 'ААА3800000220'