---

select
    c.id as contract_id,
    c.number,
    cp.vesting_type,
    cp.account_vesting_type_id
from ourpension.contract c
left join ourpension.contract_params cp
    on cp.contract_id = c.id
where c.number = '0021435';