---

select
    p.id as parent_id,
    pa.account as parent_account,
    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 (
    '39031', '39032', '39033', '39034'
)
order by pa.account, ca.account, c.id;