---

select
    si.id,
    si.name,
    cast(si.service_type as text) as service_type,
    si.is_aggregate as parent_id,
    string_agg(
        sa.account,
        ' + ' order by sa.account
    ) as accounts
from ourpension.spr_indicator_bu si
left join ourpension.spr_accounts_indicator_bu sa
    on sa.spr_indicator_bu_id = si.id
where si.id = 49
   or si.is_aggregate = 49
group by
    si.id,
    si.name,
    si.service_type,
    si.is_aggregate
order by si.id