Our Products

Filtered By:

  • Region > Bordeaux
Reserve de la Comtesse

Reserve de la Comtesse

Size: Bottle (75 cl)

£69.95
Château Malbat

Château Malbat

Size: Bottle (75 cl)

The vineyards of Château Malbat consist of 65 hectares in the southern part of the Gironde. The clay and limestone soils produce quality grapes that are vinified traditionally, producing soft, easy drinking wines. The blend is 70% Merlot, 25% Cabernet Sauvignon, and 5% Cab Franc.

£8.95
Château Batailley 5eme Cru Classe

Château Batailley 5eme Cru Classe

Size: Bottle (75 cl)

Château Batailley is one of the oldest buildings in Pauillac. The wine exhibits a deep ruby, purple colour with elegant black and red currant flavours. Notes of cigar box, pepper and spices lead to hints of liquorice and earth on the finish.

£44.95
Chateau Moulinet Lasserre

Chateau Moulinet Lasserre

Size: Bottle (75 cl)

£34.95
Chateau Puy Blanquet Grand Cru

Chateau Puy Blanquet Grand Cru

Size: Bottle (75 cl)

This stunning red wine is ruby coloured and exhibits a fragrant spicy cherry-scented nose intertwined with strong herb and earth aromas. In the mouth the wine reveals a inner-core of sweet ripe fruit with a long spicy finish.

£23.95
Chateau Jean Voisin

Chateau Jean Voisin

Size: Bottle (75 cl)

Fine nose with ripe buttery Merlot, hints of plum, minerals and tobacco combined with good structure. Chateau Jean Voisin is an old Domaine which was bought and extensively updated by the négociant Michel Chassagnoux in the early 2000s. Since then the quality of the wine has improved...

£19.95
Château Haut Beausejour

Château Haut Beausejour

Size: Bottle (75 cl)

Lush smoky blackberry fruit with gorgeous smoky, mineral notes and succulent cassis supported by hints of creamy oak.

£29.95
Château de Pez

Château de Pez

Size: Bottle (75 cl)

£42.95

Chateau Lafleur Gazin Pomerol

Size: Bottle (75 cl)

£39.95

Château Batailley 5eme Cru Classe

Size: Magnum

Château Batailley is one of the oldest buildings in Pauillac. The wine exhibits a deep ruby, purple colour with elegant black and red currant flavours. Notes of cigar box, pepper and spices lead to hints of liquorice and earth on the finish.

£95.00
  • Pages
  • 1 | 2
(default) 38 queries took 56 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `ck_products`22223
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
4SELECT `Redirect`.`id`, `Redirect`.`from`, `Redirect`.`to`, `Redirect`.`count`, `Redirect`.`created` FROM `ck_redirects` AS `Redirect` WHERE `Redirect`.`from` = '/region/bordeaux' LIMIT 1000
5SELECT `Region`.`id`, `Region`.`name`, `Region`.`parent_id`, `Region`.`lft`, `Region`.`rght`, `Region`.`order`, `Region`.`slug`, `Region`.`meta_title`, `Region`.`meta_description`, `Region`.`meta_keywords`, `Region`.`status`, `Region`.`created`, `Region`.`modified` FROM `ck_regions` AS `Region` WHERE `Region`.`slug` = 'bordeaux' ORDER BY `Region`.`order` ASC LIMIT 1110
6SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`vintage`, `Product`.`region_id`, `Product`.`producer_id`, `Product`.`style_id`, `Product`.`bottle_id`, `Product`.`image_id`, `Product`.`bid`, `Product`.`best_seller`, `Product`.`created`, `Product`.`modified`, `Product`.`status`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`stock`, `Product`.`stock_description`, `Product`.`original_id`, (`Product`.`price`) AS `Product__original_price`, (LEAST(IFNULL((select min(`ck_offers`.`price`) from (ck_offers join ck_offers_products) where ((`ck_offers_products`.`product_id` = `Product`.`id`) and (`ck_offers_products`.`offer_id` = `ck_offers`.`id`) and (`ck_offers`.`start_date` <= now()) and (`ck_offers`.`end_date` >= now()))),`Product`.`price`),`Product`.`price`)) AS `Product__price`, (CONCAT(`Product`.`name`, ' (£', `Product`.`price`,')')) AS `Product__detail_name` FROM `ck_products` AS `Product` WHERE `Product`.`region_id` = (1) 771
7SELECT `Grape`.`id`, `Grape`.`name`, `Grape`.`created`, `Grape`.`modified`, `Grape`.`order`, `Grape`.`slug`, `Grape`.`meta_title`, `Grape`.`meta_description`, `Grape`.`meta_keywords` FROM `ck_grapes` AS `Grape` WHERE `Grape`.`slug` = 'bordeaux' LIMIT 1000
8SELECT `Style`.`name`, `Style`.`colour_id`, `Style`.`id`, `Style`.`created`, `Style`.`modified`, `Style`.`order`, `Style`.`slug`, `Style`.`meta_title`, `Style`.`meta_description`, `Style`.`meta_keywords` FROM `ck_styles` AS `Style` WHERE `Style`.`slug` = 'bordeaux' LIMIT 1000
9SELECT `Grape`.`id`, `Grape`.`name` FROM `ck_grapes` AS `Grape` WHERE NOT (`Grape`.`slug` = '') ORDER BY `Grape`.`name` ASC 1591590
10SELECT `Style`.`id`, `Style`.`name` FROM `ck_styles` AS `Style` WHERE NOT (`Style`.`slug` = '') ORDER BY `Style`.`name` ASC 880
11SELECT `ProductType`.`id`, `ProductType`.`name` FROM `ck_product_types` AS `ProductType` WHERE `ProductType`.`status` = 'active' AND NOT (`ProductType`.`slug` = '') ORDER BY `ProductType`.`name` ASC 110
12SELECT `Region`.`id`, `Region`.`name`, `Region`.`lft`, `Region`.`rght` FROM `ck_regions` AS `Region` WHERE 1 = 1 ORDER BY `Region`.`lft` asc 1261260
13SELECT `Region`.`id`, `Region`.`name`, `Region`.`parent_id`, `Region`.`lft`, `Region`.`rght`, `Region`.`order`, `Region`.`slug`, `Region`.`meta_title`, `Region`.`meta_description`, `Region`.`meta_keywords`, `Region`.`status`, `Region`.`created`, `Region`.`modified` FROM `ck_regions` AS `Region` WHERE `Region`.`slug` = 'bordeaux' ORDER BY `Region`.`order` ASC LIMIT 1110
14SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`vintage`, `Product`.`region_id`, `Product`.`producer_id`, `Product`.`style_id`, `Product`.`bottle_id`, `Product`.`image_id`, `Product`.`bid`, `Product`.`best_seller`, `Product`.`created`, `Product`.`modified`, `Product`.`status`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`stock`, `Product`.`stock_description`, `Product`.`original_id`, (`Product`.`price`) AS `Product__original_price`, (LEAST(IFNULL((select min(`ck_offers`.`price`) from (ck_offers join ck_offers_products) where ((`ck_offers_products`.`product_id` = `Product`.`id`) and (`ck_offers_products`.`offer_id` = `ck_offers`.`id`) and (`ck_offers`.`start_date` <= now()) and (`ck_offers`.`end_date` >= now()))),`Product`.`price`),`Product`.`price`)) AS `Product__price`, (CONCAT(`Product`.`name`, ' (£', `Product`.`price`,')')) AS `Product__detail_name` FROM `ck_products` AS `Product` WHERE `Product`.`region_id` = (1) 771
15SELECT `Region`.`lft`, `Region`.`rght`, `Region`.`id` FROM `ck_regions` AS `Region` WHERE `Region`.`id` = 1 ORDER BY `Region`.`order` ASC LIMIT 1110
16SELECT `Region`.`id`, `Region`.`name`, `Region`.`parent_id`, `Region`.`lft`, `Region`.`rght`, `Region`.`order`, `Region`.`slug`, `Region`.`meta_title`, `Region`.`meta_description`, `Region`.`meta_keywords`, `Region`.`status`, `Region`.`created`, `Region`.`modified` FROM `ck_regions` AS `Region` WHERE ((1 = 1) AND (((`Region`.`status` = 'active') AND (NOT (`Region`.`slug` = ''))))) AND `Region`.`lft` <= 79 AND `Region`.`rght` >= 108 ORDER BY `Region`.`lft` asc 110
17SELECT `Region`.`lft`, `Region`.`rght` FROM `ck_regions` AS `Region` WHERE ((1 = 1) AND (((`Region`.`status` = 'active') AND (NOT (`Region`.`slug` = ''))))) AND `Region`.`id` = 1 ORDER BY `Region`.`order` ASC LIMIT 1110
18SELECT `Region`.`id` FROM `ck_regions` AS `Region` WHERE ((1 = 1) AND (((`Region`.`status` = 'active') AND (NOT (`Region`.`slug` = ''))))) AND `Region`.`rght` < 108 AND `Region`.`lft` > 79 ORDER BY `Region`.`order` ASC 14140
19SHOW FULL COLUMNS FROM `ck_settings`444
20SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'prodperpage' LIMIT 1110
21SELECT COUNT(*) AS `count` FROM `ck_products` AS `Product` LEFT JOIN `ck_images` AS `Image` ON (`Product`.`image_id` = `Image`.`id`) LEFT JOIN `ck_regions` AS `Region` ON (`Product`.`region_id` = `Region`.`id`) LEFT JOIN `ck_producers` AS `Producer` ON (`Product`.`producer_id` = `Producer`.`id`) LEFT JOIN `ck_styles` AS `Style` ON (`Product`.`style_id` = `Style`.`id`) LEFT JOIN `ck_bottles` AS `Bottle` ON (`Product`.`bottle_id` = `Bottle`.`id`) WHERE `Region`.`id` IN (1, 156, 90, 91, 4, 5, 6, 78, 7, 31, 93, 94, 32, 73, 63) AND `Product`.`status` = 'active' 111
22SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`vintage`, `Product`.`region_id`, `Product`.`producer_id`, `Product`.`style_id`, `Product`.`bottle_id`, `Product`.`image_id`, `Product`.`bid`, `Product`.`best_seller`, `Product`.`created`, `Product`.`modified`, `Product`.`status`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`stock`, `Product`.`stock_description`, `Product`.`original_id`, (`Product`.`price`) AS `Product__original_price`, (LEAST(IFNULL((select min(`ck_offers`.`price`) from (ck_offers join ck_offers_products) where ((`ck_offers_products`.`product_id` = `Product`.`id`) and (`ck_offers_products`.`offer_id` = `ck_offers`.`id`) and (`ck_offers`.`start_date` <= now()) and (`ck_offers`.`end_date` >= now()))),`Product`.`price`),`Product`.`price`)) AS `Product__price`, (CONCAT(`Product`.`name`, ' (£', `Product`.`price`,')')) AS `Product__detail_name`, `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified`, `Region`.`id`, `Region`.`name`, `Region`.`parent_id`, `Region`.`lft`, `Region`.`rght`, `Region`.`order`, `Region`.`slug`, `Region`.`meta_title`, `Region`.`meta_description`, `Region`.`meta_keywords`, `Region`.`status`, `Region`.`created`, `Region`.`modified`, `Producer`.`id`, `Producer`.`name`, `Producer`.`created`, `Producer`.`modified`, `Producer`.`order`, `Producer`.`slug`, `Style`.`name`, `Style`.`colour_id`, `Style`.`id`, `Style`.`created`, `Style`.`modified`, `Style`.`order`, `Style`.`slug`, `Style`.`meta_title`, `Style`.`meta_description`, `Style`.`meta_keywords`, `Bottle`.`id`, `Bottle`.`name`, `Bottle`.`created`, `Bottle`.`modified`, `Bottle`.`order` FROM `ck_products` AS `Product` LEFT JOIN `ck_images` AS `Image` ON (`Product`.`image_id` = `Image`.`id`) LEFT JOIN `ck_regions` AS `Region` ON (`Product`.`region_id` = `Region`.`id`) LEFT JOIN `ck_producers` AS `Producer` ON (`Product`.`producer_id` = `Producer`.`id`) LEFT JOIN `ck_styles` AS `Style` ON (`Product`.`style_id` = `Style`.`id`) LEFT JOIN `ck_bottles` AS `Bottle` ON (`Product`.`bottle_id` = `Bottle`.`id`) WHERE `Region`.`id` IN (1, 156, 90, 91, 4, 5, 6, 78, 7, 31, 93, 94, 32, 73, 63) AND `Product`.`status` = 'active' ORDER BY `Product`.`stock` DESC LIMIT 1010102
23SELECT `ProductRating`.`id`, `ProductRating`.`product_id`, `ProductRating`.`store_customer_id`, `ProductRating`.`rating`, `ProductRating`.`comments`, `ProductRating`.`anonymous`, `ProductRating`.`status`, `ProductRating`.`created`, `ProductRating`.`modified` FROM `ck_product_ratings` AS `ProductRating` WHERE `ProductRating`.`status` = 'active' AND `ProductRating`.`product_id` IN (3120, 2449, 2691, 3125, 3129, 3128, 2692, 2766, 9135, 9176) 000
24SELECT `Grape`.`id`, `Grape`.`name`, `Grape`.`created`, `Grape`.`modified`, `Grape`.`order`, `Grape`.`slug`, `Grape`.`meta_title`, `Grape`.`meta_description`, `Grape`.`meta_keywords`, `GrapesProduct`.`id`, `GrapesProduct`.`grape_id`, `GrapesProduct`.`product_id` FROM `ck_grapes` AS `Grape` JOIN `ck_grapes_products` AS `GrapesProduct` ON (`GrapesProduct`.`product_id` IN (3120, 2449, 2691, 3125, 3129, 3128, 2692, 2766, 9135, 9176) AND `GrapesProduct`.`grape_id` = `Grape`.`id`) 22220
25SELECT `ProductType`.`id`, `ProductType`.`name`, `ProductType`.`introduction`, `ProductType`.`slug`, `ProductType`.`status`, `ProductType`.`created`, `ProductType`.`modified`, `ProductTypesProduct`.`id`, `ProductTypesProduct`.`product_type_id`, `ProductTypesProduct`.`product_id` FROM `ck_product_types` AS `ProductType` JOIN `ck_product_types_products` AS `ProductTypesProduct` ON (`ProductTypesProduct`.`product_id` IN (3120, 2449, 2691, 3125, 3129, 3128, 2692, 2766, 9135, 9176) AND `ProductTypesProduct`.`product_type_id` = `ProductType`.`id`) 000
26SELECT `Offer`.`id`, `Offer`.`name`, `Offer`.`description`, `Offer`.`start_date`, `Offer`.`end_date`, `Offer`.`price`, `Offer`.`status`, `OffersProduct`.`id`, `OffersProduct`.`product_id`, `OffersProduct`.`offer_id` FROM `ck_offers` AS `Offer` JOIN `ck_offers_products` AS `OffersProduct` ON (`OffersProduct`.`product_id` IN (3120, 2449, 2691, 3125, 3129, 3128, 2692, 2766, 9135, 9176) AND `OffersProduct`.`offer_id` = `Offer`.`id`) 990
27SELECT `Basket`.`id`, `Basket`.`created`, `Basket`.`modified`, `Basket`.`delivery_method_id`, `Basket`.`delivery_country_id`, `Basket`.`delivery`, `Basket`.`subtotal`, (`Basket`.`delivery` + `Basket`.`subtotal`) AS `Basket__total`, `DeliveryCountry`.`id`, `DeliveryCountry`.`key`, `DeliveryCountry`.`iso`, `DeliveryCountry`.`iso3`, `DeliveryCountry`.`order`, `DeliveryCountry`.`country`, `DeliveryCountry`.`billing`, `DeliveryCountry`.`delivery`, `DeliveryCountry`.`status`, `DeliveryCountry`.`modified`, `DeliveryCountry`.`created`, `DeliveryMethod`.`id`, `DeliveryMethod`.`name`, `DeliveryMethod`.`price`, `DeliveryMethod`.`cap`, `DeliveryMethod`.`threshold`, `DeliveryMethod`.`threshold_price`, `DeliveryMethod`.`status`, `DeliveryMethod`.`modified`, `DeliveryMethod`.`created`, `DeliveryMethod`.`order`, `DeliveryMethod`.`code` FROM `ck_baskets` AS `Basket` LEFT JOIN `ck_store_countries` AS `DeliveryCountry` ON (`Basket`.`delivery_country_id` = `DeliveryCountry`.`id`) LEFT JOIN `ck_delivery_methods` AS `DeliveryMethod` ON (`Basket`.`delivery_method_id` = `DeliveryMethod`.`id`) WHERE `Basket`.`id` IS NULL LIMIT 1000
28SELECT `Region`.`name`, `Region`.`slug`, `Region`.`parent_id`, `Region`.`id`, `Region`.`modified`, `Region`.`created` FROM `ck_regions` AS `Region` WHERE `Region`.`status` = 'active' AND NOT (`Region`.`slug` = '') ORDER BY `Region`.`order` ASC 1211210
29SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`vintage`, `Product`.`region_id`, `Product`.`producer_id`, `Product`.`style_id`, `Product`.`bottle_id`, `Product`.`image_id`, `Product`.`bid`, `Product`.`best_seller`, `Product`.`created`, `Product`.`modified`, `Product`.`status`, `Product`.`slug`, `Product`.`meta_title`, `Product`.`meta_description`, `Product`.`meta_keywords`, `Product`.`stock`, `Product`.`stock_description`, `Product`.`original_id`, (`Product`.`price`) AS `Product__original_price`, (LEAST(IFNULL((select min(`ck_offers`.`price`) from (ck_offers join ck_offers_products) where ((`ck_offers_products`.`product_id` = `Product`.`id`) and (`ck_offers_products`.`offer_id` = `ck_offers`.`id`) and (`ck_offers`.`start_date` <= now()) and (`ck_offers`.`end_date` >= now()))),`Product`.`price`),`Product`.`price`)) AS `Product__price`, (CONCAT(`Product`.`name`, ' (£', `Product`.`price`,')')) AS `Product__detail_name` FROM `ck_products` AS `Product` WHERE `Product`.`region_id` IN (905, 899, 900, 904, 901, 902, 903, 42, 144, 86, 152, 56, 132, 134, 57, 81, 148, 1, 156, 90, 91, 4, 5, 6, 78, 7, 31, 93, 94, 32, 73, 63, 13, 37, 95, 96, 14, 70, 35, 21, 36, 24, 25, 26, 60, 98, 99, 100, 101, 102, 103, 104, 79, 43, 44, 67, 77, 84, 52, 53, 105, 135, 45, 106, 153, 47, 140, 68, 141, 111, 48, 65, 69, 113, 143, 145, 40, 83, 62, 41, 58, 114, 115, 59, 116, 49, 118, 119, 136, 120, 38, 64, 39, 121, 87, 50, 51, 71, 27, 28, 154, 150, 29, 129, 80, 155, 30, 151, 61, 122, 123, 138, 124, 125, 137, 126, 127, 85, 128, 139, 149) 1026102634
30SELECT `Region`.`id`, `Region`.`name`, `Region`.`parent_id`, `Region`.`lft`, `Region`.`rght`, `Region`.`order`, `Region`.`slug`, `Region`.`meta_title`, `Region`.`meta_description`, `Region`.`meta_keywords`, `Region`.`status`, `Region`.`created`, `Region`.`modified` FROM `ck_regions` AS `Region` WHERE `Region`.`status` = 'active' AND NOT (`Region`.`slug` = '') ORDER BY `Region`.`order` ASC 1211211
31SELECT `Style`.`slug`, `Style`.`name` FROM `ck_styles` AS `Style` WHERE 1 = 1 880
32SHOW FULL COLUMNS FROM `ck_right_banners`775
33SELECT `RightBanner`.`id`, `RightBanner`.`name`, `RightBanner`.`image_id`, `RightBanner`.`url`, `RightBanner`.`status`, `RightBanner`.`created`, `RightBanner`.`modified`, `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_right_banners` AS `RightBanner` LEFT JOIN `ck_images` AS `Image` ON (`RightBanner`.`image_id` = `Image`.`id`) WHERE `RightBanner`.`status` = 'active' 440
34SHOW FULL COLUMNS FROM `ck_right_links`663
35SELECT `RightLink`.`id`, `RightLink`.`name`, `RightLink`.`url`, `RightLink`.`status`, `RightLink`.`created`, `RightLink`.`modified` FROM `ck_right_links` AS `RightLink` WHERE `RightLink`.`status` = 'active' 220
36SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_keywords' LIMIT 1110
37SELECT `User`.`id`, `User`.`role`, `User`.`contact_id`, `User`.`username`, `User`.`password`, `User`.`status`, `User`.`active`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, `Contact`.`id`, `Contact`.`first_name`, `Contact`.`surname`, `Contact`.`email`, `Contact`.`website`, `Contact`.`address_1`, `Contact`.`address_2`, `Contact`.`city`, `Contact`.`postcode`, `Contact`.`country_code`, `Contact`.`telephone`, `Contact`.`organisation`, `Contact`.`created`, `Contact`.`modified`, (CONCAT(`Contact`.`first_name`,' ',`Contact`.`surname`)) AS `Contact__name` FROM `ck_users` AS `User` LEFT JOIN `ck_contacts` AS `Contact` ON (`User`.`contact_id` = `Contact`.`id`) WHERE `User`.`id` IS NULL LIMIT 1000
38SELECT `Contact`.`id`, `Contact`.`first_name`, `Contact`.`surname`, `Contact`.`email`, `Contact`.`website`, `Contact`.`address_1`, `Contact`.`address_2`, `Contact`.`city`, `Contact`.`postcode`, `Contact`.`country_code`, `Contact`.`telephone`, `Contact`.`organisation`, `Contact`.`created`, `Contact`.`modified`, (CONCAT(`Contact`.`first_name`,' ',`Contact`.`surname`)) AS `Contact__name` FROM `ck_contacts` AS `Contact` WHERE `Contact`.`id` IS NULL LIMIT 1000