---

SELECT
    pppp.param_pl_id,
    pp."name" AS param_name,
    pp.brief,
    COUNT(*) AS row_count
FROM prod_line.table_param_pl_add_contribution_params t
JOIN prod_line.pens_product_param_pl pppp
    ON pppp.id = t.pens_product_param_pl_id
JOIN prod_line.param_pl pp
    ON pp.id = pppp.param_pl_id
GROUP BY
    pppp.param_pl_id,
    pp."name",
    pp.brief
ORDER BY
    pppp.param_pl_id;