Current Offers

Runamok Merlot

Style:Red

£7.49

View product
Barolo Manfredi

Style:Red

£21.95

View product
Runamok Shiraz

Style:Red

£7.49

View product
Château Malbat

Style:Red

£8.95

View product

Current Best Sellers

Roederer Brut Premier

Style:Sparkling White

£33.95

View product

Welcome to Portland Wine

At the Portland Wine Company we don't just sell fine wine, we offer the complete fine wine experience. We offer low prices, friendly service and above all, we have knowledgeable staff who can help you choose the right wine.

In addition we hold frequent wine tastings and publish a regular newsletter which can be mailed to you if you send us your name and address.

Free Delivery We are offering free delivery for orders of £50 or more.

Buying Wine...Let Us Help

Drinking wine is the easy bit! Buying it is much harder, especially on a tight budget. At Portland Wine we understand this, and not only offer very competitive prices, but do our best to help you make the right choice.

We only stock good wines, so whatever you buy we are certain that you will enjoy it.

Our special offers page has some very exceptional offers - check it out. And for those of you that like to sell (or drink!) wine by the gallon we have a very competitive wholesale price list.

Venues we supply

La Boheme restaurant serving French & European cuisine. This family owned restaurant is lead by Olivier Troalen, the head chef, and with his wife Adele, ably supported by an experienced team with a strong French influence in both the kitchen and the front of house.

Food and wine - the natural partners, plus a little live jazz every Tuesday at Smith's Restaurant, Eccles, Manchester. Fab food, great wines (we supply them!) and super music .

(default) 121 queries took 194 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `ck_pages`14146
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `ck_redirects`556
4SELECT `Redirect`.`id`, `Redirect`.`from`, `Redirect`.`to`, `Redirect`.`count`, `Redirect`.`created` FROM `ck_redirects` AS `Redirect` WHERE `Redirect`.`from` = '/' LIMIT 1000
5SHOW FULL COLUMNS FROM `ck_users`11116
6SHOW FULL COLUMNS FROM `ck_contacts`14145
7SELECT `Page`.`id`, `Page`.`title`, `Page`.`slug`, `Page`.`body`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`status`, `Page`.`created`, `Page`.`order`, `Page`.`modified` FROM `ck_pages` AS `Page` WHERE `Page`.`slug` = 'home' AND `Page`.`status` = 'active' AND NOT (`Page`.`slug` = '') ORDER BY `Page`.`order` ASC LIMIT 1110
8SELECT `Page`.`id`, `Page`.`title`, `Page`.`slug`, `Page`.`body`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`status`, `Page`.`created`, `Page`.`order`, `Page`.`modified` FROM `ck_pages` AS `Page` WHERE ((1 = 1) AND (((`Page`.`status` = 'active') AND (NOT (`Page`.`slug` = ''))))) AND `Page`.`parent_id` = 10 ORDER BY `Page`.`order` ASC 000
9SELECT `Page`.`lft`, `Page`.`rght` FROM `ck_pages` AS `Page` WHERE `Page`.`id` = 10 ORDER BY `Page`.`order` ASC LIMIT 1110
10SELECT `Page`.`id`, `Page`.`title`, `Page`.`slug`, `Page`.`body`, `Page`.`meta_title`, `Page`.`meta_description`, `Page`.`meta_keywords`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`status`, `Page`.`created`, `Page`.`order`, `Page`.`modified` FROM `ck_pages` AS `Page` WHERE ((1 = 1) AND (((`Page`.`status` = 'active') AND (NOT (`Page`.`slug` = ''))))) AND `Page`.`lft` <= 15 AND `Page`.`rght` >= 22 ORDER BY `Page`.`lft` asc 110
11SHOW FULL COLUMNS FROM `ck_products`22227
12SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
13SHOW FULL COLUMNS FROM `ck_images`995
14SHOW FULL COLUMNS FROM `ck_regions`13135
15SHOW FULL COLUMNS FROM `ck_producers`666
16SHOW FULL COLUMNS FROM `ck_styles`10104
17SHOW FULL COLUMNS FROM `ck_bottles`554
18SHOW FULL COLUMNS FROM `ck_product_ratings`996
19SHOW FULL COLUMNS FROM `ck_store_customers`776
20SHOW FULL COLUMNS FROM `ck_store_customer_addresses`20206
21SHOW FULL COLUMNS FROM `ck_store_countries`11116
22SHOW FULL COLUMNS FROM `ck_grapes`996
23SHOW FULL COLUMNS FROM `ck_grapes_products`336
24SHOW FULL COLUMNS FROM `ck_product_types`777
25SHOW FULL COLUMNS FROM `ck_product_types_products`336
26SHOW FULL COLUMNS FROM `ck_offers`777
27SHOW FULL COLUMNS FROM `ck_offers_products`337
28SELECT `Offer`.`id`, `Offer`.`name`, `Offer`.`description`, `Offer`.`start_date`, `Offer`.`end_date`, `Offer`.`price`, `Offer`.`status` FROM `ck_offers` AS `Offer` WHERE `Offer`.`status` = 'active' ORDER BY RAND() ASC LIMIT 6660
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`, `OffersProduct`.`id`, `OffersProduct`.`product_id`, `OffersProduct`.`offer_id` FROM `ck_products` AS `Product` JOIN `ck_offers_products` AS `OffersProduct` ON (`OffersProduct`.`offer_id` IN (91, 92, 95, 94, 97, 89) AND `OffersProduct`.`product_id` = `Product`.`id`) ORDER BY RAND() ASC LIMIT 6667
30SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2184 110
31SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
32SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2258 110
33SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2257 110
34SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
35SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 1932 110
36SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
37SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
38SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
39SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
40SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
41SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
42SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2184 110
43SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
44SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2258 110
45SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2257 110
46SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
47SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 1932 110
48SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
49SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
50SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
51SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
52SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
53SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
54SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2184 110
55SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
56SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2258 110
57SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2257 110
58SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
59SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 1932 110
60SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
61SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
62SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
63SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
64SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
65SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
66SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2184 110
67SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
68SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2258 110
69SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2257 110
70SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
71SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 1932 110
72SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
73SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
74SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
75SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
76SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
77SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
78SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2184 110
79SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
80SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2258 110
81SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2257 110
82SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
83SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 1932 110
84SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
85SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
86SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
87SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
88SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
89SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
90SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2184 110
91SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
92SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2258 110
93SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 2257 110
94SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 0 000
95SELECT `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_images` AS `Image` WHERE `Image`.`id` = 1932 110
96SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
97SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
98SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
99SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
100SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
101SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
102SELECT `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 `Product`.`best_seller` = 1 AND `Product`.`status` = 'active' AND NOT (`Product`.`slug` = '') LIMIT 10992
103SELECT `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 (2952, 14, 578, 1648, 2417, 3313, 2719, 2533, 9283) 000
104SELECT `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 (2952, 14, 578, 1648, 2417, 3313, 2719, 2533, 9283) AND `GrapesProduct`.`grape_id` = `Grape`.`id`) 10100
105SELECT `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 (2952, 14, 578, 1648, 2417, 3313, 2719, 2533, 9283) AND `ProductTypesProduct`.`product_type_id` = `ProductType`.`id`) 000
106SELECT `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 (2952, 14, 578, 1648, 2417, 3313, 2719, 2533, 9283) AND `OffersProduct`.`offer_id` = `Offer`.`id`) 330
107SHOW FULL COLUMNS FROM `ck_baskets`777
108SHOW FULL COLUMNS FROM `ck_delivery_methods`11116
109SHOW FULL COLUMNS FROM `ck_store_countries_delivery_methods`334
110SHOW FULL COLUMNS FROM `ck_basket_products`884
111SELECT `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
112SELECT `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 1211211
113SELECT `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) 1026102637
114SELECT `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
115SELECT `Style`.`slug`, `Style`.`name` FROM `ck_styles` AS `Style` WHERE 1 = 1 880
116SHOW FULL COLUMNS FROM `ck_right_banners`774
117SELECT `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
118SHOW FULL COLUMNS FROM `ck_right_links`664
119SELECT `RightLink`.`id`, `RightLink`.`name`, `RightLink`.`url`, `RightLink`.`status`, `RightLink`.`created`, `RightLink`.`modified` FROM `ck_right_links` AS `RightLink` WHERE `RightLink`.`status` = 'active' 220
120SELECT `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
121SELECT `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