Turn up the romance when you buy wine online

romanceView larger image

When you buy wine online, you have a huge range to choose from - so if Valentine's Day has inspired you to have more romantic nights in with a loved one, which online wines should you opt for?

First of all, let's be honest, some people have strong opinions about the wine they like, so if you have a favourite grape or region, feel free to stick to it - this is just a brief guide for those who aren't sure.

That being said, in white wine Chardonnay is the classic, and choosing an online wine is an excellent way to get great value for money.

Chardonnay is the grape, not the region, so you can find it from several regions; Cahors is the usual French region, while Argentinean and Chilean Chardonnays are increasingly popular too.

For a casual date night, rose's blush or pink tones bring to mind the colours of Valentine's Day, hearts and so on.

A sparkling rose can add some extra energy to your evening - and just popping the cork is an event you can enjoy together.

Finally, among red wines, Malbec is still the in thing, with deep, dark colours and flavours that are the perfect complement to a seductive evening meal by candlelight.

(default) 43 queries took 125 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `ck_posts`13133
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `ck_images`994
4SHOW FULL COLUMNS FROM `ck_post_comments`995
5SHOW FULL COLUMNS FROM `ck_contacts`14144
6SHOW FULL COLUMNS FROM `ck_redirects`553
7SELECT `Redirect`.`id`, `Redirect`.`from`, `Redirect`.`to`, `Redirect`.`count`, `Redirect`.`created` FROM `ck_redirects` AS `Redirect` WHERE `Redirect`.`from` = '/news/turn-up-the-romance-when-you-buy-wine-online' LIMIT 1000
8SHOW FULL COLUMNS FROM `ck_users`11114
9SELECT `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`.`slug` = 'turn-up-the-romance-when-you-buy-wine-online' AND `Post`.`status` = 'active' AND `Post`.`post_date` <= '2020-01-18 16:16:21' AND NOT (`Post`.`slug` = '') ORDER BY `Post`.`post_date` DESC, `Post`.`created` DESC LIMIT 1110
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` = 2576 110
11SELECT `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` = (215) 000
12SHOW FULL COLUMNS FROM `ck_baskets`773
13SHOW FULL COLUMNS FROM `ck_store_countries`11113
14SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
15SHOW FULL COLUMNS FROM `ck_delivery_methods`11113
16SHOW FULL COLUMNS FROM `ck_store_countries_delivery_methods`333
17SHOW FULL COLUMNS FROM `ck_basket_products`883
18SHOW FULL COLUMNS FROM `ck_products`22223
19SHOW FULL COLUMNS FROM `ck_regions`13133
20SHOW FULL COLUMNS FROM `ck_producers`663
21SHOW FULL COLUMNS FROM `ck_styles`10103
22SHOW FULL COLUMNS FROM `ck_bottles`553
23SHOW FULL COLUMNS FROM `ck_product_ratings`993
24SHOW FULL COLUMNS FROM `ck_store_customers`773
25SHOW FULL COLUMNS FROM `ck_store_customer_addresses`20203
26SHOW FULL COLUMNS FROM `ck_grapes`993
27SHOW FULL COLUMNS FROM `ck_grapes_products`333
28SHOW FULL COLUMNS FROM `ck_product_types`773
29SHOW FULL COLUMNS FROM `ck_product_types_products`334
30SHOW FULL COLUMNS FROM `ck_offers`773
31SHOW FULL COLUMNS FROM `ck_offers_products`333
32SELECT `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
33SELECT `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
34SELECT `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) 1026102636
35SELECT `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
36SELECT `Style`.`slug`, `Style`.`name` FROM `ck_styles` AS `Style` WHERE 1 = 1 880
37SHOW FULL COLUMNS FROM `ck_right_banners`774
38SELECT `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
39SHOW FULL COLUMNS FROM `ck_right_links`663
40SELECT `RightLink`.`id`, `RightLink`.`name`, `RightLink`.`url`, `RightLink`.`status`, `RightLink`.`created`, `RightLink`.`modified` FROM `ck_right_links` AS `RightLink` WHERE `RightLink`.`status` = 'active' 220
41SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_keywords' LIMIT 1110
42SELECT `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
43SELECT `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