---

select
    tpprc.period_month_from,
    tpprc.period_month_to,
    tpprc.stage_id,
    hs.name as stage_name,
    tpprc.k1,
    tpprc.k2,
    cp.special_life_situations,
    cp.accumulation_payment_stage
from prod_line.table_param_pl_redemption_coeff tpprc
join prod_line.pens_product_param_pl pppp
    on pppp.id = tpprc.pens_product_param_pl_id
left join prod_line.hb_stage hs
    on hs.id = tpprc.stage_id
left join ourpension.contract_params cp
    on cp.contract_id = 13488842
where pppp.pens_product_id = 9622
  and tpprc.contract_id is null
order by tpprc.period_month_from, tpprc.id;