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 `regions_idx` ON regions_idx.entity_id = e.entity_id AND regions_idx.attribute_id = '155' AND regions_idx.store_id = 1 AND regions_idx.value = '301'
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=179Name=Cote Rotie Reserve
ID=181Name=Cote Rotie Belle Helene
ID=249Name=Condrieu Combe de Malleval
ID=320Name=Petit Ours Cotes du Rhone Syrah
ID=392Name=Cote Rotie Mon Village
ID=393Name=St Joseph Silice
ID=394Name=St Joseph Olivae
ID=395Name=Cornas Brise Cailloux
ID=396Name=Cornas Billes Noires
-
FR
Northern Rhone
2013
Michel & Stephane Ogier
Cote Rotie Reserve
179
-
FR
Northern Rhone
2012
Michel & Stephane Ogier
Cote Rotie Belle Helene
181
-
FR
Northern Rhone
2016
Michel & Stephane Ogier
Condrieu Combe de Malleval
249
-
FR
Northern Rhone
2016
Domaine du Coulet
Petit Ours Cotes du Rhone Syrah
320
-
FR
Northern Rhone
2016
Michel & Stephane Ogier
Cote Rotie Mon Village
392
-
FR
Northern Rhone
2016
Domaine Coursodon
St Joseph Silice
393
-
FR
Northern Rhone
2016
Domaine Coursodon
St Joseph Olivae
394
-
FR
Northern Rhone
2016
Domaine du Coulet
Cornas Brise Cailloux
395
-
FR
Northern Rhone
2012
Domaine du Coulet
Cornas Billes Noires
396