---

SELECT DISTINCT
    c.id AS contract_id,
    c.number,
    cph.pens_product_id,
    prod_line.get_value_link_param(
        CAST(p.id AS integer),
        CAST(ppp.value_ref AS integer)
    ) AS pl_contribution_frequency
FROM ourpension.contract c
JOIN ourpension.contract_product_history cph
    ON cph.contract_id = c.id
   AND CURRENT_TIMESTAMP BETWEEN
       cph.begin_date
       AND COALESCE(cph.end_date, 'infinity')
JOIN prod_line.pens_product_param_pl ppp
    ON ppp.pens_product_id = cph.pens_product_id
JOIN prod_line.param_pl p
    ON p.id = ppp.param_pl_id
WHERE p.brief = 'ПериодичностьВзносов'
  AND ppp.value_ref IS NOT NULL
ORDER BY c.id DESC
LIMIT 20;