Warning: SplFileInfo::openFile(/var/www/html/app/tmp/cache/persistent/moo_cake_core_file_map): Failed to open stream: Permission denied in /var/www/html/lib/Cake/Cache/Engine/FileEngine.php on line 364
Warning (512): SplFileInfo::openFile(/var/www/html/app/tmp/cache/models/moo_cake_model_default_travel_moosocial_list): Failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): SplFileInfo::openFile(/var/www/html/app/tmp/cache/models/moo_cake_model_default_travel_moosocial_list) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: Failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): _cake_model_ cache was unable to write 'default_travel_moosocial_list' to File cache [CORE/Cake/Cache/Cache.php, line 327]
Warning (512): SplFileInfo::openFile(/var/www/html/app/tmp/cache/persistent/moo_cake_core_method_cache) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: Failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): SplFileInfo::openFile(/var/www/html/app/tmp/cache/models/moo_cake_model_default_travel_moosocial_list) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: Failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): SplFileInfo::openFile(/var/www/html/app/tmp/cache/models/moo_cake_model_default_travel_moosocial_list) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: Failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): _cake_model_ cache was unable to write 'default_travel_moosocial_list' to File cache [CORE/Cake/Cache/Cache.php, line 327]
Business Home | mooTravel
The mooSocial $99 package does not include text chat, business directory, classified, color background status, shout box, gift comment and bookmark plugin. The demo will auto reset weekly on Sunday.
 
Cookies on mooTravel.
This site uses cookies to store your information on your computer.
(default) 187 queries took 658 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `BusinessLocation`.`id` FROM `travel_moosocial`.`qcbusiness_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC1114
2SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `travel_moosocial`.`qcbusiness_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`is_default` = '1' AND `BusinessLocation`.`parent_id` = (1) ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1001
3SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete` FROM `travel_moosocial`.`qcbusinesses` AS `Business` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Business`.`user_id` = `User`.`id`) WHERE `Business`.`status` = 'approved' AND `Business`.`claim_id` = 0 ORDER BY `Business`.`featured` DESC, `Business`.`id` DESC LIMIT 1010102
4SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
5SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
6SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
7SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
8SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
9SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
10SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
11SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
12SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
13SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
14SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `travel_moosocial`.`qcprofile_types` AS `ProfileType` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`ProfileType`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ProfileType' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ProfileType`.`id` IN (1, 'eng') AND `ProfileType`.`actived` = '1' ORDER BY `ProfileType`.`order` asc113
15SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC331
16SELECT COUNT(*) AS `count` FROM `travel_moosocial`.`qcbusinesses` AS `Business` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Business`.`user_id` = `User`.`id`) WHERE `Business`.`status` = 'approved' AND `Business`.`claim_id` = 01171
17SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcusers` AS `User` LEFT JOIN `travel_moosocial`.`qcroles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 1 LIMIT 11116
18SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `travel_moosocial`.`qcbusiness_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1112
19SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 10331
20SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`id` IN (4, 5, 6) ORDER BY `BusinessCategory`.`ordering` ASC331
21SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (4, 5, 6) ORDER BY `id` ASC9910
22SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `travel_moosocial`.`qcbusiness_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
23SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 7440
24SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`id` IN (1, 3, 5, 7) ORDER BY `BusinessCategory`.`ordering` ASC441
25SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (1, 3, 5, 7) ORDER BY `id` ASC12120
26SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `travel_moosocial`.`qcbusiness_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
27SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 6330
28SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`id` IN (2, 4, 6) ORDER BY `BusinessCategory`.`ordering` ASC331
29SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (2, 4, 6) ORDER BY `id` ASC990
30SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `travel_moosocial`.`qcbusiness_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
31SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 1440
32SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`id` IN (1, 3, 5, 7) ORDER BY `BusinessCategory`.`ordering` ASC441
33SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (1, 3, 5, 7) ORDER BY `id` ASC12120
34SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `travel_moosocial`.`qcbusiness_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
35SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 9440
36SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`id` IN (3, 4, 5, 6) ORDER BY `BusinessCategory`.`ordering` ASC441
37SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (3, 4, 5, 6) ORDER BY `id` ASC12121
38SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `travel_moosocial`.`qcbusiness_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
39SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 8330
40SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`id` IN (3, 5, 7) ORDER BY `BusinessCategory`.`ordering` ASC331
41SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (3, 5, 7) ORDER BY `id` ASC990
42SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `travel_moosocial`.`qcbusiness_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 11186
43SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 5330
44SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`id` IN (5, 6, 7) ORDER BY `BusinessCategory`.`ordering` ASC331
45SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (5, 6, 7) ORDER BY `id` ASC991
46SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `travel_moosocial`.`qcbusiness_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
47SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 4440
48SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`id` IN (1, 2, 3, 4) ORDER BY `BusinessCategory`.`ordering` ASC441
49SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (1, 2, 3, 4) ORDER BY `id` ASC12120
50SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `travel_moosocial`.`qcbusiness_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 1110
51SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 3333
52SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`id` IN (3, 4, 6) ORDER BY `BusinessCategory`.`ordering` ASC331
53SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (3, 4, 6) ORDER BY `id` ASC990
54SELECT `BusinessPackage`.`id`, `BusinessPackage`.`type`, `BusinessPackage`.`name`, `BusinessPackage`.`price`, `BusinessPackage`.`duration`, `BusinessPackage`.`duration_type`, `BusinessPackage`.`expiration_reminder`, `BusinessPackage`.`expiration_reminder_type`, `BusinessPackage`.`billing_cycle`, `BusinessPackage`.`billing_cycle_type`, `BusinessPackage`.`deleted`, `BusinessPackage`.`ordering`, `BusinessPackage`.`created`, `BusinessPackage`.`updated`, `BusinessPackage`.`photo_number`, `BusinessPackage`.`manage_admin`, `BusinessPackage`.`response_review`, `BusinessPackage`.`send_verification_request`, `BusinessPackage`.`contact_form`, `BusinessPackage`.`follow`, `BusinessPackage`.`checkin`, `BusinessPackage`.`favourite`, `BusinessPackage`.`enable`, `BusinessPackage`.`is_default`, `BusinessPackage`.`most_popular`, `BusinessPackage`.`trial` FROM `travel_moosocial`.`qcbusiness_packages` AS `BusinessPackage` WHERE `BusinessPackage`.`id` = 1 ORDER BY `BusinessPackage`.`ordering` ASC LIMIT 11186
55SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 2331
56SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`id` IN (2, 5, 6) ORDER BY `BusinessCategory`.`ordering` ASC332
57SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (2, 5, 6) ORDER BY `id` ASC991
58SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 10 LIMIT 1110
59SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 4 LIMIT 1111
60SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 7 AND `BusinessCategory`.`rght` >= 8 ORDER BY `BusinessCategory`.`lft` asc112
61SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 7 LIMIT 1114
62SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 1 LIMIT 1113
63SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 1 AND `BusinessCategory`.`rght` >= 2 ORDER BY `BusinessCategory`.`lft` asc111
64SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 6 LIMIT 1110
65SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 2 LIMIT 11182
66SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 3 AND `BusinessCategory`.`rght` >= 4 ORDER BY `BusinessCategory`.`lft` asc111
67SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 1 LIMIT 1110
68SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 1 LIMIT 1110
69SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 1 AND `BusinessCategory`.`rght` >= 2 ORDER BY `BusinessCategory`.`lft` asc111
70SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 9 LIMIT 1111
71SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 3 LIMIT 1110
72SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 5 AND `BusinessCategory`.`rght` >= 6 ORDER BY `BusinessCategory`.`lft` asc112
73SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 8 LIMIT 1111
74SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 3 LIMIT 1110
75SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 5 AND `BusinessCategory`.`rght` >= 6 ORDER BY `BusinessCategory`.`lft` asc111
76SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 5 LIMIT 1110
77SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 5 LIMIT 1110
78SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 9 AND `BusinessCategory`.`rght` >= 10 ORDER BY `BusinessCategory`.`lft` asc111
79SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 4 LIMIT 1113
80SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 1 LIMIT 1111
81SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 1 AND `BusinessCategory`.`rght` >= 2 ORDER BY `BusinessCategory`.`lft` asc111
82SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 3 LIMIT 1110
83SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 3 LIMIT 11181
84SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 5 AND `BusinessCategory`.`rght` >= 6 ORDER BY `BusinessCategory`.`lft` asc111
85SELECT `BusinessCategoryItem`.`id`, `BusinessCategoryItem`.`business_id`, `BusinessCategoryItem`.`business_category_id` FROM `travel_moosocial`.`qcbusiness_category_items` AS `BusinessCategoryItem` WHERE `BusinessCategoryItem`.`business_id` = 2 LIMIT 1110
86SELECT `BusinessCategory`.`lft`, `BusinessCategory`.`rght` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` WHERE `BusinessCategory`.`id` = 2 LIMIT 1110
87SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE 1 = 1 AND `BusinessCategory`.`lft` <= 3 AND `BusinessCategory`.`rght` >= 4 ORDER BY `BusinessCategory`.`lft` asc111
88SELECT `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete` FROM `travel_moosocial`.`qcbusinesses` AS `Business` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`Business`.`user_id` = `User`.`id`) WHERE `Business`.`status` = 'approved' AND `Business`.`featured` = '1' ORDER BY `Business`.`id` DESC LIMIT 10441
89SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
90SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
91SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
92SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 1110
93SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`parent_id` = 0 ORDER BY `BusinessCategory`.`ordering` ASC, `BusinessCategory`.`id` ASC LIMIT 10773
94SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameTranslation` WHERE `model` = 'BusinessCategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7) ORDER BY `id` ASC21211
95SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`parent_id` = 1 ORDER BY `BusinessCategory`.`ordering` ASC, `BusinessCategory`.`id` ASC LIMIT 10001
96SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`parent_id` = 2 ORDER BY `BusinessCategory`.`ordering` ASC, `BusinessCategory`.`id` ASC LIMIT 10001
97SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`parent_id` = 3 ORDER BY `BusinessCategory`.`ordering` ASC, `BusinessCategory`.`id` ASC LIMIT 10000
98SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`parent_id` = 4 ORDER BY `BusinessCategory`.`ordering` ASC, `BusinessCategory`.`id` ASC LIMIT 10000
99SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`parent_id` = 5 ORDER BY `BusinessCategory`.`ordering` ASC, `BusinessCategory`.`id` ASC LIMIT 10000
100SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`parent_id` = 6 ORDER BY `BusinessCategory`.`ordering` ASC, `BusinessCategory`.`id` ASC LIMIT 10000
101SELECT `BusinessCategory`.`id`, `BusinessCategory`.`parent_id`, `BusinessCategory`.`lft`, `BusinessCategory`.`rght`, `BusinessCategory`.`name`, `BusinessCategory`.`icon`, `BusinessCategory`.`enable`, `BusinessCategory`.`is_highlight`, `BusinessCategory`.`business_count`, `BusinessCategory`.`ordering`, `BusinessCategory`.`feature_ordering`, `BusinessCategory`.`user_create`, `BusinessCategory`.`user_list`, `BusinessCategory`.`created`, `BusinessCategory`.`updated`, (`I18n__nameTranslation`.`content`) AS `BusinessCategory__i18n_nameTranslation` FROM `travel_moosocial`.`qcbusiness_categories` AS `BusinessCategory` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameTranslation` ON (`BusinessCategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'BusinessCategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `BusinessCategory`.`enable` = '1' AND `BusinessCategory`.`parent_id` = 7 ORDER BY `BusinessCategory`.`ordering` ASC, `BusinessCategory`.`id` ASC LIMIT 10000
102SELECT `BusinessLocation`.`id` FROM `travel_moosocial`.`qcbusiness_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC1112
103SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `travel_moosocial`.`qcbusiness_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = (1) AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`business_count` DESC LIMIT 15111
104SELECT `BusinessReview`.`id`, `BusinessReview`.`user_id`, `BusinessReview`.`parent_id`, `BusinessReview`.`business_id`, `BusinessReview`.`lft`, `BusinessReview`.`rght`, `BusinessReview`.`content`, `BusinessReview`.`rating`, `BusinessReview`.`useful_count`, `BusinessReview`.`report_count`, `BusinessReview`.`created`, `BusinessReview`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete`, `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated` FROM `travel_moosocial`.`qcbusiness_reviews` AS `BusinessReview` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`BusinessReview`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qcbusinesses` AS `Business` ON (`BusinessReview`.`business_id` = `Business`.`id`) WHERE `BusinessReview`.`parent_id` = 0 ORDER BY `BusinessReview`.`created` DESC LIMIT 5446
105SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 4111
106SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 4110
107SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 4110
108SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `travel_moosocial`.`qcroles` AS `Role` WHERE `Role`.`id` = 4110
109SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete` FROM `travel_moosocial`.`qcusers` AS `User` WHERE `User`.`id` = 1110
110SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete` FROM `travel_moosocial`.`qcusers` AS `User` WHERE `User`.`id` = 1110
111SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete` FROM `travel_moosocial`.`qcusers` AS `User` WHERE `User`.`id` = 1110
112SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete` FROM `travel_moosocial`.`qcusers` AS `User` WHERE `User`.`id` = 1110
113SELECT `Photo`.`id`, `Photo`.`target_id`, `Photo`.`type`, `Photo`.`user_id`, `Photo`.`caption`, `Photo`.`path`, `Photo`.`thumbnail`, `Photo`.`original`, `Photo`.`created`, `Photo`.`like_count`, `Photo`.`dislike_count`, `Photo`.`privacy`, `Photo`.`album_type`, `Photo`.`album_type_id`, `Photo`.`comment_count`, `Photo`.`year_folder`, `Photo`.`size` FROM `travel_moosocial`.`qcphotos` AS `Photo` WHERE `Photo`.`target_id` IN (4, 3, 2, 1) AND `Photo`.`type` = 'Business_Review'001
114SELECT `BusinessReview`.`id`, `BusinessReview`.`user_id`, `BusinessReview`.`parent_id`, `BusinessReview`.`business_id`, `BusinessReview`.`lft`, `BusinessReview`.`rght`, `BusinessReview`.`content`, `BusinessReview`.`rating`, `BusinessReview`.`useful_count`, `BusinessReview`.`report_count`, `BusinessReview`.`created`, `BusinessReview`.`updated`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`signature`, `User`.`show_signature`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`lock_delete`, `Business`.`id`, `Business`.`parent_id`, `Business`.`user_id`, `Business`.`creator_id`, `Business`.`album_id`, `Business`.`business_location_id`, `Business`.`business_type_id`, `Business`.`name`, `Business`.`company_number`, `Business`.`description`, `Business`.`logo`, `Business`.`cover`, `Business`.`address`, `Business`.`lat`, `Business`.`lng`, `Business`.`postal_code`, `Business`.`email`, `Business`.`phone`, `Business`.`fax`, `Business`.`website`, `Business`.`facebook`, `Business`.`twitter`, `Business`.`linkedin`, `Business`.`youtube`, `Business`.`instagram`, `Business`.`always_open`, `Business`.`timezone`, `Business`.`total_score`, `Business`.`featured`, `Business`.`review_count`, `Business`.`follow_count`, `Business`.`photo_count`, `Business`.`branch_count`, `Business`.`checkin_count`, `Business`.`status`, `Business`.`verify`, `Business`.`is_free`, `Business`.`business_package_id`, `Business`.`claim_id`, `Business`.`is_claim`, `Business`.`permissions`, `Business`.`created`, `Business`.`updated` FROM `travel_moosocial`.`qcbusiness_reviews` AS `BusinessReview` LEFT JOIN `travel_moosocial`.`qcusers` AS `User` ON (`BusinessReview`.`user_id` = `User`.`id`) LEFT JOIN `travel_moosocial`.`qcbusinesses` AS `Business` ON (`BusinessReview`.`business_id` = `Business`.`id`) WHERE `BusinessReview`.`parent_id` = 0 AND DATE(`BusinessReview`.`created`) = CURDATE() AND `BusinessReview`.`useful_count` > 0 ORDER BY `BusinessReview`.`useful_count` DESC, `BusinessReview`.`rating` DESC LIMIT 1001
115SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `travel_moosocial`.`qccore_menus` AS `Coremenu` WHERE `id` = 2 LIMIT 1110
116SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group`, `CoreMenuItem`.`url_app`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app` FROM `travel_moosocial`.`qccore_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (2) ORDER BY `CoreMenuItem`.`menu_order` ASC441
117SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (9, 11, 12, 17) ORDER BY `id` ASC12121
118SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 9 AND `is_active` = '1' ORDER BY `menu_order` ASC001
119SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 11 AND `is_active` = '1' ORDER BY `menu_order` ASC000
120SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 12 AND `is_active` = '1' ORDER BY `menu_order` ASC001
121SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 17 AND `is_active` = '1' ORDER BY `menu_order` ASC001
122SELECT `BusinessLocation`.`id` FROM `travel_moosocial`.`qcbusiness_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`parent_id` = 0 AND `BusinessLocation`.`enabled` = '1' ORDER BY `BusinessLocation`.`ordering` ASC112
123SELECT `BusinessLocation`.`id`, `BusinessLocation`.`parent_id`, `BusinessLocation`.`lft`, `BusinessLocation`.`rght`, `BusinessLocation`.`name`, `BusinessLocation`.`business_count`, `BusinessLocation`.`is_default`, `BusinessLocation`.`on_popup`, `BusinessLocation`.`enabled`, `BusinessLocation`.`ordering`, `BusinessLocation`.`created`, `BusinessLocation`.`updated`, `BusinessLocation`.`city` FROM `travel_moosocial`.`qcbusiness_locations` AS `BusinessLocation` WHERE `BusinessLocation`.`is_default` = '1' AND `BusinessLocation`.`parent_id` = (1) ORDER BY `BusinessLocation`.`ordering` ASC LIMIT 1000
124SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1113
125SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1110
126SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `travel_moosocial`.`qcsettings` AS `Setting` LEFT JOIN `travel_moosocial`.`qcsetting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1110
127SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `travel_moosocial`.`qccore_menus` AS `Coremenu` WHERE `alias` = 'main-menu' LIMIT 1110
128SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group`, `CoreMenuItem`.`url_app`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app` FROM `travel_moosocial`.`qccore_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (1) ORDER BY `CoreMenuItem`.`menu_order` ASC21210
129SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (1, 2, 3, 4, 7, 6, 5, 8, 50, 24, 31, 32, 33, 34, 49, 30, 27, 25, 23, 26, 28) ORDER BY `id` ASC60601
130SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1111
131SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 1 AND `is_active` = '1' ORDER BY `menu_order` ASC003
132SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
133SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 2 AND `is_active` = '1' ORDER BY `menu_order` ASC001
134SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
135SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 3 AND `is_active` = '1' ORDER BY `menu_order` ASC001
136SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
137SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 4 AND `is_active` = '1' ORDER BY `menu_order` ASC001
138SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
139SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 7 AND `is_active` = '1' ORDER BY `menu_order` ASC001
140SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
141SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 6 AND `is_active` = '1' ORDER BY `menu_order` ASC001
142SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
143SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 5 AND `is_active` = '1' ORDER BY `menu_order` ASC001
144SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1111
145SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 8 AND `is_active` = '1' ORDER BY `menu_order` ASC001
146SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1111
147SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 50 AND `is_active` = '1' ORDER BY `menu_order` ASC001
148SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1111
149SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 24 AND `is_active` = '1' ORDER BY `menu_order` ASC11112
150SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (31, 32, 33, 34, 49, 30, 27, 25, 23, 26, 28) ORDER BY `id` ASC333361
151SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 31 AND `is_active` = '1' ORDER BY `menu_order` ASC0016
152SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 31 AND `is_active` = '1' ORDER BY `menu_order` ASC002
153SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 32 AND `is_active` = '1' ORDER BY `menu_order` ASC001
154SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 32 AND `is_active` = '1' ORDER BY `menu_order` ASC002
155SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 33 AND `is_active` = '1' ORDER BY `menu_order` ASC001
156SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 33 AND `is_active` = '1' ORDER BY `menu_order` ASC001
157SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 34 AND `is_active` = '1' ORDER BY `menu_order` ASC001
158SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 34 AND `is_active` = '1' ORDER BY `menu_order` ASC001
159SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 49 AND `is_active` = '1' ORDER BY `menu_order` ASC000
160SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 49 AND `is_active` = '1' ORDER BY `menu_order` ASC001
161SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 30 AND `is_active` = '1' ORDER BY `menu_order` ASC001
162SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 30 AND `is_active` = '1' ORDER BY `menu_order` ASC001
163SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 27 AND `is_active` = '1' ORDER BY `menu_order` ASC002
164SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 27 AND `is_active` = '1' ORDER BY `menu_order` ASC000
165SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 25 AND `is_active` = '1' ORDER BY `menu_order` ASC000
166SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 25 AND `is_active` = '1' ORDER BY `menu_order` ASC002
167SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 23 AND `is_active` = '1' ORDER BY `menu_order` ASC001
168SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 23 AND `is_active` = '1' ORDER BY `menu_order` ASC001
169SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 26 AND `is_active` = '1' ORDER BY `menu_order` ASC001
170SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 26 AND `is_active` = '1' ORDER BY `menu_order` ASC001
171SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 28 AND `is_active` = '1' ORDER BY `menu_order` ASC001
172SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 28 AND `is_active` = '1' ORDER BY `menu_order` ASC001
173SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `travel_moosocial`.`qccore_menu_items` AS `Coremenuitem` INNER JOIN `travel_moosocial`.`qci18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'eng') WHERE `parent_id` = 24 AND `is_active` = '1' ORDER BY `menu_order` ASC11111
174SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `travel_moosocial`.`qci18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (31, 32, 33, 34, 49, 30, 27, 25, 23, 26, 28) ORDER BY `id` ASC33331
175SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
176SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
177SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
178SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
179SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
180SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
181SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
182SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
183SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
184SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
185SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `travel_moosocial`.`qcplugins` AS `Plugin` WHERE `Plugin`.`key` = 'MooApp' ORDER BY `Plugin`.`weight` asc LIMIT 1110
186SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1110
187SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `travel_moosocial`.`qcthemes` AS `Theme` WHERE `Theme`.`key` = 'classic' LIMIT 1110
Warning (512): SplFileInfo::openFile(/var/www/html/app/tmp/cache/persistent/moo_cake_core_file_map) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: Failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): _cake_core_ cache was unable to write 'file_map' to File cache [CORE/Cake/Cache/Cache.php, line 327]
Warning (512): SplFileInfo::openFile(/var/www/html/app/tmp/cache/persistent/moo_cake_core_method_cache) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: Failed to open stream: Permission denied [CORE/Cake/Cache/Engine/FileEngine.php, line 364]
Warning (512): _cake_core_ cache was unable to write 'method_cache' to File cache [CORE/Cake/Cache/Cache.php, line 327]