SELECT f.id_feature, fl.name as feature_name, fv.id_feature_value, fvl.value as feature_value
        FROM ps_feature_product fp
        INNER JOIN ps_feature f ON fp.id_feature = f.id_feature
        INNER JOIN ps_feature_lang fl ON f.id_feature = fl.id_feature AND fl.id_lang = 4
        INNER JOIN ps_feature_value fv ON fp.id_feature_value = fv.id_feature_value
        INNER JOIN ps_feature_value_lang fvl ON fv.id_feature_value = fvl.id_feature_value AND fvl.id_lang = 4
        INNER JOIN ps_product p ON fp.id_product = p.id_product
        INNER JOIN ps_category_product cp ON p.id_product = cp.id_product
        WHERE cp.id_category = 48
        AND f.id_feature IN (99,102,103)
        GROUP BY f.id_feature, fv.id_feature_value
        ORDER BY f.position, fl.name, fvl.value