---

select
    c.id as contract_id,
    c.date as contract_date,

    c.pension_rule_id as current_contract_rule_id,
    pr_current.edition_number as current_contract_rule,

    h.period as history_period,
    h.pension_rule_id as history_rule_id,
    pr_history.edition_number as history_rule,

    h.reason_id,
    h.comment,
    h.version,
    h.id_1c

from ourpension.contract c

left join ourpension.npo_contract_pension_rules_history h
    on h.contract_id = c.id

left join ourpension.pension_rule pr_current
    on pr_current.id = c.pension_rule_id

left join ourpension.pension_rule pr_history
    on pr_history.id = h.pension_rule_id

where c.id = 13390240

order by h.period, h.version;