---

select
    t.id,
    t.pens_product_param_pl_id,
    t.warranty_period,
    t.hb_invest_profileid,
    t.year_conclusion_from,
    t.year_conclusion_to,
    t.pens_program_id,
    t.validity_period_from,
    t.validity_period_to
from prod_line.table_param_pl_warrant_period t
where t.pens_product_param_pl_id = 248656
order by
    t.year_conclusion_from,
    t.hb_invest_profileid,
    t.validity_period_from;