Prestashop Product Features - to quickly generate a list of features per product

prestashop_product_features.sql

select 
	p.id_product,
	p.name as name_product,
	fl.id_feature,
	fl.`name` as name_feature,
	fv.value
from
	product_lang p
	left join feature_product as fp on (p.id_product = fp.id_product)
	left join feature_lang as fl on (fl.id_feature = fp.id_feature)
	left join feature_value_lang as fv on (fp.id_feature_value = fv.id_feature_value)
where
	p.id_lang = 1
	and fv.id_lang = 1
	and fl.id_lang = 1