Our Products

Filtered By:

  • Region > Upper Loire
Baron de L, Domaine Ladoucette

Baron de L, Domaine Ladoucette

Size: Bottle (75 cl)

£58.95
Sancerre Rouge Domaine Daulny

Sancerre Rouge Domaine Daulny

Size: Bottle (75 cl)

Produced from Pinot Noir this wine is beginning to open up and show lovely strawberry aromas, with some black cherry character from just 6 months oak ageing. The palate has fabulous flavours of crushed raspberries.

£16.95
Pouilly Fumé de Ladoucette

Pouilly Fumé de Ladoucette

Size: Bottle (75 cl)

The Ladoucette flagship Pouilly-Fume, presents the nose with gooseberry, cassis, peach, lime and positively sneeze-inducing pungency of lavender and catnip. As is always the case, at its best this wine achieves a superb combination of textural richness and ripe fruit with pungent herbal-...

£27.95
Sancerre Rouge, Pascal Jolivet

Sancerre Rouge, Pascal Jolivet

Size: Bottle (75 cl)

Made from 100% Pinot Noir, this is a light red with a succulent depth and elegance. Red fruit aromas; quite soft and fruity in the mouth.

£21.95
Pouilly Fumé Domaine Fines Caillottes, Pabiot

Pouilly Fumé Domaine Fines Caillottes, Pabiot

Size: Bottle (75 cl)

Jean Pabiot's showcase domaine comprises vineyards at several favoured lieux dits (sites). Complex and refreshing, with aromas of grass, gooseberry and flint, this is the accompaniment par excellence to seafood, goat's cheese and summer salads.

£16.95
Pouilly Fumé, Château de Tracy

Pouilly Fumé, Château de Tracy

Size: Bottle (75 cl)

Only grapes grown on the estate are used. The wine in matured on its lees for longer than usual and is richer and more complex with greater length on the palate. Fruity, crisp Sauvignon fruit is dominant in this dry wine with smoky, gunflint notes.

£22.95
Sancerre Les Merisiere, Jean Pabiot

Sancerre Les Merisiere, Jean Pabiot

Size: Bottle (75 cl)

From the home of the Sauvignon grape comes this splendid wine which embodies everything the region and the fruit has become renowned for. It simply mirrors the beauty of the region.

£16.95
Pouilly Fumé Pascal Jolivet

Pouilly Fumé Pascal Jolivet

Size: Bottle (75 cl)

Pascal Jolivet blends his Pouilly Fume from vines grown on different types of soil giving the wine a terrific balance and depth but with that smoky richness that characterises Pouilly Fume. Softer, fuller fruit than Sancerre.

£18.95
Sancerre Pascal Jolivet

Sancerre Pascal Jolivet

Size: Bottle (75 cl)

Jolivet blends cuvees grown on different terroirs to produce a wine of great complexity. Dry and elegant with good strength in the nose and crisp fruit on the plate. The finish is long and clean.

£18.95
Sancerre Rosé Domaine Daulny

Sancerre Rosé Domaine Daulny

Size: Bottle (75 cl)

Made from the Pinot Noir grape by Etienne Daulny. Pale salmon in colour and with enough freshness and bite to it to go with fattier dishes like pork. Delicate wine with a lovely salmon-pink colour, delicate strawberry and floral aromas and packed with glorious summer fruit flavours.

£15.99
  • Pages
  • 1 | 2
(default) 61 queries took 40 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `ck_products`22220
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
4SHOW FULL COLUMNS FROM `ck_images`990
5SHOW FULL COLUMNS FROM `ck_regions`13130
6SHOW FULL COLUMNS FROM `ck_producers`660
7SHOW FULL COLUMNS FROM `ck_styles`10100
8SHOW FULL COLUMNS FROM `ck_bottles`550
9SHOW FULL COLUMNS FROM `ck_product_ratings`990
10SHOW FULL COLUMNS FROM `ck_store_customers`770
11SHOW FULL COLUMNS FROM `ck_users`11110
12SHOW FULL COLUMNS FROM `ck_contacts`14140
13SHOW FULL COLUMNS FROM `ck_store_customer_addresses`20200
14SHOW FULL COLUMNS FROM `ck_store_countries`11110
15SHOW FULL COLUMNS FROM `ck_grapes`990
16SHOW FULL COLUMNS FROM `ck_grapes_products`330
17SHOW FULL COLUMNS FROM `ck_product_types`770
18SHOW FULL COLUMNS FROM `ck_product_types_products`330
19SHOW FULL COLUMNS FROM `ck_offers`770
20SHOW FULL COLUMNS FROM `ck_offers_products`330
21SHOW FULL COLUMNS FROM `ck_redirects`550
22SELECT `Redirect`.`id`, `Redirect`.`from`, `Redirect`.`to`, `Redirect`.`count`, `Redirect`.`created` FROM `ck_redirects` AS `Redirect` WHERE `Redirect`.`from` = '/region/upper-loire' 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` = 'upper-loire' 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` = (41) 13131
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` = 'upper-loire' 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` = 'upper-loire' 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` = 'upper-loire' 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` = (41) 13131
33SELECT `Region`.`lft`, `Region`.`rght`, `Region`.`id` FROM `ck_regions` AS `Region` WHERE `Region`.`id` = 41 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` <= 158 AND `Region`.`rght` >= 159 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` = 41 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` < 159 AND `Region`.`lft` > 158 ORDER BY `Region`.`order` ASC 000
37SHOW FULL COLUMNS FROM `ck_settings`440
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` = (41) 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` = (41) AND `Product`.`status` = 'active' ORDER BY `Product`.`stock` DESC LIMIT 1010103
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 (3174, 2086, 3171, 3172, 1499, 236, 2857, 3173, 2858, 2087) 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 (3174, 2086, 3171, 3172, 1499, 236, 2857, 3173, 2858, 2087) AND `GrapesProduct`.`grape_id` = `Grape`.`id`) 10100
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 (3174, 2086, 3171, 3172, 1499, 236, 2857, 3173, 2858, 2087) 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 (3174, 2086, 3171, 3172, 1499, 236, 2857, 3173, 2858, 2087) AND `OffersProduct`.`offer_id` = `Offer`.`id`) 110
45SHOW FULL COLUMNS FROM `ck_baskets`770
46SHOW FULL COLUMNS FROM `ck_delivery_methods`11110
47SHOW FULL COLUMNS FROM `ck_store_countries_delivery_methods`330
48SHOW FULL COLUMNS FROM `ck_basket_products`880
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) 1026102633
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`770
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`660
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_description' LIMIT 1110
59SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_keywords' LIMIT 1110
60SELECT `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
61SELECT `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