---

select
    si.id,
    si.name,
    si.service_type,
    si.is_aggregate,
    sa.account
from ourpension.spr_indicator_bu si
join ourpension.spr_accounts_indicator_bu sa
    on sa.spr_indicator_bu_id = si.id
where (
    'NPO' = any(si.service_type)
    or 'PDS' = any(si.service_type)
)
and (
    sa.account like '39031%'
    or sa.account like '39032%'
    or sa.account like '39033%'
    or sa.account like '39034%'
)
order by sa.account, si.id;