---

SELECT DISTINCT cph.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
JOIN ourpension.contract_product_history cph
    ON cph.pens_product_id = pppp.pens_product_id
WHERE tpprc.contract_id IS NULL
  AND current_timestamp BETWEEN
      cph.begin_date
      AND COALESCE(cph.end_date, 'infinity')
LIMIT 20;