Current Offers

Runamok Shiraz

Style:Red

£7.49

View product
Runamok Chardonnay

Style:White

£7.49

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) 102 queries took 111 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
3SELECT `Redirect`.`id`, `Redirect`.`from`, `Redirect`.`to`, `Redirect`.`count`, `Redirect`.`created` FROM `ck_redirects` AS `Redirect` WHERE `Redirect`.`from` = '/' LIMIT 1000
4SELECT `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
5SELECT `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
6SELECT `Page`.`lft`, `Page`.`rght` FROM `ck_pages` AS `Page` WHERE `Page`.`id` = 10 ORDER BY `Page`.`order` ASC LIMIT 1110
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 ((1 = 1) AND (((`Page`.`status` = 'active') AND (NOT (`Page`.`slug` = ''))))) AND `Page`.`lft` <= 15 AND `Page`.`rght` >= 22 ORDER BY `Page`.`lft` asc 110
8SELECT `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
9SELECT `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, 95, 98, 90, 96, 93) AND `OffersProduct`.`product_id` = `Product`.`id`) ORDER BY RAND() ASC LIMIT 6666
10SELECT `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
11SELECT `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` = 1933 110
12SELECT `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` = 2291 110
13SELECT `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
14SELECT `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` = 2669 110
15SELECT `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
16SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
17SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
18SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
19SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
20SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
21SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
22SELECT `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
23SELECT `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` = 1933 110
24SELECT `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` = 2291 110
25SELECT `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
26SELECT `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` = 2669 110
27SELECT `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
28SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
29SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
30SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
31SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
32SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
33SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 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` = 1933 110
36SELECT `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` = 2291 110
37SELECT `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
38SELECT `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` = 2669 110
39SELECT `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
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 `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
43SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
44SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
45SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 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` = 1933 110
48SELECT `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` = 2291 110
49SELECT `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
50SELECT `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` = 2669 110
51SELECT `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
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 `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
55SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
56SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
57SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 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` = 1933 110
60SELECT `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` = 2291 110
61SELECT `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
62SELECT `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` = 2669 110
63SELECT `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
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 `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
67SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
68SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
69SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 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` = 1933 110
72SELECT `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` = 2291 110
73SELECT `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
74SELECT `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` = 2669 110
75SELECT `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
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 `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
79SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
80SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 25 110
81SELECT `Style`.`name`, `Style`.`slug` FROM `ck_styles` AS `Style` WHERE `Style`.`id` = 32 110
82SELECT `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 10991
83SELECT `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
84SELECT `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
85SELECT `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
86SELECT `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
87SHOW FULL COLUMNS FROM `ck_baskets`778
88SHOW FULL COLUMNS FROM `ck_delivery_methods`11117
89SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
90SHOW FULL COLUMNS FROM `ck_store_countries_delivery_methods`3311
91SHOW FULL COLUMNS FROM `ck_basket_products`888
92SELECT `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
93SELECT `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
94SELECT `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) 1026102644
95SELECT `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
96SELECT `Style`.`slug`, `Style`.`name` FROM `ck_styles` AS `Style` WHERE 1 = 1 880
97SHOW FULL COLUMNS FROM `ck_right_banners`778
98SELECT `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
99SHOW FULL COLUMNS FROM `ck_right_links`6611
100SELECT `RightLink`.`id`, `RightLink`.`name`, `RightLink`.`url`, `RightLink`.`status`, `RightLink`.`created`, `RightLink`.`modified` FROM `ck_right_links` AS `RightLink` WHERE `RightLink`.`status` = 'active' 220
101SELECT `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
102SELECT `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