Get product by feature name (mySQL)

[Frenchy]

Hello, I'm trying to get all product by feature name in SQL.

I have some difficulties with Prestashop Database Architecture. I know there is the feature_value_lang with the value of feature and the id_feature_value.I know there is the feature_product with the id_product and the id_feature_value. I want to get in a array all products with a feature in parameter.

 

How can I do this ? I'm a newbie, Join SQL ? How I can do this ?

[phinq1910]

You can try

Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(" 
	SELECT p.id_product
    FROM `'._DB_PREFIX_.'feature_product` as p
    LEFT JOIN `'._DB_PREFIX_.'feature_value` as f ON (f.`id_feature_value` = p.`id_feature_value`)
    LEFT JOIN `'._DB_PREFIX_.'feature_shop` fs ON (f.`id_feature` = fs.`id_feature`)
    WHERE ...
")

 

[Frenchy]

More simply, I have get product_id with same feature name.

It is possible to create accessories product with product ID ?