Our Products

Filtered By:

  • Region > South West
Plenitude

Plenitude

Size: Bottle (75 cl)

Maturing rustic notes v lightly stalky v rich black fruits; big structured tannins with appealing textured savoury fruit carrying through onto the finish.

£21.95
Madiran Viella Village

Madiran Viella Village

Size: Bottle (75 cl)

This wine from Chateau Viella is a blend of 80% Tannat and 20% Cabernet using only very ripe bunches. This tannins are very soft and mature, full-bodied with harmonious use of wood. Not for the faint-hearted.

£17.99
Château de Sabazan, Côtes de St Mont

Château de Sabazan, Côtes de St Mont

Size: Bottle (75 cl)

The vineyards occupy 16 hectares in the village of Sabazan. Made from the Tannat grape and matured in oak barrels for 11-14 months. The wine is deep garnet in colour and the nose is intense with hints of stewed prunes, cherries and blackberries.

£16.95
Le Faite Red

Le Faite Red

Size: Bottle (75 cl)

Nice mix of concentrated fruit - black cherry and liquorice - and a layer of oak; tight structure and bite sweetened by the fruit and oak, well balanced despite the dry tannins and power

£21.95
Cepage Colombard, Plaimont

Cepage Colombard, Plaimont

Size: Bottle (75 cl)

Under the direction of Andre Dubosc, some scintillating white wines have been making big waves in the wine world. The vines are pruned to give low yields and result in more intense fruit flavours.

£6.99
Côtes de St Mont Rosé, Plaimont

Côtes de St Mont Rosé, Plaimont

Size: Bottle (75 cl)

State of the art winery in the heart of Gascogny has produced this Gold Medal-winning wine. The red grapes undergo a very mild crushing allowing a clean blush coloured extraction. Skins and stalks are discarded immediately. The result is an exuberant, perfectly crafted wine which is dry but...

£7.95
Le Faite White, Plaimont

Le Faite White, Plaimont

Size: Bottle (75 cl)

Very limited production, absolutely gorgeous. Arrufiac, Petit Courbu and Gros Manseng grapes. Bottle has old-style wooden label sealed with wax. The Plaimont co-op's perfumed white flagship has the elegant balance of minerality, ripe fruit and zippy acidity.

£18.95
Merlot Tannat, Plaimont

Merlot Tannat, Plaimont

Size: Bottle (75 cl)

Deeply coloured, well made and well balanced wine. The Merlot offers the flesh and fruit and the Tannat the framework and structure. The Tannat grape has been spoken of as one of the most healthy red grapes because it generally undergoes a lengthy fermentation and - probably in consequence -...

£6.99
Sauvignon VdP Gascogne, Plaimont

Sauvignon VdP Gascogne, Plaimont

Size: Bottle (75 cl)

Fruity nose with lots of gooseberry character. Palate is crisp, medium weight and refreshing. A very easy drinking style to drink on its own or with light salads and seafood.

£7.49
£8.95
  • Pages
(default) 60 queries took 140 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `ck_products`22224
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
4SHOW FULL COLUMNS FROM `ck_images`993
5SHOW FULL COLUMNS FROM `ck_regions`13133
6SHOW FULL COLUMNS FROM `ck_producers`663
7SHOW FULL COLUMNS FROM `ck_styles`10104
8SHOW FULL COLUMNS FROM `ck_bottles`554
9SHOW FULL COLUMNS FROM `ck_product_ratings`993
10SHOW FULL COLUMNS FROM `ck_store_customers`774
11SHOW FULL COLUMNS FROM `ck_users`11114
12SHOW FULL COLUMNS FROM `ck_contacts`14144
13SHOW FULL COLUMNS FROM `ck_store_customer_addresses`20204
14SHOW FULL COLUMNS FROM `ck_store_countries`11114
15SHOW FULL COLUMNS FROM `ck_grapes`994
16SHOW FULL COLUMNS FROM `ck_grapes_products`333
17SHOW FULL COLUMNS FROM `ck_product_types`773
18SHOW FULL COLUMNS FROM `ck_product_types_products`334
19SHOW FULL COLUMNS FROM `ck_offers`773
20SHOW FULL COLUMNS FROM `ck_offers_products`333
21SHOW FULL COLUMNS FROM `ck_redirects`555
22SELECT `Redirect`.`id`, `Redirect`.`from`, `Redirect`.`to`, `Redirect`.`count`, `Redirect`.`created` FROM `ck_redirects` AS `Redirect` WHERE `Redirect`.`from` = '/region/south-west' LIMIT 1000
23SELECT `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`.`slug` = 'south-west' ORDER BY `Region`.`order` ASC LIMIT 1110
24SELECT `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` = (67) 15151
25SELECT `Grape`.`id`, `Grape`.`name`, `Grape`.`created`, `Grape`.`modified`, `Grape`.`order`, `Grape`.`slug`, `Grape`.`meta_title`, `Grape`.`meta_description`, `Grape`.`meta_keywords` FROM `ck_grapes` AS `Grape` WHERE `Grape`.`slug` = 'south-west' LIMIT 1000
26SELECT `Style`.`name`, `Style`.`colour_id`, `Style`.`id`, `Style`.`created`, `Style`.`modified`, `Style`.`order`, `Style`.`slug`, `Style`.`meta_title`, `Style`.`meta_description`, `Style`.`meta_keywords` FROM `ck_styles` AS `Style` WHERE `Style`.`slug` = 'south-west' LIMIT 1000
27SELECT `Grape`.`id`, `Grape`.`name` FROM `ck_grapes` AS `Grape` WHERE NOT (`Grape`.`slug` = '') ORDER BY `Grape`.`name` ASC 1591590
28SELECT `Style`.`id`, `Style`.`name` FROM `ck_styles` AS `Style` WHERE NOT (`Style`.`slug` = '') ORDER BY `Style`.`name` ASC 880
29SELECT `ProductType`.`id`, `ProductType`.`name` FROM `ck_product_types` AS `ProductType` WHERE `ProductType`.`status` = 'active' AND NOT (`ProductType`.`slug` = '') ORDER BY `ProductType`.`name` ASC 110
30SELECT `Region`.`id`, `Region`.`name`, `Region`.`lft`, `Region`.`rght` FROM `ck_regions` AS `Region` WHERE 1 = 1 ORDER BY `Region`.`lft` asc 1261260
31SELECT `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`.`slug` = 'south-west' ORDER BY `Region`.`order` ASC LIMIT 1110
32SELECT `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` = (67) 15151
33SELECT `Region`.`lft`, `Region`.`rght`, `Region`.`id` FROM `ck_regions` AS `Region` WHERE `Region`.`id` = 67 ORDER BY `Region`.`order` ASC LIMIT 1110
34SELECT `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 ((1 = 1) AND (((`Region`.`status` = 'active') AND (NOT (`Region`.`slug` = ''))))) AND `Region`.`lft` <= 166 AND `Region`.`rght` >= 167 ORDER BY `Region`.`lft` asc 220
35SELECT `Region`.`lft`, `Region`.`rght` FROM `ck_regions` AS `Region` WHERE ((1 = 1) AND (((`Region`.`status` = 'active') AND (NOT (`Region`.`slug` = ''))))) AND `Region`.`id` = 67 ORDER BY `Region`.`order` ASC LIMIT 1110
36SELECT `Region`.`id` FROM `ck_regions` AS `Region` WHERE ((1 = 1) AND (((`Region`.`status` = 'active') AND (NOT (`Region`.`slug` = ''))))) AND `Region`.`rght` < 167 AND `Region`.`lft` > 166 ORDER BY `Region`.`order` ASC 000
37SHOW FULL COLUMNS FROM `ck_settings`443
38SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'prodperpage' LIMIT 1110
39SELECT COUNT(*) AS `count` 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 `Region`.`id` = (67) AND `Product`.`status` = 'active' 111
40SELECT `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 `Region`.`id` = (67) AND `Product`.`status` = 'active' ORDER BY `Product`.`stock` DESC LIMIT 1010102
41SELECT `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 (2731, 1697, 1432, 2729, 2405, 2450, 2801, 3178, 3179, 9191) 000
42SELECT `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 (2731, 1697, 1432, 2729, 2405, 2450, 2801, 3178, 3179, 9191) AND `GrapesProduct`.`grape_id` = `Grape`.`id`) 22220
43SELECT `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 (2731, 1697, 1432, 2729, 2405, 2450, 2801, 3178, 3179, 9191) AND `ProductTypesProduct`.`product_type_id` = `ProductType`.`id`) 000
44SELECT `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 (2731, 1697, 1432, 2729, 2405, 2450, 2801, 3178, 3179, 9191) AND `OffersProduct`.`offer_id` = `Offer`.`id`) 110
45SHOW FULL COLUMNS FROM `ck_baskets`775
46SHOW FULL COLUMNS FROM `ck_delivery_methods`11113
47SHOW FULL COLUMNS FROM `ck_store_countries_delivery_methods`334
48SHOW FULL COLUMNS FROM `ck_basket_products`884
49SELECT `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
50SELECT `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
51SELECT `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
52SELECT `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
53SELECT `Style`.`slug`, `Style`.`name` FROM `ck_styles` AS `Style` WHERE 1 = 1 880
54SHOW FULL COLUMNS FROM `ck_right_banners`773
55SELECT `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
56SHOW FULL COLUMNS FROM `ck_right_links`665
57SELECT `RightLink`.`id`, `RightLink`.`name`, `RightLink`.`url`, `RightLink`.`status`, `RightLink`.`created`, `RightLink`.`modified` FROM `ck_right_links` AS `RightLink` WHERE `RightLink`.`status` = 'active' 220
58SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_keywords' LIMIT 1111
59SELECT `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
60SELECT `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