select ct.inn from public.rtneo_contract c, public.rtneo_contragent ct where c.contragent_id = ct.id and c.delete_ts is null and (select count(mc) from public.rtneo_contract mc where mc.id = c.main_contract_id and mc.delete_ts is not null) > 0;