select c.name, c.inn, c.legalAddress, (select c2.number from rtneo$Contract c2 where c2.contragent.id = c.id and c2.createTs = (select max(c3.createTs) from rtneo$Contract c3 where c3.contragent.id = c.id and c3.mainContract is null)) from rtneo$Contragent c where (select count(c1) from rtneo$Contract c1 where c1.contragent.id = c.id and not c1.mainContract is null and c1.accepted = true and (c1.mainContract.loadedFromBigTrio = false or c1.mainContract.loadedFromBigTrio is null))>0