Site Map

Pages

News Articles

Regions

Styles

Grapes

Products

Events

Warning (2): Invalid argument supplied for foreach() [CORE/cakebase/views/helpers/navigation.php, line 49]
    (default) 31 queries took 42 ms
    NrQueryErrorAffectedNum. rowsTook (ms)
    1SHOW FULL COLUMNS FROM `ck_pages`14141
    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` = '/sitemap' LIMIT 1000
    4SELECT `Page`.`title`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`id`, `Page`.`modified`, `Page`.`created` FROM `ck_pages` AS `Page` WHERE `Page`.`status` = 'active' AND NOT (`Page`.`slug` = '') ORDER BY `Page`.`order` ASC 14140
    5SHOW FULL COLUMNS FROM `ck_posts`13130
    6SHOW FULL COLUMNS FROM `ck_post_comments`990
    7SELECT `Post`.`title`, `Post`.`slug`, `Post`.`modified`, `Post`.`created`, `Post`.`id` 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-05-28 04:48:26' AND NOT (`Post`.`slug` = '') ORDER BY `Post`.`post_date` DESC, `Post`.`created` DESC 2262261
    8SELECT `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, 274, 273, 272, 271, 270, 269, 268, 267, 266, 265, 264, 263, 262, 261, 260, 259, 258, 257, 256, 255, 254, 253, 252, 251, 250, 249, 248, 247, 246, 245, 244, 243, 242, 241, 240, 239, 238, 237, 236, 235, 234, 233, 232, 231, 230, 229, 228, 227, 226, 225, 224, 223, 222, 221, 220, 219, 218, 217, 216, 215, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199, 198, 197, 196, 195, 194, 193, 192, 191, 190, 189, 188, 187, 186, 185, 184, 183, 182, 181, 180, 179, 178, 177, 176, 175, 174, 173, 172, 171, 170, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 142, 141, 140, 139, 138, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 114, 113, 112, 111, 110, 109, 108, 107, 106, 105, 104, 103, 102, 101, 100, 99, 98, 97, 96, 95, 94, 93, 92, 91, 90, 89, 88, 87, 86, 85, 84, 83, 82, 81, 80, 79, 78, 77, 76, 75, 74, 73, 72, 71, 70, 69, 68, 67, 66, 65, 64, 63, 62, 61, 60, 59, 57) 000
    9SELECT `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 1211211
    10SELECT `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
    11SELECT `Style`.`name`, `Style`.`slug`, `Style`.`modified`, `Style`.`created` FROM `ck_styles` AS `Style` WHERE NOT (`Style`.`slug` = '') 880
    12SELECT `Grape`.`name`, `Grape`.`slug`, `Grape`.`modified`, `Grape`.`created` FROM `ck_grapes` AS `Grape` WHERE NOT (`Grape`.`slug` = '') 1591590
    13SELECT `Product`.`name`, `Product`.`slug`, `Product`.`modified`, `Product`.`created`, `Product`.`id` 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`.`status` = 'active' AND NOT (`Product`.`slug` = '') 3453452
    14SELECT `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 (3121, 2939, 2944, 2846, 3085, 3094, 3095, 2933, 2790, 2932, 2833, 2834, 2952, 2960, 2959, 2955, 3077, 3120, 3093, 3102, 1789, 2554, 2555, 2556, 2557, 2558, 2559, 2560, 2811, 432, 3237, 2716, 434, 437, 433, 3240, 3228, 3238, 3239, 3221, 3222, 3303, 3298, 3299, 436, 3223, 3224, 3210, 2812, 2656, 2655, 487, 1779, 2449, 2896, 2691, 3125, 3129, 3128, 2692, 2766, 1781, 201, 1837, 2468, 153, 3137, 1746, 3138, 1301, 2507, 147, 3135, 148, 2482, 159, 2761, 2809, 2859, 2860, 2892, 2776, 3134, 2818, 2835, 1710, 2856, 167, 2804, 2805, 173, 165, 2, 2098, 3151, 2893, 3150, 2548, 2736, 2847, 2800, 2848, 13, 14, 2514, 15, 20, 7, 2451, 21, 2726, 2737, 2143, 33, 34, 3147, 3148, 2727, 2916, 2823, 2914, 2582, 2915, 2913, 2824, 2481, 2028, 579, 1758, 578, 605, 2464, 1648, 2029, 604, 2417, 1108, 2102, 1107, 2165, 2103, 2588, 1104, 1106, 2027, 3177, 2760, 2511, 2527, 3176, 2731, 1697, 1432, 2729, 2405, 2450, 2801, 3178, 3179, 2410, 2902, 2897, 1584, 3189, 1615, 2749, 1716, 2750, 2877, 3316, 2693, 3181, 2898, 3314, 2899, 2900, 3315, 3313, 3188, 3186, 1751, 3185, 1750, 3187, 1749, 2670, 1717, 2435, 2467, 2488, 2403, 2861, 2420, 2747, 2746, 3174, 2086, 3171, 3172, 1499, 236, 2857, 3173, 2858, 2087, 240, 1649, 528, 516, 2819, 513, 512, 2820, 527, 529, 2905, 2780, 2781, 2890, 524, 2909, 2907, 3310, 2064, 2908, 2782, 2910, 327, 1306, 3279, 2320, 3166, 3165, 3164, 1066, 2739, 2421, 3201, 3200, 1802, 1804, 1807, 1803, 2870, 2871, 2872, 2784, 630, 631, 2783, 2419, 629, 2589, 3203, 2535, 2717, 2719, 2533, 2590, 345, 3255, 2512, 2329, 3247, 3242, 2408, 2094, 3260, 381, 2510, 1838, 1988, 49, 3160, 2456, 3158, 56, 1987, 2891, 3155, 1753, 6003, 6006, 6008, 6009, 6010, 6011, 9121, 9135, 9149, 9162, 9168, 9169, 9176, 9183, 9184, 9186, 9187, 9189, 9191, 9204, 9205, 9208, 9209, 9210, 9213, 9220, 9224, 9225, 9232, 9233, 9236, 9237, 9261, 9250, 9254, 9255, 9256, 9257, 9258, 9259, 9260, 9262, 9263, 9264, 9265, 9266, 9267, 9268, 9269, 9270, 9271, 9272, 9273, 9274, 9275, 9276, 9277, 9278, 9279, 9280, 9281, 9282, 9283, 9284) 110
    15SELECT `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 (3121, 2939, 2944, 2846, 3085, 3094, 3095, 2933, 2790, 2932, 2833, 2834, 2952, 2960, 2959, 2955, 3077, 3120, 3093, 3102, 1789, 2554, 2555, 2556, 2557, 2558, 2559, 2560, 2811, 432, 3237, 2716, 434, 437, 433, 3240, 3228, 3238, 3239, 3221, 3222, 3303, 3298, 3299, 436, 3223, 3224, 3210, 2812, 2656, 2655, 487, 1779, 2449, 2896, 2691, 3125, 3129, 3128, 2692, 2766, 1781, 201, 1837, 2468, 153, 3137, 1746, 3138, 1301, 2507, 147, 3135, 148, 2482, 159, 2761, 2809, 2859, 2860, 2892, 2776, 3134, 2818, 2835, 1710, 2856, 167, 2804, 2805, 173, 165, 2, 2098, 3151, 2893, 3150, 2548, 2736, 2847, 2800, 2848, 13, 14, 2514, 15, 20, 7, 2451, 21, 2726, 2737, 2143, 33, 34, 3147, 3148, 2727, 2916, 2823, 2914, 2582, 2915, 2913, 2824, 2481, 2028, 579, 1758, 578, 605, 2464, 1648, 2029, 604, 2417, 1108, 2102, 1107, 2165, 2103, 2588, 1104, 1106, 2027, 3177, 2760, 2511, 2527, 3176, 2731, 1697, 1432, 2729, 2405, 2450, 2801, 3178, 3179, 2410, 2902, 2897, 1584, 3189, 1615, 2749, 1716, 2750, 2877, 3316, 2693, 3181, 2898, 3314, 2899, 2900, 3315, 3313, 3188, 3186, 1751, 3185, 1750, 3187, 1749, 2670, 1717, 2435, 2467, 2488, 2403, 2861, 2420, 2747, 2746, 3174, 2086, 3171, 3172, 1499, 236, 2857, 3173, 2858, 2087, 240, 1649, 528, 516, 2819, 513, 512, 2820, 527, 529, 2905, 2780, 2781, 2890, 524, 2909, 2907, 3310, 2064, 2908, 2782, 2910, 327, 1306, 3279, 2320, 3166, 3165, 3164, 1066, 2739, 2421, 3201, 3200, 1802, 1804, 1807, 1803, 2870, 2871, 2872, 2784, 630, 631, 2783, 2419, 629, 2589, 3203, 2535, 2717, 2719, 2533, 2590, 345, 3255, 2512, 2329, 3247, 3242, 2408, 2094, 3260, 381, 2510, 1838, 1988, 49, 3160, 2456, 3158, 56, 1987, 2891, 3155, 1753, 6003, 6006, 6008, 6009, 6010, 6011, 9121, 9135, 9149, 9162, 9168, 9169, 9176, 9183, 9184, 9186, 9187, 9189, 9191, 9204, 9205, 9208, 9209, 9210, 9213, 9220, 9224, 9225, 9232, 9233, 9236, 9237, 9261, 9250, 9254, 9255, 9256, 9257, 9258, 9259, 9260, 9262, 9263, 9264, 9265, 9266, 9267, 9268, 9269, 9270, 9271, 9272, 9273, 9274, 9275, 9276, 9277, 9278, 9279, 9280, 9281, 9282, 9283, 9284) AND `GrapesProduct`.`grape_id` = `Grape`.`id`) 5085082
    16SELECT `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 (3121, 2939, 2944, 2846, 3085, 3094, 3095, 2933, 2790, 2932, 2833, 2834, 2952, 2960, 2959, 2955, 3077, 3120, 3093, 3102, 1789, 2554, 2555, 2556, 2557, 2558, 2559, 2560, 2811, 432, 3237, 2716, 434, 437, 433, 3240, 3228, 3238, 3239, 3221, 3222, 3303, 3298, 3299, 436, 3223, 3224, 3210, 2812, 2656, 2655, 487, 1779, 2449, 2896, 2691, 3125, 3129, 3128, 2692, 2766, 1781, 201, 1837, 2468, 153, 3137, 1746, 3138, 1301, 2507, 147, 3135, 148, 2482, 159, 2761, 2809, 2859, 2860, 2892, 2776, 3134, 2818, 2835, 1710, 2856, 167, 2804, 2805, 173, 165, 2, 2098, 3151, 2893, 3150, 2548, 2736, 2847, 2800, 2848, 13, 14, 2514, 15, 20, 7, 2451, 21, 2726, 2737, 2143, 33, 34, 3147, 3148, 2727, 2916, 2823, 2914, 2582, 2915, 2913, 2824, 2481, 2028, 579, 1758, 578, 605, 2464, 1648, 2029, 604, 2417, 1108, 2102, 1107, 2165, 2103, 2588, 1104, 1106, 2027, 3177, 2760, 2511, 2527, 3176, 2731, 1697, 1432, 2729, 2405, 2450, 2801, 3178, 3179, 2410, 2902, 2897, 1584, 3189, 1615, 2749, 1716, 2750, 2877, 3316, 2693, 3181, 2898, 3314, 2899, 2900, 3315, 3313, 3188, 3186, 1751, 3185, 1750, 3187, 1749, 2670, 1717, 2435, 2467, 2488, 2403, 2861, 2420, 2747, 2746, 3174, 2086, 3171, 3172, 1499, 236, 2857, 3173, 2858, 2087, 240, 1649, 528, 516, 2819, 513, 512, 2820, 527, 529, 2905, 2780, 2781, 2890, 524, 2909, 2907, 3310, 2064, 2908, 2782, 2910, 327, 1306, 3279, 2320, 3166, 3165, 3164, 1066, 2739, 2421, 3201, 3200, 1802, 1804, 1807, 1803, 2870, 2871, 2872, 2784, 630, 631, 2783, 2419, 629, 2589, 3203, 2535, 2717, 2719, 2533, 2590, 345, 3255, 2512, 2329, 3247, 3242, 2408, 2094, 3260, 381, 2510, 1838, 1988, 49, 3160, 2456, 3158, 56, 1987, 2891, 3155, 1753, 6003, 6006, 6008, 6009, 6010, 6011, 9121, 9135, 9149, 9162, 9168, 9169, 9176, 9183, 9184, 9186, 9187, 9189, 9191, 9204, 9205, 9208, 9209, 9210, 9213, 9220, 9224, 9225, 9232, 9233, 9236, 9237, 9261, 9250, 9254, 9255, 9256, 9257, 9258, 9259, 9260, 9262, 9263, 9264, 9265, 9266, 9267, 9268, 9269, 9270, 9271, 9272, 9273, 9274, 9275, 9276, 9277, 9278, 9279, 9280, 9281, 9282, 9283, 9284) AND `ProductTypesProduct`.`product_type_id` = `ProductType`.`id`) 110
    17SELECT `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 (3121, 2939, 2944, 2846, 3085, 3094, 3095, 2933, 2790, 2932, 2833, 2834, 2952, 2960, 2959, 2955, 3077, 3120, 3093, 3102, 1789, 2554, 2555, 2556, 2557, 2558, 2559, 2560, 2811, 432, 3237, 2716, 434, 437, 433, 3240, 3228, 3238, 3239, 3221, 3222, 3303, 3298, 3299, 436, 3223, 3224, 3210, 2812, 2656, 2655, 487, 1779, 2449, 2896, 2691, 3125, 3129, 3128, 2692, 2766, 1781, 201, 1837, 2468, 153, 3137, 1746, 3138, 1301, 2507, 147, 3135, 148, 2482, 159, 2761, 2809, 2859, 2860, 2892, 2776, 3134, 2818, 2835, 1710, 2856, 167, 2804, 2805, 173, 165, 2, 2098, 3151, 2893, 3150, 2548, 2736, 2847, 2800, 2848, 13, 14, 2514, 15, 20, 7, 2451, 21, 2726, 2737, 2143, 33, 34, 3147, 3148, 2727, 2916, 2823, 2914, 2582, 2915, 2913, 2824, 2481, 2028, 579, 1758, 578, 605, 2464, 1648, 2029, 604, 2417, 1108, 2102, 1107, 2165, 2103, 2588, 1104, 1106, 2027, 3177, 2760, 2511, 2527, 3176, 2731, 1697, 1432, 2729, 2405, 2450, 2801, 3178, 3179, 2410, 2902, 2897, 1584, 3189, 1615, 2749, 1716, 2750, 2877, 3316, 2693, 3181, 2898, 3314, 2899, 2900, 3315, 3313, 3188, 3186, 1751, 3185, 1750, 3187, 1749, 2670, 1717, 2435, 2467, 2488, 2403, 2861, 2420, 2747, 2746, 3174, 2086, 3171, 3172, 1499, 236, 2857, 3173, 2858, 2087, 240, 1649, 528, 516, 2819, 513, 512, 2820, 527, 529, 2905, 2780, 2781, 2890, 524, 2909, 2907, 3310, 2064, 2908, 2782, 2910, 327, 1306, 3279, 2320, 3166, 3165, 3164, 1066, 2739, 2421, 3201, 3200, 1802, 1804, 1807, 1803, 2870, 2871, 2872, 2784, 630, 631, 2783, 2419, 629, 2589, 3203, 2535, 2717, 2719, 2533, 2590, 345, 3255, 2512, 2329, 3247, 3242, 2408, 2094, 3260, 381, 2510, 1838, 1988, 49, 3160, 2456, 3158, 56, 1987, 2891, 3155, 1753, 6003, 6006, 6008, 6009, 6010, 6011, 9121, 9135, 9149, 9162, 9168, 9169, 9176, 9183, 9184, 9186, 9187, 9189, 9191, 9204, 9205, 9208, 9209, 9210, 9213, 9220, 9224, 9225, 9232, 9233, 9236, 9237, 9261, 9250, 9254, 9255, 9256, 9257, 9258, 9259, 9260, 9262, 9263, 9264, 9265, 9266, 9267, 9268, 9269, 9270, 9271, 9272, 9273, 9274, 9275, 9276, 9277, 9278, 9279, 9280, 9281, 9282, 9283, 9284) AND `OffersProduct`.`offer_id` = `Offer`.`id`) 60601
    18SHOW FULL COLUMNS FROM `ck_events`990
    19SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
    20SHOW FULL COLUMNS FROM `ck_stores`880
    21SELECT `Event`.`name`, `Event`.`slug`, `Event`.`modified`, `Event`.`created` FROM `ck_events` AS `Event` LEFT JOIN `ck_stores` AS `Store` ON (`Event`.`store_id` = `Store`.`id`) WHERE `Event`.`status` = 'active' AND NOT (`Event`.`slug` = '') ORDER BY `Event`.`event_date` ASC 000
    22SELECT `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
    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`.`status` = 'active' AND NOT (`Region`.`slug` = '') ORDER BY `Region`.`order` ASC 1211211
    24SELECT `Style`.`slug`, `Style`.`name` FROM `ck_styles` AS `Style` WHERE 1 = 1 880
    25SELECT `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
    26SELECT `RightLink`.`id`, `RightLink`.`name`, `RightLink`.`url`, `RightLink`.`status`, `RightLink`.`created`, `RightLink`.`modified` FROM `ck_right_links` AS `RightLink` WHERE `RightLink`.`status` = 'active' 220
    27SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_description' LIMIT 1110
    28SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_keywords' LIMIT 1110
    29SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`modified` FROM `ck_settings` AS `Setting` WHERE `Setting`.`key` = 'meta_title' LIMIT 1110
    30SELECT `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
    31SELECT `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