---

select
    si.id,
    si.name,
    si.service_type,
    si.is_aggregate,
    sa.account
from ourpension.spr_indicator_bu si
left 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 in (
    '39035', '39035.1', '39035.2',
    '39036', '39036.1', '39036.2',
    '39037', '39037.1', '39037.2',
    '48305', '48305.1', '48305.3',
    '48310',
    '60301', '60322',
    '48306', '48306.1', '48306.3',
    '48309',
    '60302', '60323',
    '48301', '48301.1', '48301.3'
)
order by si.id, sa.account