---

select
    rd.id,
    rd.account,
    rd.pension_scheme_id,
    ps.name as pension_scheme_name,
    rd.strategy_id,
    st.name as strategy_name,
    rd.uidpensionscheme,
    rd.sum_dt_pu,
    rd.sum_ct_pu
from back_office.report_conformity_pu_bu_detail rd
left join prod_line.pens_scheme ps
    on ps.id = rd.pension_scheme_id
left join prod_line.hb_invest_strategy st
    on st.id = rd.strategy_id
where rd.report_conformity_pu_bu_id = 92
  and rd.pension_scheme_id = 253702;