---

SELECT
    cph.id,
    cph.contract_id,
    cph.pens_product_id,
    cph.begin_date,
    cph.end_date
FROM ourpension.contract_product_history cph
WHERE cph.contract_id = 13012597
  AND current_timestamp BETWEEN
      cph.begin_date
      AND COALESCE(cph.end_date, 'infinity');