---

SELECT
    c.id AS contract_id,
    c.number AS contract_number,
    cp.minimal_payment_amount AS contract_value,
    (
        SELECT mp.min_pension_from
        FROM prod_line.pens_product_param_pl p_min
        JOIN prod_line.param_pl def_min
            ON def_min.id = p_min.param_pl_id
        JOIN prod_line.table_param_pl_minimum_pension mp
            ON mp.pens_product_param_pl_id = p_min.id
        WHERE p_min.pens_product_id = 6693
          AND def_min.brief = 'МинРазмерПенсии'
          AND mp.min_pension_from IS NOT NULL
        ORDER BY mp.id DESC
        LIMIT 1
    ) AS product_value
FROM ourpension.contract c
LEFT JOIN ourpension.contract_params cp
    ON cp.contract_id = c.id
WHERE c.id = 13670550;