Edit History

Hello,

By default you are not allowed to have duplicate values for Features (eg. If you have a Composition Feature with the Cotton value assigned to a product, next time you try to add another Composition Value with the Cotton value for the same product, you get the following error: 'You cannot associate the same feature value more than once.')

When you say duplicates, are you referring to the fact that you have a Feature like Composition but with multiple values (Cotton, Ceramic, Wool etc.) assigned to a product?

If the answer to the above is yes, this query will list all of them (if you have multiple languages and want to see the values for these as well, remove the id_lang check or change it accordingly):

SELECT DISTINCT PP.`id_product`, PPL.`name` AS 'product_name', PF.`id_feature`, PFL.`name` AS 'feature_name', PFVL.`value` AS 'feature_value'
FROM `ps_product` PP
INNER JOIN `ps_product_lang` PPL ON PP.`id_product` = PPL.`id_product`
INNER JOIN `ps_feature_product` PFP ON PP.`id_product` = PFP.`id_product`
INNER JOIN `ps_feature` PF on PFP.`id_feature` = PF.`id_feature`
INNER JOIN `ps_feature_lang` PFL ON PF.`id_feature` = PFL.`id_feature`
INNER JOIN `ps_feature_value` PFV ON PFP.`id_feature_value` = PFV.`id_feature_value`
INNER JOIN `ps_feature_value_lang` PFVL ON PFV.`id_feature_value` = PFVL.`id_feature_value`
WHERE PP.`product_type` = 'combinations' AND `PFVL`.`id_lang` = '1'
ORDER BY PP.`id_product`;