SELECT
            pf.id_feature,
            fl.name AS feature_name,
            pf.id_feature_value,
            fvl.value AS feature_value
        FROM ps_product p
        INNER JOIN ps_category_product cp
            ON p.id_product = cp.id_product
        INNER JOIN ps_feature_product pf
            ON p.id_product = pf.id_product
        INNER JOIN ps_feature_lang fl
            ON pf.id_feature = fl.id_feature
            AND fl.id_lang = 4
        INNER JOIN ps_feature_value_lang fvl
            ON pf.id_feature_value = fvl.id_feature_value
            AND fvl.id_lang = 4
        WHERE
            cp.id_category = 48 
            AND p.active = 1
            AND pf.id_feature IN (99,102,103)
        ORDER BY pf.id_feature, fvl.value