---

select
    pppp.pens_product_id,
    pppp.id as product_param_id,
    pp.id as param_id,
    pp.name as param_name,
    pp.brief,
    pt.min_term_from,
    pt.min_term_to,
    pt.max_term_from,
    pt.max_term_to,
    pt.app_date_from,
    pt.app_date_to,
    pt.payment_type_pl_multiselect_id,
    ms.name as payment_type
from prod_line.table_param_pl_payment_term pt
join prod_line.pens_product_param_pl pppp
    on pppp.id = pt.pens_product_param_pl_id
join prod_line.param_pl pp
    on pp.id = pppp.param_pl_id
left join prod_line.hb_param_pl_multiselect ms
    on ms.id = pt.payment_type_pl_multiselect_id
order by pppp.pens_product_id desc, pt.id
limit 50;