---

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 like '38911%'
    or sa.account like '39011%'
    or sa.account like '39031%'
    or si.name ilike '%ОВТ%'
)
order by si.id, sa.account;