---

select
    p.id as product_id,
    p.name as product_name,
    p.pens_scheme_accum_stage_id as scheme_id,
    ps.brief as scheme_name,
    ps.pension_rule_id as scheme_pension_rule_id,
    r.pension_rule_id as relation_pension_rule_id,
    pr.edition_number,
    pr.date_reg
from prod_line.pens_product p
left join prod_line.pens_scheme ps
    on ps.id = p.pens_scheme_accum_stage_id
left join prod_line.rel_pens_scheme_pension_rules r
    on r.pens_scheme_id = ps.id
left join ourpension.pension_rule pr
    on pr.id = r.pension_rule_id
where p.id = 8977
order by pr.date_reg desc nulls last,
         pr.edition_number desc nulls last;