---

select
    cp.period_right_requirement_id,
    ms.name,
    ms.brief,
    count(*) as cnt
from ourpension.contract_params cp
join prod_line.hb_param_pl_multiselect ms
    on ms.id = cp.period_right_requirement_id
where cp.period_right_requirement_id is not null
group by
    cp.period_right_requirement_id,
    ms.name,
    ms.brief
order by cnt desc;