Current Offers

Runamok Merlot

Style:Red

£7.49

View product
Château Malbat

Style:Red

£8.95

View product
Barolo Manfredi

Style:Red

£21.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 38 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `ck_pages`14141
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `ck_redirects`550
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`11110
6SHOW FULL COLUMNS FROM `ck_contacts`14140
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`22220
12SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
13SHOW FULL COLUMNS FROM `ck_images`990
14SHOW FULL COLUMNS FROM `ck_regions`13130
15SHOW FULL COLUMNS FROM `ck_producers`660
16SHOW FULL COLUMNS FROM `ck_styles`10100
17SHOW FULL COLUMNS FROM `ck_bottles`550
18SHOW FULL COLUMNS FROM `ck_product_ratings`990
19SHOW FULL COLUMNS FROM `ck_store_customers`770
20SHOW FULL COLUMNS FROM `ck_store_customer_addresses`20200
21SHOW FULL COLUMNS FROM `ck_store_countries`11110
22SHOW FULL COLUMNS FROM `ck_grapes`990
23SHOW FULL COLUMNS FROM `ck_grapes_products`330
24SHOW FULL COLUMNS FROM `ck_product_types`770
25SHOW FULL COLUMNS FROM `ck_product_types_products`330
26SHOW FULL COLUMNS FROM `ck_offers`770
27SHOW FULL COLUMNS FROM `ck_offers_products`330
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 (98, 89, 94, 97, 95, 92) AND `OffersProduct`.`product_id` = `Product`.`id`) ORDER BY RAND() ASC LIMIT 6661
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` = 1932 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` = 2257 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` = 2065 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` = 2184 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` = 32 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` = 25 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` = 1932 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` = 2257 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` = 2065 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` = 2184 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` = 32 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` = 25 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` = 1932 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` = 2257 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` = 2065 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` = 2184 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` = 32 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` = 25 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` = 1932 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` = 2257 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` = 2065 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` = 2184 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` = 32 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` = 25 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` = 1932 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` = 2257 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` = 2065 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` = 2184 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` = 32 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` = 25 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` = 1932 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` = 2257 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` = 2065 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` = 2184 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` = 32 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` = 25 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`770
108SHOW FULL COLUMNS FROM `ck_delivery_methods`11110
109SHOW FULL COLUMNS FROM `ck_store_countries_delivery_methods`330
110SHOW FULL COLUMNS FROM `ck_basket_products`880
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 1211210
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) 1026102633
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`770
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`660
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