Wine

SHOP

Currently Shopping by:

Vintage: 2016 Remove This Item

Type
Varietal
Country
Region
Style
Special interest
Size
Price

SHOP

Wine	Spirits
Beer	Other
Vodka

Wine

The selection available includes hard to source wines, by any standard around the world. Among the 500 references are wines ideal for a casual get together, a special meal you might be planning, or to stash away in your cellar and also suitable for gift giving. We truly believe that drinking good wine should be fun and inspiring – and hope to assist you with your new discovery.

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=583Name=Nanu? Rotburger
ID=737Name=Riesling Smaragd Steinertal
ID=787Name=Zweigelt Velue
ID=788Name=Riesling Steinhaus Rote Erde
ID=790Name=Blaufrankisch Reserve
ID=940Name=Blaufrankisch Spitzerberg
ID=369Name=Cabernet Sauvignon
ID=421Name=Cabernet Franc
ID=29Name=Gin Tonic