mysql - prestashop : MySQL Query For product features

Question

我需要在 prestashop 1.5 中获取产品功能，但问题是我使用了一项修改，使我能够为每个产品的一项功能赋予多个值

示例:

兼容的存储卡: - 记忆录 xD - 内存棒 - 内存棒PRO - 多媒体卡 (MMC) - Carte 安全数字 (SD)

我收到这个查询:

Select fl.name, fvl.value, f.id_feature
From ps_feature_lang fl Left Join
  ps_feature_product fp On fl.id_feature = fp.id_feature And fp.id_product = 291
  Left Join
  ps_feature_value_lang fvl On fp.id_feature_value = fvl.id_feature_value And
    fvl.id_lang = 5 Left Join
  ps_feature f On f.id_feature = fl.id_feature
Where fl.id_feature In (Select ps__fc_categories_features.feature_id
  From ps__fc_categories_features)
Group By fl.name, fvl.value, f.id_feature, fl.id_feature
Order By f.position

但是，如果给定产品的某个功能具有多个值，它将为该功能提供多个原始数据最好的是一个查询，它将连接具有多个值的每个特征的值

提前谢谢。

Answer 1

您应该能够通过对查询进行小幅调整来完成此操作。试试这个:

Select fl.name, group_concat(fvl.value) as values, f.id_feature
From ps_feature_lang fl Left Join
     ps_feature_product fp
     On fl.id_feature = fp.id_feature And fp.id_product = 291 Left Join
     ps_feature_value_lang fvl
     On fp.id_feature_value = fvl.id_feature_value And fvl.id_lang = 5 Left Join
     ps_feature f
     On f.id_feature = fl.id_feature
Where fl.id_feature In (Select ps__fc_categories_features.feature_id
                        From ps__fc_categories_features
                       )
Group By fl.name, fl.id_feature
Order By f.position;

此查询从 group by 中删除 fvl.value 并添加 group_concat() select。我还删除了 f.id_feature。根据加入条件，它似乎是多余的。