20th January 2017You don't hear so much about organic food anymore, and for many people deciding whether to buy wine from organic vineyards is just one more factor alongside the region where the vineyard is found, the grape or grapes used, and basics like the colour and alcohol strength of the wine.
Read more
9th January 2017Whether you prefer to buy wine online or in-store at your local independent wine merchant, it's worth looking out for the best deals on wine prices - and you might be surprised by what's on offer.
Read more
9th December 2016Whether you give Christmas wine gifts as an annual tradition or a one-off treat to a loved one, or even as a thank you to a business colleague or employee, Portland Wine's great selection has you covered and we can take custom orders too.
Read more
14th November 2016As we move into the last six weeks before Christmas, it's a time when many people will be shopping for gifts from local businesses - and your local independent wine merchant is there to help you celebrate in style.
Read more
28th October 2016If you are planning to buy wine for Bonfire Night, first a word of warning - if you have an actual bonfire or fireworks to set off, somebody should be the designated non-drinker to take care of these with a clear head.
Read more
14th October 2016A fine wine tasting contest organised by French publication La Revue du vin de France ended in a shock win for the Chinese on October 8th, with the newly crowned champions putting their high score down to 50% knowledge and 50% blind luck.
Read more
30th September 2016According to new research from the VIB in Belgium, it's all about natural selection - or in the case of brewing, unnatural selection, as the 'best' yeast cultures have been handed down from generation to generation.
Read more
19th September 2016When you buy wine online from Portland Wine, we aim to give you some of the best special offers we can - to match those you'd find at your local independent wine merchant, without the need to leave the house to place your order.
Read more
10th September 2016Are you looking to get a foot on the ladder in the wine trade? Or simply just want to get involved on a part-time basis and learn more about the wonderful world of wine? Read on!
Read more
2nd September 2016With the recent period of exam results, many parents and their children have had much to celebrate - but for parents September is the time to buy wine online for a true celebration of their children's academic success.
Read more
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `ck_posts` | 13 | 13 | 6 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 0 | |
| 3 | SHOW FULL COLUMNS FROM `ck_images` | 9 | 9 | 3 | |
| 4 | SHOW FULL COLUMNS FROM `ck_post_comments` | 9 | 9 | 6 | |
| 5 | SHOW FULL COLUMNS FROM `ck_contacts` | 14 | 14 | 4 | |
| 6 | SHOW FULL COLUMNS FROM `ck_redirects` | 5 | 5 | 4 | |
| 7 | SELECT `Redirect`.`id`, `Redirect`.`from`, `Redirect`.`to`, `Redirect`.`count`, `Redirect`.`created` FROM `ck_redirects` AS `Redirect` WHERE `Redirect`.`from` = '/news' LIMIT 1 | 0 | 0 | 0 | |
| 8 | SHOW FULL COLUMNS FROM `ck_users` | 11 | 11 | 4 | |
| 9 | SELECT COUNT(*) AS `count` FROM `ck_posts` AS `Post` LEFT JOIN `ck_images` AS `Image` ON (`Post`.`image_id` = `Image`.`id`) WHERE `Post`.`status` = 'active' AND `Post`.`post_date` <= '2017-07-20 16:24:25' AND NOT (`Post`.`slug` = '') | 1 | 1 | 1 | |
| 10 | SELECT `Post`.`id`, `Post`.`title`, `Post`.`slug`, `Post`.`introduction`, `Post`.`body`, `Post`.`image_id`, `Post`.`post_date`, `Post`.`meta_title`, `Post`.`meta_description`, `Post`.`meta_keywords`, `Post`.`status`, `Post`.`created`, `Post`.`modified`, `Image`.`id`, `Image`.`gallery_order`, `Image`.`title`, `Image`.`file`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`created`, `Image`.`modified` FROM `ck_posts` AS `Post` LEFT JOIN `ck_images` AS `Image` ON (`Post`.`image_id` = `Image`.`id`) WHERE `Post`.`status` = 'active' AND `Post`.`post_date` <= '2017-07-20 16:24:25' AND NOT (`Post`.`slug` = '') ORDER BY `Post`.`post_date` DESC, `Post`.`created` DESC LIMIT 10 | 10 | 10 | 1 | |
| 11 | SELECT `PostComment`.`id`, `PostComment`.`post_id`, `PostComment`.`author_id`, `PostComment`.`user_id`, `PostComment`.`comment`, `PostComment`.`status`, `PostComment`.`ip_address`, `PostComment`.`created`, `PostComment`.`modified` FROM `ck_post_comments` AS `PostComment` WHERE ((`PostComment`.`status` = 'approved') OR (((`PostComment`.`id` IS NULL) AND (`PostComment`.`status` = 'pending')))) AND `PostComment`.`post_id` IN (285, 284, 283, 281, 280, 279, 278, 277, 276, 275) | 0 | 0 | 0 | |
| 12 | SHOW FULL COLUMNS FROM `ck_baskets` | 7 | 7 | 4 | |
| 13 | SHOW FULL COLUMNS FROM `ck_store_countries` | 11 | 11 | 4 | |
| 14 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 0 | |
| 15 | SHOW FULL COLUMNS FROM `ck_delivery_methods` | 11 | 11 | 4 | |
| 16 | SHOW FULL COLUMNS FROM `ck_store_countries_delivery_methods` | 3 | 3 | 4 | |
| 17 | SHOW FULL COLUMNS FROM `ck_basket_products` | 8 | 8 | 6 | |
| 18 | SHOW FULL COLUMNS FROM `ck_products` | 22 | 22 | 6 | |
| 19 | SHOW FULL COLUMNS FROM `ck_regions` | 13 | 13 | 4 | |
| 20 | SHOW FULL COLUMNS FROM `ck_producers` | 6 | 6 | 5 | |
| 21 | SHOW FULL COLUMNS FROM `ck_styles` | 10 | 10 | 4 | |
| 22 | SHOW FULL COLUMNS FROM `ck_bottles` | 5 | 5 | 4 | |
| 23 | SHOW FULL COLUMNS FROM `ck_product_ratings` | 9 | 9 | 6 | |
| 24 | SHOW FULL COLUMNS FROM `ck_store_customers` | 7 | 7 | 4 | |
| 25 | SHOW FULL COLUMNS FROM `ck_store_customer_addresses` | 20 | 20 | 6 | |
| 26 | SHOW FULL COLUMNS FROM `ck_grapes` | 9 | 9 | 7 | |
| 27 | SHOW FULL COLUMNS FROM `ck_grapes_products` | 3 | 3 | 4 | |
| 28 | SHOW FULL COLUMNS FROM `ck_product_types` | 7 | 7 | 4 | |
| 29 | SHOW FULL COLUMNS FROM `ck_product_types_products` | 3 | 3 | 4 | |
| 30 | SHOW FULL COLUMNS FROM `ck_offers` | 7 | 7 | 6 | |
| 31 | SHOW FULL COLUMNS FROM `ck_offers_products` | 3 | 3 | 6 | |
| 32 | SELECT `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 1 | 0 | 0 | 0 | |
| 33 | SELECT `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 | 121 | 121 | 0 | |
| 34 | SELECT `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) | 1026 | 1026 | 33 | |
| 35 | SELECT `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 | 121 | 121 | 1 | |
| 36 | SELECT `Style`.`slug`, `Style`.`name` FROM `ck_styles` AS `Style` WHERE 1 = 1 | 8 | 8 | 0 | |
| 37 | SHOW FULL COLUMNS FROM `ck_right_banners` | 7 | 7 | 6 | |
| 38 | SELECT `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' | 4 | 4 | 0 | |
| 39 | SHOW FULL COLUMNS FROM `ck_right_links` | 6 | 6 | 6 | |
| 40 | SELECT `RightLink`.`id`, `RightLink`.`name`, `RightLink`.`url`, `RightLink`.`status`, `RightLink`.`created`, `RightLink`.`modified` FROM `ck_right_links` AS `RightLink` WHERE `RightLink`.`status` = 'active' | 2 | 2 | 0 | |
| 41 | SHOW FULL COLUMNS FROM `ck_settings` | 4 | 4 | 6 | |
| 42 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_description' LIMIT 1 | 1 | 1 | 0 | |
| 43 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_keywords' LIMIT 1 | 1 | 1 | 0 | |
| 44 | SELECT `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 1 | 0 | 0 | 0 | |
| 45 | SELECT `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 1 | 0 | 0 | 0 |
