---

COALESCE(
    cp.first_payment_delay,
    (
        SELECT param.value_int
        FROM cte_param_pl param
        WHERE param.brief = 'СрокОжиданияПервогоВзносаКоличДней'
    )
) AS first_contribution_wait_period,




select
    cp.contract_id,
    c.number,
    cp.first_payment_delay
from ourpension.contract_params cp
join ourpension.contract c
    on c.id = cp.contract_id
where cp.first_payment_delay is not null
order by cp.contract_id desc
limit 20;