---

SELECT
    c.id AS contract_id,
    c.number AS contract_number,
    c.service_type,
    cph.pens_product_id AS product_id,
    hppm.name AS expected_contract_form
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 pp
    ON pp.id = ppp.param_pl_id
JOIN prod_line.pens_product_param_pl_hb_param_pl_multiselect pm
    ON pm.pens_product_param_pl_id = ppp.id
JOIN prod_line.hb_param_pl_multiselect hppm
    ON hppm.id = pm.hb_param_pl_multiselect_id
WHERE pp.name = 'Форма договора'
ORDER BY c.id DESC
LIMIT 20;