# Query configurator options for a given product **URL:** \ **Category:** International (English Only)\ **Tags:** programming\ **Created:** [6. Juni 2018 um 11:25 UTC](https://forum.shopware.com/t/query-configurator-options-for-a-given-product/53304 "2018-06-06T11:25:34Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![roberto](https://avatars.discourse-cdn.com/v4/letter/r/8baadc/32.png) [@roberto](https://forum.shopware.com/u/roberto)\ **Post date:** [6. Juni 2018 um 11:25 UTC](https://forum.shopware.com/t/query-configurator-options-for-a-given-product/53304/1 "2018-06-06T11:25:34Z")
Hello, 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? Thanks ---
**Author:** ![odessite](https://avatars.discourse-cdn.com/v4/letter/o/f05b48/32.png) [@odessite](https://forum.shopware.com/u/odessite)\ **Post date:** [8. Juni 2018 um 07:59 UTC](https://forum.shopware.com/t/query-configurator-options-for-a-given-product/53304/2 "2018-06-08T07:59:42Z")
``` [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] ``` ---
**Author:** ![roberto](https://avatars.discourse-cdn.com/v4/letter/r/8baadc/32.png) [@roberto](https://forum.shopware.com/u/roberto)\ **Post date:** [12. Juni 2018 um 08:02 UTC](https://forum.shopware.com/t/query-configurator-options-for-a-given-product/53304/3 "2018-06-12T08:02:20Z")
Thanks @odessite‍ for your reply, I’m going to try it 🙂