Query configurator options for a given product


I want to query the different values for each variant in the database but I can see how they are related. I know there is an unique order number for each one but can’t follow the relationship between them. Let’s say I want to fetch colour and size for a given product, where should I have to look?


[SELECT](http://phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/select.html) \* FROM `s_article_configurator_option_relations` AS t1 LEFT JOIN s\_articles\_details AS t2 ON t2.id = t1.article\_id LEFT JOIN s\_article\_configurator\_options AS t3 ON t1.option\_id = t3.id WHERE t2.articleID = [Your Article Id]

Thanks @odessite‍ for your reply, I’m going to try it :slight_smile: