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 `special_interest_idx` ON special_interest_idx.entity_id = e.entity_id AND special_interest_idx.attribute_id = '159' AND special_interest_idx.store_id = 1 AND special_interest_idx.value = '486'
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=141Name=Gruner Veltliner Am Berg
ID=142Name=Gruner Veltliner Fass 4
ID=201Name=Grüner Veltliner Röschitz
ID=203Name=Grüner Veltliner Reflexions Kellerberg
ID=241Name=Weissburgunder Reflexion Hohes Eck
ID=242Name=Grüner Veltliner Spiegel 1er
ID=314Name=Grüner Veltliner Hollenburger
ID=316Name=Gelber Muskateller
ID=387Name=Blaufrankisch Kalkstein
-
AT
Lower Austria
2017
Weingut Ott
Gruner Veltliner Am Berg
141
-
AT
Lower Austria
2017
Weingut Ott
Gruner Veltliner Fass 4
142
-
AT
Weinviertel
2017
Weingut Gruber
Grüner Veltliner Röschitz
201
-
AT
Weinviertel
2017
Bioweingut Zillinger
Grüner Veltliner Reflexions Kellerberg
203
-
AT
Weinviertel
2016
Bioweingut Zillinger
Weissburgunder Reflexion Hohes Eck
241
-
AT
Wagram
2016
Weingut Ott
Grüner Veltliner Spiegel 1er
242
-
AT
Kremstal
NV
Weingut Hoch
Grüner Veltliner Hollenburger
314
-
AT
Weinviertel
2017
Weingut Gruber
Gelber Muskateller
316
-
AT
Burgenland
2016
Claus Preisinger
Blaufrankisch Kalkstein
387