ISO Mecas Studies

The MECAS Studies are essential reading for everyone working in the sugar and ethanol industries and are available from Sugaronline as PDF downloads in English, French, Russian and Spanish.

Current MECAS Studies are available as part of the SugaronlineDiamond membership package. For other membership levels as well as non-members they are available to buy from the Sugaronline shop.

For further information on individual MECAS Studies simply click on the links in the list below.


 


 

 

(default) 62 queries took 225 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`554
5SHOW FULL COLUMNS FROM `people`94946
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
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`23234
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`443
16SHOW FULL COLUMNS FROM `shop_categories`12123
17SHOW FULL COLUMNS FROM `shop_products`27274
18SHOW FULL COLUMNS FROM `shop_pricing_units`333
19SHOW FULL COLUMNS FROM `shop_ordered_products`773
20SHOW FULL COLUMNS FROM `shop_access_levels_shop_products`333
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`335
27SHOW FULL COLUMNS FROM `your_menu_items`554
28SHOW FULL COLUMNS FROM `website_content_types`663
29SHOW FULL COLUMNS FROM `website_top_categories`10103
30SHOW FULL COLUMNS FROM `website_top_category_types`224
31SHOW FULL COLUMNS FROM `website_categories`334
32SHOW FULL COLUMNS FROM `website_categories_website_contents`223
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 442
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 442
42SELECT `WebsiteContent`.`id`, `WebsiteContent`.`name` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`service` = 1 AND `WebsiteContent`.`visible` = 1 331
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 `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`.`id` = 1167691 LIMIT 1111
58SELECT `WebsiteAccessLevel`.`name` FROM `website_access_levels` AS `WebsiteAccessLevel` WHERE `WebsiteAccessLevel`.`id` = 1 LIMIT 1110
59SELECT `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`.`id` = 1167691 LIMIT 1111
60SELECT COUNT(*) AS `count` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`id` = 1167691 110
61SELECT COUNT(*) AS `count` FROM `website_contents` AS `WebsiteContent` WHERE `WebsiteContent`.`id` = 1167691 110
62UPDATE `website_contents` SET `hits` = 30397 WHERE `website_contents`.`id` = 1167691179