---

select
    pp.id as param_id,
    pp.name,
    pp.brief,
    count(pppp.id) as product_count
from prod_line.param_pl pp
left join prod_line.pens_product_param_pl pppp
    on pppp.param_pl_id = pp.id
where pp.brief in (
    'ПоэтапныйВестингПарамРасчетаСрока',
    'ПериодПредостПравТреб'
)
group by
    pp.id,
    pp.name,
    pp.brief
order by pp.id;