Shop

Products

Sugaronline Conference Papers (Complete Package with DVD)

Price from $400.00

New this year watch the conference on DVD!

More Details Add to cart Buy now

Sugaronline Conference Papers (Individual Presentation)

Price from $50.00

Please let us know which one you want in the comments box on the check out page.

More Details Add to cart Buy now

Sugaronline Conference Papers (Complete Papers)

Price from $350.00

More Details Add to cart Buy now

(default) 56 queries took 169 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `shop_categories`12124
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';114
3SHOW FULL COLUMNS FROM `shop_access_levels`554
4SHOW FULL COLUMNS FROM `website_access_levels`334
5SHOW FULL COLUMNS FROM `website_contents`35356
6SHOW FULL COLUMNS FROM `website_content_types`664
7SHOW FULL COLUMNS FROM `website_top_categories`10105
8SHOW FULL COLUMNS FROM `website_top_category_types`226
9SHOW FULL COLUMNS FROM `website_categories`335
10SHOW FULL COLUMNS FROM `website_categories_website_contents`224
11SHOW FULL COLUMNS FROM `website_categories_website_top_categories`228
12SHOW FULL COLUMNS FROM `countries`17174
13SHOW FULL COLUMNS FROM `people`94947
14SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
15SHOW FULL COLUMNS FROM `user_types`11114
16SHOW FULL COLUMNS FROM `person_shop_products`884
17SHOW FULL COLUMNS FROM `shop_orders`23236
18SHOW FULL COLUMNS FROM `payment_methods`224
19SHOW FULL COLUMNS FROM `shop_order_statuses`225
20SHOW FULL COLUMNS FROM `discounts`665
21SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';114
22SHOW FULL COLUMNS FROM `logins`443
23SHOW FULL COLUMNS FROM `interests`335
24SHOW FULL COLUMNS FROM `interest_groups`225
25SHOW FULL COLUMNS FROM `interests_people`335
26SHOW FULL COLUMNS FROM `people_shop_categories`226
27SHOW FULL COLUMNS FROM `shop_ordered_products`774
28SHOW FULL COLUMNS FROM `shop_products`27276
29SHOW FULL COLUMNS FROM `shop_pricing_units`334
30SHOW FULL COLUMNS FROM `shop_access_levels_shop_products`334
31SHOW FULL COLUMNS FROM `shop_addon_products`226
32SHOW FULL COLUMNS FROM `shop_sub_products`447
33SHOW FULL COLUMNS FROM `your_menu_items`554
34SHOW FULL COLUMNS FROM `configuration`554
35SELECT `Country`.`id`, `Country`.`name`, `Country`.`iso_code`, `Country`.`gmt_offset`, `Country`.`int_dial_code`, `Country`.`is_domicile_country`, `Country`.`is_origin_country`, `Country`.`is_destination_country`, `Country`.`is_trading_country`, `Country`.`name_fr`, `Country`.`name_es`, `Country`.`name_pt`, `Country`.`name_de`, `Country`.`name_cn`, `Country`.`name_th`, `Country`.`name_ru`, `Country`.`tax_rate` FROM `countries` AS `Country` WHERE `Country`.`id` = 270 LIMIT 1110
36SELECT `ShopAccessLevel`.`id`, `ShopAccessLevel`.`name`, `ShopAccessLevel`.`description`, `ShopAccessLevel`.`price`, `ShopAccessLevel`.`visible` FROM `shop_access_levels` AS `ShopAccessLevel` WHERE `ShopAccessLevel`.`id` = 1 LIMIT 1110
37SELECT `WebsiteAccessLevel`.`id`, `WebsiteAccessLevel`.`name`, `WebsiteAccessLevel`.`shop_access_level_id` FROM `website_access_levels` AS `WebsiteAccessLevel` WHERE `WebsiteAccessLevel`.`id` = 1 LIMIT 1110
38SELECT `Configuration`.`id`, `Configuration`.`name`, `Configuration`.`value`, `Configuration`.`input_type`, `Configuration`.`cronjob` FROM `configuration` AS `Configuration` WHERE 1 = 1 16160
39SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`in_footer` = 1 AND `WebsiteContent`.`visible` = 1 440
40SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`subscription_type` = 1 AND `WebsiteContent`.`visible` = 1 ORDER BY IF(name = 'Compare Levels', 1, 0) ASC, id ASC 440
41SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`information` = 1 AND `WebsiteContent`.`visible` = 1 440
42SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`service` = 1 AND `WebsiteContent`.`visible` = 1 330
43SHOW FULL COLUMNS FROM `settlement_prices`32324
44SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '5' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
45SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '11' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
46SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '16' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
47SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '5' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
48SELECT `SettlementPrice`.`id`, `SettlementPrice`.`date`, `SettlementPrice`.`month_1`, `SettlementPrice`.`month_2`, `SettlementPrice`.`month_3`, `SettlementPrice`.`month_4`, `SettlementPrice`.`month_5`, `SettlementPrice`.`market`, `SettlementPrice`.`entered_by`, `SettlementPrice`.`month`, `SettlementPrice`.`year`, `SettlementPrice`.`month_1_name`, `SettlementPrice`.`month_2_name`, `SettlementPrice`.`month_3_name`, `SettlementPrice`.`month_4_name`, `SettlementPrice`.`month_5_name`, `SettlementPrice`.`open_1`, `SettlementPrice`.`open_2`, `SettlementPrice`.`open_3`, `SettlementPrice`.`open_4`, `SettlementPrice`.`open_5`, `SettlementPrice`.`change_1`, `SettlementPrice`.`change_2`, `SettlementPrice`.`change_3`, `SettlementPrice`.`change_4`, `SettlementPrice`.`change_5`, `SettlementPrice`.`volume_1`, `SettlementPrice`.`volume_2`, `SettlementPrice`.`volume_3`, `SettlementPrice`.`volume_4`, `SettlementPrice`.`volume_5`, `SettlementPrice`.`visible` FROM `settlement_prices` AS `SettlementPrice` WHERE `SettlementPrice`.`market` = '11' ORDER BY `SettlementPrice`.`date` DESC LIMIT 1110
49SHOW FULL COLUMNS FROM `prices`24244
50SELECT `Price`.`id`, `Price`.`retrieved`, `Price`.`delay`, `Price`.`root`, `Price`.`symbol`, `Price`.`description`, `Price`.`month`, `Price`.`year`, `Price`.`recent`, `Price`.`change_open`, `Price`.`change_old_settle`, `Price`.`opening_price`, `Price`.`high`, `Price`.`low`, `Price`.`volume`, `Price`.`opening_interest`, `Price`.`exchange`, `Price`.`time`, `Price`.`entered_date`, `Price`.`person_id`, `Price`.`change`, `Price`.`total_volume`, `Price`.`new_settlement`, `Price`.`oldsettle` FROM `prices` AS `Price` WHERE `Price`.`root` = 'W-ICL' ORDER BY `Price`.`id` ASC LIMIT 20880
51SELECT `Price`.`id`, `Price`.`retrieved`, `Price`.`delay`, `Price`.`root`, `Price`.`symbol`, `Price`.`description`, `Price`.`month`, `Price`.`year`, `Price`.`recent`, `Price`.`change_open`, `Price`.`change_old_settle`, `Price`.`opening_price`, `Price`.`high`, `Price`.`low`, `Price`.`volume`, `Price`.`opening_interest`, `Price`.`exchange`, `Price`.`time`, `Price`.`entered_date`, `Price`.`person_id`, `Price`.`change`, `Price`.`total_volume`, `Price`.`new_settlement`, `Price`.`oldsettle` FROM `prices` AS `Price` WHERE `Price`.`root` = 'SB' ORDER BY `Price`.`id` ASC LIMIT 2012120
52SELECT `Price`.`id`, `Price`.`retrieved`, `Price`.`delay`, `Price`.`root`, `Price`.`symbol`, `Price`.`description`, `Price`.`month`, `Price`.`year`, `Price`.`recent`, `Price`.`change_open`, `Price`.`change_old_settle`, `Price`.`opening_price`, `Price`.`high`, `Price`.`low`, `Price`.`volume`, `Price`.`opening_interest`, `Price`.`exchange`, `Price`.`time`, `Price`.`entered_date`, `Price`.`person_id`, `Price`.`change`, `Price`.`total_volume`, `Price`.`new_settlement`, `Price`.`oldsettle` FROM `prices` AS `Price` WHERE `Price`.`root` = 'SFQ' ORDER BY `Price`.`id` ASC LIMIT 2011110
53SELECT `ShopCategory`.`id`, `ShopCategory`.`name`, `ShopCategory`.`description`, `ShopCategory`.`allow_multiple_items_in_basket`, `ShopCategory`.`visible`, `ShopCategory`.`parent_id`, `ShopCategory`.`available_as_email_alert`, `ShopCategory`.`full_months_only`, `ShopCategory`.`shop_access_level_id`, `ShopCategory`.`image_file`, `ShopCategory`.`lft`, `ShopCategory`.`rght` FROM `shop_categories` AS `ShopCategory` WHERE `ShopCategory`.`id` = 667 LIMIT 1110
54SELECT `ChildShopCategory`.`id`, `ChildShopCategory`.`name`, `ChildShopCategory`.`description`, `ChildShopCategory`.`allow_multiple_items_in_basket`, `ChildShopCategory`.`visible`, `ChildShopCategory`.`parent_id`, `ChildShopCategory`.`available_as_email_alert`, `ChildShopCategory`.`full_months_only`, `ChildShopCategory`.`shop_access_level_id`, `ChildShopCategory`.`image_file`, `ChildShopCategory`.`lft`, `ChildShopCategory`.`rght` FROM `shop_categories` AS `ChildShopCategory` WHERE `ChildShopCategory`.`parent_id` = (667) ORDER BY `ChildShopCategory`.`name` ASC 000
55SELECT `ShopProduct`.`id`, `ShopProduct`.`name`, `ShopProduct`.`featured`, `ShopProduct`.`feature_date`, `ShopProduct`.`feature_text`, `ShopProduct`.`image_filename`, `ShopProduct`.`short_description`, `ShopProduct`.`full_description`, `ShopProduct`.`tax_payable`, `ShopProduct`.`small_image_url`, `ShopProduct`.`big_image_url`, `ShopProduct`.`file_url`, `ShopProduct`.`active`, `ShopProduct`.`shop_category_id`, `ShopProduct`.`new_shop_access_level_id`, `ShopProduct`.`can_buy_separately`, `ShopProduct`.`default_quantity`, `ShopProduct`.`minimum_quantity`, `ShopProduct`.`can_change_quantity`, `ShopProduct`.`shop_pricing_unit_id`, `ShopProduct`.`can_pay_by_instalments`, `ShopProduct`.`sample_file_url`, `ShopProduct`.`available_as_email_alert`, `ShopProduct`.`created`, `ShopProduct`.`deleted`, `ShopProduct`.`quantity_must_not_exceed_subscription_length`, `ShopProduct`.`subscription` FROM `shop_products` AS `ShopProduct` WHERE ((`ShopProduct`.`can_buy_separately` = 1) AND (`ShopProduct`.`active` = 1) AND (`ShopProduct`.`deleted` = 0)) AND `ShopProduct`.`shop_category_id` = (667) ORDER BY `ShopProduct`.`created` DESC 330
56SELECT `ShopAccessLevel`.`id`, `ShopAccessLevel`.`name`, `ShopAccessLevel`.`description`, `ShopAccessLevel`.`price`, `ShopAccessLevel`.`visible`, `ShopAccessLevelsShopProduct`.`shop_product_id`, `ShopAccessLevelsShopProduct`.`shop_access_level_id`, `ShopAccessLevelsShopProduct`.`price` FROM `shop_access_levels` AS `ShopAccessLevel` JOIN `shop_access_levels_shop_products` AS `ShopAccessLevelsShopProduct` ON (`ShopAccessLevelsShopProduct`.`shop_product_id` IN (49650, 49649, 49648) AND `ShopAccessLevelsShopProduct`.`shop_access_level_id` = `ShopAccessLevel`.`id`) ORDER BY `ShopAccessLevelsShopProduct`.`price` ASC 12120