Sugaronline Editorials

Frequency: Weekly

Subscription Level: SugaronlineSilver

The Friday Editorial - Each week Sugaronline presents articles of commentary and analysis that include interviews with key industry figures. Each series of articles explores different sugar regions around the world.
 


Sample Report
Click here to download this report.


:: Recent Reports

pdfSugaronline Editorial - Taking One for the Team By Meghan Sapp2015/04/17
pdfSugaronline Editorial - To GM or To Not GM, That is The Question By Meghan Sapp2015/04/13
pdfSugaronline Editorial - Back to the drawing board By Meghan Sapp2015/03/30
pdfSugaronline Editorial - The World, according to Cosan By Meghan Sapp2015/03/20
pdfSugaronline Editorial - Summer at the Lake By Meghan Sapp2015/03/16
pdfSugaronline Editorial - Play it again, Sam By Meghan Sapp2015/03/09
pdfSugaronline Editorial - How much are you worth? By Meghan Sapp2015/02/27
pdfSugaronline Editorial - Remember to set your stops By Meghan Sapp2015/02/23
pdfSugaronline Editorial - Just getting it done By Meghan Sapp2015/02/09
pdfSugaronline Editorial - Sitting on the edge of the precipice By Meghan Sapp2015/01/30
pdfSugaronline Editorial - Room for one more? By Meghan Sapp2015/01/23
pdfSugaronline Editorial - A House Divided By Meghan Sapp2015/01/16
pdfSugaronline Editorial - It ain’t over ‘til… By Meghan Sapp2015/01/12
pdfSugaronline Editorial - Putting Your Money Where Your Mouth Is By Meghan Sapp2014/12/12
pdfSugaronline Editorial - Feeling the Burn By Meghan Sapp2014/12/05
pdfSugaronline Editorial - The Problem with Bagasse By Meghan Sapp2014/11/28
pdfSugaronline Editorial - Making Sustainability Sustainable By Meghan Sapp2014/11/24
pdfSugaronline Editorial - The Game of Life vs. Monopoly By Meghan Sapp2014/11/14
pdfSugaronline Editorial - And then it got worse…Part Deux By Meghan Sapp2014/11/07
pdfSugaronline Editorial - And then it got worse… By Meghan Sapp2014/11/04
pdfSugaronline Editorial - Playing Nice By Meghan Sapp2014/10/27
pdfSugaronline Editorial - The End of the World as We Know It By Meghan Sapp2014/10/17
pdfSugaronline Editorial - The Art of Speaking from Both Sides of One’s Mouth By Meghan Sapp2014/10/10
pdfSugaronline Editorial - The Fighting Irish in Brussels By Meghan Sapp2014/10/03
pdfSugaronline Editorial - The Comeback Kid By Meghan Sapp2014/09/26
2 of 29

:: Settlement Prices

London No 5
(06/11/2015)
Symbol Last Chg Vol
Dec '5 385.80 -9.70 7548
Mar '6 393.80 -7.10 10095
May '6 395.70 -6.50 2304
Aug '6 395.60 -5.70 703
Oct '6 394.60 -4.80 99
New York No 11
(06/11/2015)
Symbol Last Chg Vol
Mar '6 14.46 -0.30 67962
May '6 14.13 -0.28 22222
Jul '6 13.88 -0.26 12513
Oct '6 13.94 -0.26 5477
Mar '7 14.36 -0.28 1991
New York No 16
(06/11/2015)
Symbol Last Chg Vol
Jan '6 25.45 -0.10 35
Mar '6 25.45 -0.09 62
May '6 25.45 0 50
Jul '6 25.45 -0.10 75
Sep '6 25.53 -0.02 75

(default) 60 queries took 215 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `website_contents`35355
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';113
3SHOW FULL COLUMNS FROM `website_access_levels`334
4SHOW FULL COLUMNS FROM `shop_access_levels`556
5SHOW FULL COLUMNS FROM `people`94947
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
7SHOW FULL COLUMNS FROM `countries`17174
8SHOW FULL COLUMNS FROM `user_types`11114
9SHOW FULL COLUMNS FROM `person_shop_products`884
10SHOW FULL COLUMNS FROM `shop_orders`23235
11SHOW FULL COLUMNS FROM `payment_methods`223
12SHOW FULL COLUMNS FROM `shop_order_statuses`224
13SHOW FULL COLUMNS FROM `discounts`664
14SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';113
15SHOW FULL COLUMNS FROM `logins`444
16SHOW FULL COLUMNS FROM `shop_categories`12124
17SHOW FULL COLUMNS FROM `shop_products`27274
18SHOW FULL COLUMNS FROM `shop_pricing_units`333
19SHOW FULL COLUMNS FROM `shop_ordered_products`774
20SHOW FULL COLUMNS FROM `shop_access_levels_shop_products`334
21SHOW FULL COLUMNS FROM `shop_addon_products`225
22SHOW FULL COLUMNS FROM `shop_sub_products`445
23SHOW FULL COLUMNS FROM `people_shop_categories`223
24SHOW FULL COLUMNS FROM `interests`333
25SHOW FULL COLUMNS FROM `interest_groups`225
26SHOW FULL COLUMNS FROM `interests_people`334
27SHOW FULL COLUMNS FROM `your_menu_items`553
28SHOW FULL COLUMNS FROM `website_content_types`666
29SHOW FULL COLUMNS FROM `website_top_categories`10104
30SHOW FULL COLUMNS FROM `website_top_category_types`224
31SHOW FULL COLUMNS FROM `website_categories`333
32SHOW FULL COLUMNS FROM `website_categories_website_contents`224
33SHOW FULL COLUMNS FROM `website_categories_website_top_categories`225
34SHOW FULL COLUMNS FROM `configuration`553
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 441
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 441
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`32325
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 `WebsiteContent`.`id`, `WebsiteContent`.`website_content_type_id`, `WebsiteContent`.`website_top_category_id`, `WebsiteContent`.`name`, `WebsiteContent`.`author`, `WebsiteContent`.`filename`, `WebsiteContent`.`related_url`, `WebsiteContent`.`download_url`, `WebsiteContent`.`created`, `WebsiteContent`.`short_description`, `WebsiteContent`.`long_description`, `WebsiteContent`.`website_access_level_id`, `WebsiteContent`.`email`, `WebsiteContent`.`featured`, `WebsiteContent`.`feature_date`, `WebsiteContent`.`feature_text`, `WebsiteContent`.`news_type_id`, `WebsiteContent`.`shop_category_id`, `WebsiteContent`.`import_news_id`, `WebsiteContent`.`hits`, `WebsiteContent`.`denials`, `WebsiteContent`.`image_filename`, `WebsiteContent`.`in_header`, `WebsiteContent`.`in_footer`, `WebsiteContent`.`subscription_type`, `WebsiteContent`.`service`, `WebsiteContent`.`information`, `WebsiteContent`.`is_link`, `WebsiteContent`.`links`, `WebsiteContent`.`active`, `WebsiteContent`.`travelling_trader`, `WebsiteContent`.`ebriefing`, `WebsiteContent`.`marketcenter_id`, `WebsiteContent`.`country_id`, `WebsiteContent`.`visible` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`website_content_type_id` = 1 AND `WebsiteContent`.`created` BETWEEN DATE_SUB(NOW(), INTERVAL 15 DAY) AND NOW() ORDER BY `WebsiteContent`.`created` DESC LIMIT 10001
54SELECT `WebsiteContent`.`id`, `WebsiteContent`.`website_content_type_id`, `WebsiteContent`.`website_top_category_id`, `WebsiteContent`.`name`, `WebsiteContent`.`author`, `WebsiteContent`.`filename`, `WebsiteContent`.`related_url`, `WebsiteContent`.`download_url`, `WebsiteContent`.`created`, `WebsiteContent`.`short_description`, `WebsiteContent`.`long_description`, `WebsiteContent`.`website_access_level_id`, `WebsiteContent`.`email`, `WebsiteContent`.`featured`, `WebsiteContent`.`feature_date`, `WebsiteContent`.`feature_text`, `WebsiteContent`.`news_type_id`, `WebsiteContent`.`shop_category_id`, `WebsiteContent`.`import_news_id`, `WebsiteContent`.`hits`, `WebsiteContent`.`denials`, `WebsiteContent`.`image_filename`, `WebsiteContent`.`in_header`, `WebsiteContent`.`in_footer`, `WebsiteContent`.`subscription_type`, `WebsiteContent`.`service`, `WebsiteContent`.`information`, `WebsiteContent`.`is_link`, `WebsiteContent`.`links`, `WebsiteContent`.`active`, `WebsiteContent`.`travelling_trader`, `WebsiteContent`.`ebriefing`, `WebsiteContent`.`marketcenter_id`, `WebsiteContent`.`country_id`, `WebsiteContent`.`visible` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`website_content_type_id` = 1 AND `WebsiteContent`.`created` BETWEEN DATE_SUB(NOW(), INTERVAL 15 DAY) AND NOW() ORDER BY `WebsiteContent`.`hits` DESC LIMIT 10001
55SELECT `WebsiteTopCategory`.`id`, `WebsiteTopCategory`.`website_top_category_type_id`, `WebsiteTopCategory`.`name`, `WebsiteTopCategory`.`default_website_content_id`, `WebsiteTopCategory`.`website_access_level_id`, `WebsiteTopCategory`.`shop_category_id`, `WebsiteTopCategory`.`blurb`, `WebsiteTopCategory`.`image_file`, `WebsiteTopCategory`.`sample_file`, `WebsiteTopCategory`.`visible`, `WebsiteAccessLevel`.`id`, `WebsiteAccessLevel`.`name`, `WebsiteAccessLevel`.`shop_access_level_id` FROM `website_top_categories` AS `WebsiteTopCategory` LEFT JOIN `website_access_levels` AS `WebsiteAccessLevel` ON (`WebsiteTopCategory`.`website_access_level_id` = `WebsiteAccessLevel`.`id`) WHERE `WebsiteTopCategory`.`visible` = 1 AND `WebsiteTopCategory`.`website_top_category_type_id` = 15 AND `WebsiteTopCategory`.`website_access_level_id` <= 1 ORDER BY `WebsiteTopCategory`.`name` ASC 110
56SELECT `WebsiteTopCategory`.`id`, `WebsiteTopCategory`.`website_top_category_type_id`, `WebsiteTopCategory`.`name`, `WebsiteTopCategory`.`default_website_content_id`, `WebsiteTopCategory`.`website_access_level_id`, `WebsiteTopCategory`.`shop_category_id`, `WebsiteTopCategory`.`blurb`, `WebsiteTopCategory`.`image_file`, `WebsiteTopCategory`.`sample_file`, `WebsiteTopCategory`.`visible`, `WebsiteAccessLevel`.`id`, `WebsiteAccessLevel`.`name`, `WebsiteAccessLevel`.`shop_access_level_id` FROM `website_top_categories` AS `WebsiteTopCategory` LEFT JOIN `website_access_levels` AS `WebsiteAccessLevel` ON (`WebsiteTopCategory`.`website_access_level_id` = `WebsiteAccessLevel`.`id`) WHERE `WebsiteTopCategory`.`visible` = 1 AND `WebsiteTopCategory`.`website_top_category_type_id` = 15 AND `WebsiteTopCategory`.`website_access_level_id` > 1 ORDER BY `WebsiteTopCategory`.`website_access_level_id` ASC, `WebsiteTopCategory`.`name` ASC 26260
57SELECT `WebsiteTopCategory`.`id`, `WebsiteTopCategory`.`website_top_category_type_id`, `WebsiteTopCategory`.`name`, `WebsiteTopCategory`.`default_website_content_id`, `WebsiteTopCategory`.`website_access_level_id`, `WebsiteTopCategory`.`shop_category_id`, `WebsiteTopCategory`.`blurb`, `WebsiteTopCategory`.`image_file`, `WebsiteTopCategory`.`sample_file`, `WebsiteTopCategory`.`visible`, `WebsiteTopCategoryType`.`id`, `WebsiteTopCategoryType`.`name`, `WebsiteAccessLevel`.`id`, `WebsiteAccessLevel`.`name`, `WebsiteAccessLevel`.`shop_access_level_id`, `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 `website_top_categories` AS `WebsiteTopCategory` LEFT JOIN `website_top_category_types` AS `WebsiteTopCategoryType` ON (`WebsiteTopCategory`.`website_top_category_type_id` = `WebsiteTopCategoryType`.`id`) LEFT JOIN `website_access_levels` AS `WebsiteAccessLevel` ON (`WebsiteTopCategory`.`website_access_level_id` = `WebsiteAccessLevel`.`id`) LEFT JOIN `shop_categories` AS `ShopCategory` ON (`WebsiteTopCategory`.`shop_category_id` = `ShopCategory`.`id`) WHERE `WebsiteTopCategory`.`id` = 233 ORDER BY `WebsiteTopCategory`.`name` ASC LIMIT 1110
58SELECT `WebsiteAccessLevel`.`name` FROM `website_access_levels` AS `WebsiteAccessLevel` WHERE `WebsiteAccessLevel`.`id` = 1 LIMIT 1110
59SELECT COUNT(*) AS `count` FROM `website_contents` AS `WebsiteContent` LEFT JOIN `website_access_levels` AS `WebsiteAccessLevel` ON (`WebsiteContent`.`website_access_level_id` = `WebsiteAccessLevel`.`id`) LEFT JOIN `website_content_types` AS `WebsiteContentType` ON (`WebsiteContent`.`website_content_type_id` = `WebsiteContentType`.`id`) LEFT JOIN `website_top_categories` AS `WebsiteTopCategory` ON (`WebsiteContent`.`website_top_category_id` = `WebsiteTopCategory`.`id`) LEFT JOIN `countries` AS `Country` ON (`WebsiteContent`.`country_id` = `Country`.`id`) WHERE `WebsiteContent`.`website_top_category_id` = 233 AND `WebsiteContent`.`website_content_type_id` = 1 1129
60SELECT `WebsiteContent`.`id`, `WebsiteContent`.`website_content_type_id`, `WebsiteContent`.`website_top_category_id`, `WebsiteContent`.`name`, `WebsiteContent`.`author`, `WebsiteContent`.`filename`, `WebsiteContent`.`related_url`, `WebsiteContent`.`download_url`, `WebsiteContent`.`created`, `WebsiteContent`.`short_description`, `WebsiteContent`.`long_description`, `WebsiteContent`.`website_access_level_id`, `WebsiteContent`.`email`, `WebsiteContent`.`featured`, `WebsiteContent`.`feature_date`, `WebsiteContent`.`feature_text`, `WebsiteContent`.`news_type_id`, `WebsiteContent`.`shop_category_id`, `WebsiteContent`.`import_news_id`, `WebsiteContent`.`hits`, `WebsiteContent`.`denials`, `WebsiteContent`.`image_filename`, `WebsiteContent`.`in_header`, `WebsiteContent`.`in_footer`, `WebsiteContent`.`subscription_type`, `WebsiteContent`.`service`, `WebsiteContent`.`information`, `WebsiteContent`.`is_link`, `WebsiteContent`.`links`, `WebsiteContent`.`active`, `WebsiteContent`.`travelling_trader`, `WebsiteContent`.`ebriefing`, `WebsiteContent`.`marketcenter_id`, `WebsiteContent`.`country_id`, `WebsiteContent`.`visible`, `WebsiteAccessLevel`.`id`, `WebsiteAccessLevel`.`name`, `WebsiteAccessLevel`.`shop_access_level_id`, `WebsiteContentType`.`id`, `WebsiteContentType`.`name`, `WebsiteContentType`.`order_in_menu`, `WebsiteContentType`.`display_name`, `WebsiteContentType`.`visible`, `WebsiteContentType`.`slug`, `WebsiteTopCategory`.`id`, `WebsiteTopCategory`.`website_top_category_type_id`, `WebsiteTopCategory`.`name`, `WebsiteTopCategory`.`default_website_content_id`, `WebsiteTopCategory`.`website_access_level_id`, `WebsiteTopCategory`.`shop_category_id`, `WebsiteTopCategory`.`blurb`, `WebsiteTopCategory`.`image_file`, `WebsiteTopCategory`.`sample_file`, `WebsiteTopCategory`.`visible`, `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 `website_contents` AS `WebsiteContent` LEFT JOIN `website_access_levels` AS `WebsiteAccessLevel` ON (`WebsiteContent`.`website_access_level_id` = `WebsiteAccessLevel`.`id`) LEFT JOIN `website_content_types` AS `WebsiteContentType` ON (`WebsiteContent`.`website_content_type_id` = `WebsiteContentType`.`id`) LEFT JOIN `website_top_categories` AS `WebsiteTopCategory` ON (`WebsiteContent`.`website_top_category_id` = `WebsiteTopCategory`.`id`) LEFT JOIN `countries` AS `Country` ON (`WebsiteContent`.`country_id` = `Country`.`id`) WHERE `WebsiteContent`.`website_top_category_id` = 233 AND `WebsiteContent`.`website_content_type_id` = 1 ORDER BY `WebsiteContent`.`created` DESC LIMIT 25, 25252537