select a from rtneo$Accrual a where a.contractPosition.contragentRealEstate.id in (select r.contragentRealEstate.id from rtneo$RealEstateContainerYard r where r.contragentRealEstate.id = 'b21ce113-dc76-c845-e68b-c0215d92a1dd') order by a.period

select a.contractPosition.contragentRealEstate from rtneo$Accrual a where a.documentNumber = 2403381 and a.contractPosition.contragentRealEstate.id in (select r.contragentRealEstate.id from rtneo$RealEstateContainerYard r where r.contragentRealEstate.id = '471989bb-16f8-cd8c-8cf8-bd274e86ad1b') order by a.period

select a.contractPosition.contragentRealEstate from rtneo$Accrual a join rtneo$RealEstateContainerYard r where a.contractPosition.contragentRealEstate.id = r.contragentRealEstate.id and r.contragentRealEstate.id = '471989bb-16f8-cd8c-8cf8-bd274e86ad1b' !! a.documentNumber = 2403381 and a.contractPosition.contragentRealEstate.id in (select r.contragentRealEstate.id from rtneo$RealEstateContainerYard r where r.contragentRealEstate.id = '471989bb-16f8-cd8c-8cf8-bd274e86ad1b') order by a.period

select r.containerYard.code from rtneo$Accrual a join rtneo$RealEstateContainerYard r where a.contractPosition.contragentRealEstate.id = r.contragentRealEstate.id and a.documentNumber = 2403384 and r.containerYard.code = 38103608 order by a.period