---

select
    cp.contract_id,
    c.number,
    cp.tariff_id,
    tl.tariff_name
from ourpension.contract_params cp
join ourpension.contract c
    on c.id = cp.contract_id
left join actuary.tariff_list tl
    on tl.id = cp.tariff_id
where cp.tariff_id is not null
order by cp.contract_id desc
limit 20;