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 = '52'
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
ID=187Name=Harem Le Blanc Plonk
ID=195Name=Chardonnay Margaret River
ID=417Name=Roussanne Beechworth
ID=484Name=Chardonnay The Slint
ID=237Name=Grüner Veltliner Bergdiestel
ID=241Name=Weissburgunder Reflexion Hohes Eck
ID=242Name=Grüner Veltliner Spiegel 1er
ID=460Name=Fumé Blanc Numen
ID=468Name=Gruner Veltliner Loibenberg Smaragd
-
Australia
Victoria
2016
Jamsheed
Harem Le Blanc Plonk
187
-
Australia
Western Australia
2016
Larry Cherubino
Chardonnay Margaret River
195
-
Australia
Victoria
2016
Jamsheed
Roussanne Beechworth
417
-
Australia
South Australia
2016
Ochota Barrels
Chardonnay The Slint
484
-
Austria
Wachau
2016
Tegernseerhof
Grüner Veltliner Bergdiestel
237
-
Austria
Weinviertel
2016
Bioweingut Zillinger
Weissburgunder Reflexion Hohes Eck
241
-
Austria
Wagram
2016
Weingut Ott
Grüner Veltliner Spiegel 1er
242
-
Austria
Weinviertel
2016
Bioweingut Zillinger
Fumé Blanc Numen
460
-
Austria
Wachau
2016
Tegernseerhof
Gruner Veltliner Loibenberg Smaragd
468