---

SELECT
    tpprc.id AS tpprc_id,
    tpprc.k1,
    tpprc.k2,
    tpprc.period_month_from,
    tpprc.period_month_to,
    tpprc.contract_id,
    pppp.id AS pppp_id,
    pppp.pens_product_id,
    pp.id AS pp_id,
    cph.id AS cph_id,
    cp.contract_id AS cp_contract_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
LEFT JOIN prod_line.hb_stage hs
    ON hs.id = tpprc.stage_id
JOIN prod_line.param_pl pp
    ON pp.id = pppp.param_pl_id
LEFT JOIN ourpension.contract_product_history cph
    ON cph.pens_product_id = pppp.pens_product_id
    AND cph.contract_id = 13012597
    AND current_timestamp BETWEEN
        cph.begin_date
        AND COALESCE(cph.end_date, 'infinity')
LEFT JOIN ourpension.contract_params cp
    ON cp.contract_id = 13012597
WHERE
    tpprc.contract_id = 13012597
    OR (
        tpprc.contract_id IS NULL
        AND cph.contract_id IS NOT NULL
        AND NOT EXISTS (
            SELECT 1
            FROM prod_line.table_param_pl_redemption_coeff tpprc_contract
            WHERE tpprc_contract.contract_id = 13012597
        )
    );