---

select
    ps.id,
    ps.name,
    ps.brief,
    ps.code_1c,
    ps.index_scheme
from prod_line.pens_scheme ps
where exists (
    select 1
    from back_office.report_conformity_pu_bu_detail rd
    where rd.report_conformity_pu_bu_id = 97
      and rd.account in ('38902', '39002')
      and rd.pension_scheme_id = ps.id
)
order by ps.id
limit 5;