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


SELECT
    pp.id AS param_pl_id,
    pp."name" AS param_name,
    pp.brief,
    pppp.id AS pens_product_param_pl_id,
    pppp.pens_product_id,
    t.id AS table_row_id,
    t.amount,
    t.contribution_date_from,
    t.contribution_date_to,
    t.contribution_limit_type_pl_multiselect_id,
    t.add_contribution_param_pl_multiselect_id
FROM prod_line.param_pl pp
JOIN prod_line.pens_product_param_pl pppp
    ON pppp.param_pl_id = pp.id
LEFT JOIN prod_line.table_param_pl_add_contribution_params t
    ON t.pens_product_param_pl_id = pppp.id
WHERE pp.id IN (5397, 5401, 5460, 5461)
ORDER BY pp.id, pppp.pens_product_id, t.id;