There is wine for every occasion! And in our portfolio you will find the highest-quality wines available for every price point. We taste every vintage of every wine that makes it into the portfolio, thus ensuring that they have enough character to bear the Wine Garage name. The selection includes hard to source wines, by any standard around the world, so please discover.
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(countries_option_value_t2.value_id IS NULL, countries_option_value_t1.value, countries_option_value_t2.value) AS `countries` FROM `wgcatalog_product_entity` AS `e`
INNER JOIN `wgcatalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '37'
INNER JOIN `wgcatalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `wgcatalog_product_index_eav` AS `regions_idx` ON regions_idx.entity_id = e.entity_id AND regions_idx.attribute_id = '155' AND regions_idx.store_id = 1 AND regions_idx.value = '268'
LEFT JOIN `wgcatalog_product_entity_int` AS `countries_t1` ON e.entity_id=countries_t1.entity_id AND countries_t1.attribute_id='152' AND countries_t1.store_id=0
LEFT JOIN `wgcatalog_product_entity_int` AS `countries_t2` ON e.entity_id=countries_t2.entity_id AND countries_t2.attribute_id='152' AND countries_t2.store_id='1'
LEFT JOIN `wgeav_attribute_option_value` AS `countries_option_value_t1` ON countries_option_value_t1.option_id=IF(countries_t2.value_id > 0, countries_t2.value, countries_t1.value) AND countries_option_value_t1.store_id=0
LEFT JOIN `wgeav_attribute_option_value` AS `countries_option_value_t2` ON countries_option_value_t2.option_id=IF(countries_t2.value_id > 0, countries_t2.value, countries_t1.value) AND countries_option_value_t2.store_id=1 ORDER BY `countries` ASC, `entity_id` ASC LIMIT 9
ID=121Name=Riesling Bruck
ID=237Name=Grüner Veltliner Bergdiestel
ID=469Name=Gruner Veltliner Steinriegl
ID=474Name=Riesling Federspiel
ID=642Name=Gruner Veltliner Loibenberg Smaragd
ID=737Name=Riesling Smaragd Steinertal
ID=738Name=Riesling Smaragd Steinertal
-
AT
Wachau
2011
Veyder Malberg
Riesling Bruck
121
-
AT
Wachau
2016
Tegernseerhof
Grüner Veltliner Bergdiestel
237
-
AT
Wachau
2008
Tegernseerhof
Gruner Veltliner Steinriegl
469
-
AT
Wachau
2016
Weingut Knoll
Riesling Federspiel
474
-
AT
Wachau
2016
Weingut Knoll
Gruner Veltliner Loibenberg Smaragd
642
-
AT
Wachau
2016
Tegernseerhof
Riesling Smaragd Steinertal
737
-
AT
Wachau
2010
Tegernseerhof
Riesling Smaragd Steinertal
738