---

select
    ytd.id as year_tax_deduction_id,
    ytd.application_termination_contract_id,
    sh.id as sharer_id,
    sh.sharer_id_1c
from ourpension.year_tax_deduction ytd
join ourpension.application_termination_contract_data ctd
    on ctd.application_termination_contract_id = ytd.application_termination_contract_id
join ourpension.sharer sh
    on sh.id = ctd.sharer_id
where ytd.id = :year_tax_deduction_id;