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 `countries_idx` ON countries_idx.entity_id = e.entity_id AND countries_idx.attribute_id = '152' AND countries_idx.store_id = 1 AND countries_idx.value = '57'
INNER JOIN `wgcatalog_product_index_eav` AS `wine_style_idx` ON wine_style_idx.entity_id = e.entity_id AND wine_style_idx.attribute_id = '153' AND wine_style_idx.store_id = 1 AND wine_style_idx.value = '261'
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=170Name=Ventoux Blanc
ID=250Name=Cuvee de Conti
ID=256Name=Chardonnay Terroir 11300
ID=258Name=Terres Blanches
ID=259Name=Vezelay Galerne
ID=406Name=Vouvray Sec Tuffo
ID=411Name=Muscadet Sevre & Maine
ID=487Name=Chablis Vieilles Vignes
ID=581Name=Vezelay Chatelaine
-
France
Southern Rhone
2016
Domaine Fondreche
Ventoux Blanc
170
-
France
Bergerac
2016
Chateau Tour des Gendres
Cuvee de Conti
250
-
France
Limoux
2018
Domaine Begude
Chardonnay Terroir 11300
256
-
France
Gascony
2017
Domaine Chiroulet
Terres Blanches
258
-
France
Burgundy
2017
Montanet Thoden
Vezelay Galerne
259
-
France
Loire Valley
2017
Domaine de la Poultière
Vouvray Sec Tuffo
406
-
France
Loire Valley
2018
Domaine de Bellevue
Muscadet Sevre & Maine
411
-
France
Burgundy
2018
Domaine Testut
Chablis Vieilles Vignes
487
-
France
Burgundy
2017
Domaine La Cadette
Vezelay Chatelaine
581