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 `vintag_idx` ON vintag_idx.entity_id = e.entity_id AND vintag_idx.attribute_id = '150' AND vintag_idx.store_id = 1 AND vintag_idx.value = '419'
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 OFFSET 9
ID=242Name=Grüner Veltliner Spiegel 1er
ID=456Name=Kalkundkiesel Cuvée Rot
ID=460Name=Fumé Blanc Numen
ID=468Name=Gruner Veltliner Loibenberg Smaragd
ID=474Name=Riesling Federspiel
ID=582Name=Gruner Veltliner Buteo
ID=583Name=Nanu? Rotburger
ID=737Name=Riesling Smaragd Steinertal
ID=787Name=Zweigelt Velue
-
Austria
Wagram
2016
Weingut Ott
Grüner Veltliner Spiegel 1er
242
-
Austria
Burgenland
2016
Claus Preisinger
Kalkundkiesel Cuvée Rot
456
-
Austria
Weinviertel
2016
Bioweingut Zillinger
Fumé Blanc Numen
460
-
Austria
Wachau
2016
Tegernseerhof
Gruner Veltliner Loibenberg Smaragd
468
-
Austria
Wachau
2016
Weingut Knoll
Riesling Federspiel
474
-
Austria
Weinviertel
2016
Michael Gindl
Gruner Veltliner Buteo
582
-
Austria
Weinviertel
2016
Michael Gindl
Nanu? Rotburger
583
-
Austria
Wachau
2016
Tegernseerhof
Riesling Smaragd Steinertal
737
-
Austria
Weinviertel
2016
Bioweingut Zillinger
Zweigelt Velue
787