Загрузка данных


SELECT
    id,
    "name",
    brief,
    param_pl_type_id,
    hb_param_pl_table_id
FROM prod_line.param_pl
WHERE hb_param_pl_table_id = 5402;




SELECT
    af.id,
    af.amount_from,
    af.amount_to,
    af.amount_av,
    af.contract_id,
    af.pens_product_param_pl_id,

    af.fee_type_pl_multiselect_id,
    ft."name" AS fee_type_name,

    af.fee_kind_pl_multiselect_id,
    fk."name" AS fee_kind_name

FROM prod_line.table_param_pl_administrative_fee af
LEFT JOIN prod_line.hb_param_pl_multiselect ft
    ON ft.id = af.fee_type_pl_multiselect_id
LEFT JOIN prod_line.hb_param_pl_multiselect fk
    ON fk.id = af.fee_kind_pl_multiselect_id
LIMIT 100;