select c.realEstate.cadastralNumber, c.realEstate.address, case when c.ownType = 1 then c.areaInRent else c.realEstate.area end, c.validityFrom, c.validityTo, c.category.isLiving, (select count(r) from rtneo$RealEstateContainerYard r where r.contragentRealEstate.id = c.id and r.factRequest = 20) from rtneo$ContragentRealEstate c where c.contragent.id = '296f1b23-7b07-a4d3-7f70-3f57cf6e0495'

select c.realEstate.cadastralNumber, c.realEstate.address, case when c.ownType = 1 then c.areaInRent else c.realEstate.area end, c.validityFrom, c.validityTo, c.category.isLiving, (select count(r) from rtneo$RealEstateContainerYard r where r.contragentRealEstate.id = c.id and r.factRequest = 20), case when c.ownType = 1 then 'Аренда' else 'Собственность' end from rtneo$ContragentRealEstate c where c.contragent.id = '296f1b23-7b07-a4d3-7f70-3f57cf6e0495' and (c.excludeFromAccounting is null or c.excludeFromAccounting = false)