Jump to content

What table stores product custom attributes?


ultrasquash

Recommended Posts

Thanks a lot guys, I really appreciate your support, my final query was:

SELECT * FROM `g_feature_product` fp, `g_feature_value` fv, `g_feature_value_lang` fvl, `g_feature_lang` fl  WHERE 
fp.id_feature = fv.id_feature
and fp.id_feature = fl.id_feature
and fvl.id_feature_value = fv.id_feature_value
and fvl.id_feature_value = fp.id_feature_value
and fvl.id_lang = fl.id_lang
and fv.custom <> 0
and fl.id_lang = 7 /*your languaje(s)*/
order by fp.id_product

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...