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 `wine_garage_type_idx` ON wine_garage_type_idx.entity_id = e.entity_id AND wine_garage_type_idx.attribute_id = '151' AND wine_garage_type_idx.store_id = 1 AND wine_garage_type_idx.value = '696'
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=823Name=Haggis Wine
ID=580Name=Grafin
ID=637Name=Kalkundkiesel Cuvee Weiss
ID=786Name=Riesling Numen
ID=789Name=Erdeluftgrasundreben
ID=910Name=Karpatenschiefer Skin contact
ID=936Name=Numen Muskateller
ID=943Name=Materia Prima Traminer
-
Australia
Victoria
2018
Patrick Sullivan
Haggis Wine
823
-
Austria
Styria
2015
Maria & Sepp Muster
Grafin
580
-
Austria
Burgenland
2017
Claus Preisinger
Kalkundkiesel Cuvee Weiss
637
-
Austria
Weinviertel
2017
Bioweingut Zillinger
Riesling Numen
786
-
Austria
Burgenland
2017
Claus Preisinger
Erdeluftgrasundreben
789
-
Austria
Carnuntum
2018
Weingut Trapl
Karpatenschiefer Skin contact
910
-
Austria
Weinviertel
2017
Bioweingut Zillinger
Numen Muskateller
936
-
Austria
Wagram
2018
Weingut Fritsch
Materia Prima Traminer
943