---

select
    h.contract_id,
    h.pens_product_id,
    pppp.id as product_param_id,
    pp2.brief,
    pppp.value_int,
    pppp.value_decimal,
    pppp.value_string,
    pppp.value_ref
from ourpension.contract_product_history h
join prod_line.pens_product