---

(

    SELECT mpf."name"

    FROM prod_line.pens_product_param_pl ppp_freq

    JOIN prod_line.param_pl p_freq

        ON p_freq.id = ppp_freq.param_pl_id

    JOIN prod_line.pens_product_param_pl_hb_param_pl_multiselect ppm_freq

        ON ppm_freq.pens_product_param_pl_id = ppp_freq.id

    JOIN prod_line.hb_param_pl_multiselect mpf

        ON mpf.id = ppm_freq.hb_param_pl_multiselect_id

    WHERE ppp_freq.pens_product_id = pp.id

      AND p_freq.brief = 'ПериодичностьВзносов'

      AND mpf."name" <> 'Не установлено'

    LIMIT 1

) AS contribution_frequency,