---

SELECT
    c.id AS contract_id,
    c.number,
    c.date,
    c.agent_id,
    cph.pens_product_id,
    cp.form_id,
    lf.code AS form_code,
    lf.type_group_form_id
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')
LEFT JOIN ourpension.contract_params cp
    ON cp.contract_id = c.id
LEFT JOIN ourpension.landscape_form lf
    ON lf.id = cp.form_id
WHERE cph.pens_product_id = 9401
ORDER BY c.id DESC
LIMIT 20;