---

SELECT
    tpprc.id,
    tpprc.k1,
    tpprc.k2,
    tpprc.period_month_from,
    tpprc.period_month_to,
    tpprc.contract_id,
    tpprc.stage_id
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
WHERE pppp.pens_product_id = 9456
  AND tpprc.contract_id IS NULL
ORDER BY
    tpprc.period_month_from,
    tpprc.period_month_to;