---

select
    sh.id as sharer_id,
    sh.contract_id,
    atc.id as atc_id,
    atc.*
from ourpension.sharer sh
left join ourpension.application_termination_contract atc
    on atc.sharer_id = sh.id
where sh.contract_id = 13006318
order by atc.id desc;