---

select
    cp.contract_id,

    cp.time_calc_param_id,
    tcp.name as time_calc_param_name,
    tcp.brief as time_calc_param_brief,

    cp.period_right_requirement_id,
    prr.name as period_right_req_name,
    prr.brief as period_right_req_brief

from ourpension.contract_params cp

left join prod_line.hb_param_pl_multiselect tcp
    on tcp.id = cp.time_calc_param_id

left join prod_line.hb_param_pl_multiselect prr
    on prr.id = cp.period_right_requirement_id

where cp.contract_id = 13063250;