---

select
    p.id as parent_id,
    pa.account as parent_account,
    p.name as parent_name,
    c.id as child_id,
    ca.account as child_account,
    c.name as child_name
from ourpension.spr_indicator_bu p
join ourpension.spr_accounts_indicator_bu pa
    on pa.spr_indicator_bu_id = p.id
left join ourpension.spr_indicator_bu c
    on c.is_aggregate = p.id
left join ourpension.spr_accounts_indicator_bu ca
    on ca.spr_indicator_bu_id = c.id
where pa.account in ('38911', '39011')
order by pa.account, ca.account, c.id;