(default) 93 queries took 524 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 `partnerf_secure_dreamersdb`.`moosettings` AS `Setting` LEFT JOIN `partnerf_secure_dreamersdb`.`moosetting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `is_boot` = 01061062
2SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `partnerf_secure_dreamersdb`.`moocurrencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1110
3SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `partnerf_secure_dreamersdb`.`moocake_sessions` AS `Session` WHERE `id` = '75123d2e5d374649c25c1b355cbfbcbf' LIMIT 1000
4SELECT `Language`.`key`, `Language`.`name` FROM `partnerf_secure_dreamersdb`.`moolanguages` AS `Language` WHERE 1 = 1 ORDER BY `Language`.`name` asc110
5SELECT `Language`.`id`, `Language`.`key`, `Language`.`name`, `Language`.`rtl` FROM `partnerf_secure_dreamersdb`.`moolanguages` AS `Language` WHERE 1 = 1 ORDER BY `Language`.`name` asc110
6SELECT `Theme`.`key`, `Theme`.`name` FROM `partnerf_secure_dreamersdb`.`moothemes` AS `Theme` WHERE 1 = 1110
7SELECT `Page`.`id`, `Page`.`title`, `Page`.`alias`, `Page`.`content`, `Page`.`permission`, `Page`.`params`, `Page`.`created`, `Page`.`modified`, `Page`.`menu`, `Page`.`icon_class`, `Page`.`weight`, `Page`.`url`, `Page`.`uri`, `Page`.`description`, `Page`.`keywords`, `Page`.`custom`, `Page`.`fragment`, `Page`.`layout`, `Page`.`levels`, `Page`.`provides`, `Page`.`view_count`, `Page`.`type`, `Page`.`search`, `Page`.`theme_id`, `Page`.`core_content_count`, `MyCoreTheme`.`id`, `MyCoreTheme`.`key`, `MyCoreTheme`.`name`, `MyCoreTheme`.`core` FROM `partnerf_secure_dreamersdb`.`moopages` AS `Page` LEFT JOIN `partnerf_secure_dreamersdb`.`moothemes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) WHERE `Page`.`uri` = 'home.landing' ORDER BY `Page`.`weight` asc LIMIT 1111
8SELECT `CoreContent`.`id`, `CoreContent`.`page_id`, `CoreContent`.`type`, `CoreContent`.`name`, `CoreContent`.`component`, `CoreContent`.`parent_id`, `CoreContent`.`order`, `CoreContent`.`params`, `CoreContent`.`attribs`, `CoreContent`.`lft`, `CoreContent`.`rght`, `CoreContent`.`column`, `CoreContent`.`core_block_id`, `CoreContent`.`core_content_count`, `CoreContent`.`invisible`, `CoreContent`.`core_block_title`, `CoreContent`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `CoreContent` WHERE `CoreContent`.`page_id` = (63)11111
9SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
10SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
11SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
12SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
13SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
14SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
15SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
16SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
17SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
18SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
19SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count` FROM `partnerf_secure_dreamersdb`.`moopages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 63110
20SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `Parent` WHERE `Parent`.`id` = 121110
21SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `Parent` WHERE `Parent`.`id` = 119110
22SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `Parent` WHERE `Parent`.`id` = 137110
23SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `Parent` WHERE `Parent`.`id` = 121110
24SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `Parent` WHERE `Parent`.`id` = 119110
25SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `Parent` WHERE `Parent`.`id` = 119110
26SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `Parent` WHERE `Parent`.`id` = 119110
27SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `Parent` WHERE `Parent`.`id` = 119110
28SELECT `Children`.`id`, `Children`.`page_id`, `Children`.`type`, `Children`.`name`, `Children`.`component`, `Children`.`parent_id`, `Children`.`order`, `Children`.`params`, `Children`.`attribs`, `Children`.`lft`, `Children`.`rght`, `Children`.`column`, `Children`.`core_block_id`, `Children`.`core_content_count`, `Children`.`invisible`, `Children`.`core_block_title`, `Children`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `Children` WHERE `Children`.`parent_id` IN (119, 121, 122, 132, 137, 139, 125, 133, 156, 120, 191)881
29SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `partnerf_secure_dreamersdb`.`mooi18n` AS `nameTranslation` WHERE `model` = 'CoreContent' AND `field` = 'core_block_title' AND `nameTranslation`.`foreign_key` IN (119, 121, 122, 132, 137, 139, 125, 133, 156, 120, 191) ORDER BY `id` ASC11111
30SELECT `CoreContent`.`id`, `CoreContent`.`page_id`, `CoreContent`.`type`, `CoreContent`.`name`, `CoreContent`.`component`, `CoreContent`.`parent_id`, `CoreContent`.`order`, `CoreContent`.`params`, `CoreContent`.`attribs`, `CoreContent`.`lft`, `CoreContent`.`rght`, `CoreContent`.`column`, `CoreContent`.`core_block_id`, `CoreContent`.`core_content_count`, `CoreContent`.`invisible`, `CoreContent`.`core_block_title`, `CoreContent`.`plugin`, (`I18n__nameTranslation`.`content`) AS `CoreContent__i18n_nameTranslation` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `CoreContent` INNER JOIN `partnerf_secure_dreamersdb`.`mooi18n` AS `I18n__nameTranslation` ON (`CoreContent`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'CoreContent' AND `I18n__nameTranslation`.`field` = 'core_block_title' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `CoreContent`.`name` = 'header'001
31SELECT `CoreContent`.`id`, `CoreContent`.`page_id`, `CoreContent`.`type`, `CoreContent`.`name`, `CoreContent`.`component`, `CoreContent`.`parent_id`, `CoreContent`.`order`, `CoreContent`.`params`, `CoreContent`.`attribs`, `CoreContent`.`lft`, `CoreContent`.`rght`, `CoreContent`.`column`, `CoreContent`.`core_block_id`, `CoreContent`.`core_content_count`, `CoreContent`.`invisible`, `CoreContent`.`core_block_title`, `CoreContent`.`plugin`, (`I18n__nameTranslation`.`content`) AS `CoreContent__i18n_nameTranslation` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `CoreContent` INNER JOIN `partnerf_secure_dreamersdb`.`mooi18n` AS `I18n__nameTranslation` ON (`CoreContent`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'CoreContent' AND `I18n__nameTranslation`.`field` = 'core_block_title' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `CoreContent`.`name` = 'footer'221
32SELECT `Children`.`id`, `Children`.`page_id`, `Children`.`type`, `Children`.`name`, `Children`.`component`, `Children`.`parent_id`, `Children`.`order`, `Children`.`params`, `Children`.`attribs`, `Children`.`lft`, `Children`.`rght`, `Children`.`column`, `Children`.`core_block_id`, `Children`.`core_content_count`, `Children`.`invisible`, `Children`.`core_block_title`, `Children`.`plugin` FROM `partnerf_secure_dreamersdb`.`moocore_contents` AS `Children` WHERE `Children`.`parent_id` IN (152, 184)221
33SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `partnerf_secure_dreamersdb`.`mooi18n` AS `nameTranslation` WHERE `model` = 'CoreContent' AND `field` = 'core_block_title' AND `nameTranslation`.`foreign_key` IN (152, 184) ORDER BY `id` ASC221
34SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `partnerf_secure_dreamersdb`.`mooroles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1110
35SELECT `Tag`.`tag`, `Tag`.`created`, (SELECT count(*) FROM mootags WHERE tag=Tag.tag) as count FROM `partnerf_secure_dreamersdb`.`mootags` AS `Tag` WHERE 1 = 1 GROUP BY `Tag`.`tag` ORDER BY `count` desc LIMIT 12771
36SELECT `User`.`id`, `User`.`name`, `User`.`avatar` FROM `partnerf_secure_dreamersdb`.`moofriends` AS `Friend` LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `FriendUser` ON (`Friend`.`friend_id` = `FriendUser`.`id`) LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `User` ON (`Friend`.`friend_id` = `User`.`id`) WHERE ((`Friend`.`user_id` IS NULL) OR (`Friend`.`friend_id` IS NULL)) AND `User`.`active` = '1' ORDER BY `User`.`name` asc000
37SELECT COUNT(*) AS `count` FROM `partnerf_secure_dreamersdb`.`mooactivities` AS `Activity` LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `User` ON (`Activity`.`user_id` = `User`.`id`) LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `DreamByUser` ON (`Activity`.`dream_complete_by_user` = `DreamByUser`.`id`) WHERE `Activity`.`user_id` IS NULL AND `Activity`.`status` = 'ok' AND `Activity`.`dream_type` = '4'110
38SELECT `Friend`.`id`, `Friend`.`friend_id` FROM `partnerf_secure_dreamersdb`.`moofriends` AS `Friend` WHERE `Friend`.`user_id` = ''001
39SELECT `EventRsvp`.`id`, `EventRsvp`.`event_id` FROM `partnerf_secure_dreamersdb`.`mooevent_rsvps` AS `EventRsvp` WHERE `EventRsvp`.`user_id` = '' AND `EventRsvp`.`rsvp` = 1 ORDER BY `EventRsvp`.`id` desc000
40SELECT `GroupUser`.`id`, `GroupUser`.`group_id` FROM `partnerf_secure_dreamersdb`.`moogroup_users` AS `GroupUser` WHERE `GroupUser`.`user_id` = '' AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3)001
41SELECT *, `Activity`.`id` FROM `partnerf_secure_dreamersdb`.`mooactivities` AS `Activity` LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `User` ON (`Activity`.`user_id` = `User`.`id`) LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `DreamByUser` ON (`Activity`.`dream_complete_by_user` = `DreamByUser`.`id`) LEFT JOIN `partnerf_secure_dreamersdb`.`moouser_taggings` AS `UserTagging` ON (`Activity`.`id` = `UserTagging`.`item_id` AND `UserTagging`.`item_table` = 'activities') WHERE ((((`Activity`.`type` = 'user') AND (`Activity`.`privacy` = 1))) OR (((`Activity`.`type` = 'user') AND (`Activity`.`privacy` = 4) AND (`shared_user` <> ''))) OR (((`Activity`.`user_id` = '') AND (`Activity`.`action` <> 'friend_add'))) OR (((`Activity`.`type` = 'user') AND (`Activity`.`user_id` IS NULL) AND (`Activity`.`privacy` <> 3))) OR (((`Activity`.`type` = 'Event_Event') AND (`Activity`.`target_id` IS NULL))) OR (((`Activity`.`type` = 'Group_Group') AND (`Activity`.`action` = 'group_join'))) OR (((`Activity`.`type` = 'Group_Group') AND (`Activity`.`target_id` IS NULL)))) AND `Activity`.`Plugin` IN ('Billing', 'Blog', 'Cron', 'Event', 'Group', 'Mail', 'Menu', 'MooUpload', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'Photo', 'SocialIntegration', 'Subscription', 'Topic', 'Video', '') AND `User`.`active` = '1' ORDER BY `Activity`.`modified` desc LIMIT 121212455
42SELECT `Country`.`id`, `Country`.`sortname`, `Country`.`name`, `Country`.`phonecode`, `Country`.`status` FROM `partnerf_secure_dreamersdb`.`moocountries` AS `Country` WHERE `Country`.`id` = 10111
43SELECT `State`.`id`, `State`.`name`, `State`.`country_id`, `State`.`status` FROM `partnerf_secure_dreamersdb`.`moostates` AS `State` WHERE `State`.`id` = 218111
44SELECT `Country`.`id`, `Country`.`sortname`, `Country`.`name`, `Country`.`phonecode`, `Country`.`status` FROM `partnerf_secure_dreamersdb`.`moocountries` AS `Country` WHERE `Country`.`id` = 101110
45SELECT `State`.`id`, `State`.`name`, `State`.`country_id`, `State`.`status` FROM `partnerf_secure_dreamersdb`.`moostates` AS `State` WHERE `State`.`id` = 6111
46SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`status` FROM `partnerf_secure_dreamersdb`.`moocities` AS `City` WHERE `City`.`id` = 594111
47SELECT `Country`.`id`, `Country`.`sortname`, `Country`.`name`, `Country`.`phonecode`, `Country`.`status` FROM `partnerf_secure_dreamersdb`.`moocountries` AS `Country` WHERE `Country`.`id` = 4110
48SELECT `Country`.`id`, `Country`.`sortname`, `Country`.`name`, `Country`.`phonecode`, `Country`.`status` FROM `partnerf_secure_dreamersdb`.`moocountries` AS `Country` WHERE `Country`.`id` = 1110
49SELECT `State`.`id`, `State`.`name`, `State`.`country_id`, `State`.`status` FROM `partnerf_secure_dreamersdb`.`moostates` AS `State` WHERE `State`.`id` = 42110
50SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`status` FROM `partnerf_secure_dreamersdb`.`moocities` AS `City` WHERE `City`.`id` = 5912111
51SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`status` FROM `partnerf_secure_dreamersdb`.`moocities` AS `City` WHERE `City`.`id` = 5909110
52SELECT `ActivityComment`.`id`, `ActivityComment`.`user_id`, `ActivityComment`.`activity_id`, `ActivityComment`.`comment`, `ActivityComment`.`like_count`, `ActivityComment`.`dislike_count`, `ActivityComment`.`created`, `ActivityComment`.`thumbnail`, `ActivityComment`.`edited` FROM `partnerf_secure_dreamersdb`.`mooactivity_comments` AS `ActivityComment` WHERE `ActivityComment`.`activity_id` IN (3935, 4045, 4044, 4043, 4042, 4041, 4040, 4039, 4038, 4037, 4035, 4034) ORDER BY `ActivityComment`.`id` desc551
53SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`dreamfeed_lastseen`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`count_birthday`, `User`.`old_birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`favorite_tv_show`, `User`.`favorite_movies`, `User`.`hobbies`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`facebook_url`, `User`.`twitter_url`, `User`.`linkedin_url`, `User`.`instagram_url`, `User`.`place_you_live`, `User`.`website`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`profile_status`, `User`.`lives_in`, `User`.`phone_number`, `User`.`studied_at`, `User`.`works_at`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`access_token`, `User`.`device_type`, `User`.`device_token`, `User`.`name_show`, `User`.`email_show`, `User`.`birthday_show`, `User`.`gender_show`, `User`.`username_show`, `User`.`about_show`, `User`.`facebook_url_show`, `User`.`twitter_url_show`, `User`.`linkedin_url_show`, `User`.`instagram_url_show`, `User`.`website_show`, `User`.`address_show`, `User`.`city_show`, `User`.`state_show`, `User`.`country_show`, `User`.`profile_status_show`, `User`.`lives_in_show`, `User`.`phone_number_show`, `User`.`studied_at_show`, `User`.`works_at_show`, `User`.`facebook_user_id` FROM `partnerf_secure_dreamersdb`.`moousers` AS `User` WHERE `User`.`id` = 54111
54SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`dreamfeed_lastseen`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`count_birthday`, `User`.`old_birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`favorite_tv_show`, `User`.`favorite_movies`, `User`.`hobbies`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`facebook_url`, `User`.`twitter_url`, `User`.`linkedin_url`, `User`.`instagram_url`, `User`.`place_you_live`, `User`.`website`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`profile_status`, `User`.`lives_in`, `User`.`phone_number`, `User`.`studied_at`, `User`.`works_at`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`access_token`, `User`.`device_type`, `User`.`device_token`, `User`.`name_show`, `User`.`email_show`, `User`.`birthday_show`, `User`.`gender_show`, `User`.`username_show`, `User`.`about_show`, `User`.`facebook_url_show`, `User`.`twitter_url_show`, `User`.`linkedin_url_show`, `User`.`instagram_url_show`, `User`.`website_show`, `User`.`address_show`, `User`.`city_show`, `User`.`state_show`, `User`.`country_show`, `User`.`profile_status_show`, `User`.`lives_in_show`, `User`.`phone_number_show`, `User`.`studied_at_show`, `User`.`works_at_show`, `User`.`facebook_user_id` FROM `partnerf_secure_dreamersdb`.`moousers` AS `User` WHERE `User`.`id` = 314111
55SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`dreamfeed_lastseen`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`count_birthday`, `User`.`old_birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`favorite_tv_show`, `User`.`favorite_movies`, `User`.`hobbies`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`facebook_url`, `User`.`twitter_url`, `User`.`linkedin_url`, `User`.`instagram_url`, `User`.`place_you_live`, `User`.`website`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`profile_status`, `User`.`lives_in`, `User`.`phone_number`, `User`.`studied_at`, `User`.`works_at`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`access_token`, `User`.`device_type`, `User`.`device_token`, `User`.`name_show`, `User`.`email_show`, `User`.`birthday_show`, `User`.`gender_show`, `User`.`username_show`, `User`.`about_show`, `User`.`facebook_url_show`, `User`.`twitter_url_show`, `User`.`linkedin_url_show`, `User`.`instagram_url_show`, `User`.`website_show`, `User`.`address_show`, `User`.`city_show`, `User`.`state_show`, `User`.`country_show`, `User`.`profile_status_show`, `User`.`lives_in_show`, `User`.`phone_number_show`, `User`.`studied_at_show`, `User`.`works_at_show`, `User`.`facebook_user_id` FROM `partnerf_secure_dreamersdb`.`moousers` AS `User` WHERE `User`.`id` = 315111
56SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`dreamfeed_lastseen`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`count_birthday`, `User`.`old_birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`favorite_tv_show`, `User`.`favorite_movies`, `User`.`hobbies`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`facebook_url`, `User`.`twitter_url`, `User`.`linkedin_url`, `User`.`instagram_url`, `User`.`place_you_live`, `User`.`website`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`profile_status`, `User`.`lives_in`, `User`.`phone_number`, `User`.`studied_at`, `User`.`works_at`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`access_token`, `User`.`device_type`, `User`.`device_token`, `User`.`name_show`, `User`.`email_show`, `User`.`birthday_show`, `User`.`gender_show`, `User`.`username_show`, `User`.`about_show`, `User`.`facebook_url_show`, `User`.`twitter_url_show`, `User`.`linkedin_url_show`, `User`.`instagram_url_show`, `User`.`website_show`, `User`.`address_show`, `User`.`city_show`, `User`.`state_show`, `User`.`country_show`, `User`.`profile_status_show`, `User`.`lives_in_show`, `User`.`phone_number_show`, `User`.`studied_at_show`, `User`.`works_at_show`, `User`.`facebook_user_id` FROM `partnerf_secure_dreamersdb`.`moousers` AS `User` WHERE `User`.`id` = 5111
57SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type`, `Like`.`thumb_up`, `Like`.`created_At`, `Like`.`modified_At` FROM `partnerf_secure_dreamersdb`.`moolikes` AS `Like` WHERE `Like`.`type` = 'core_activity_comment' AND `Like`.`target_id` IN (759, 758, 757, 756, 755)551
58SELECT `Friend`.`id`, `Friend`.`friend_id` FROM `partnerf_secure_dreamersdb`.`moofriends` AS `Friend` WHERE `Friend`.`user_id` = ''000
59SELECT `EventRsvp`.`id`, `EventRsvp`.`event_id` FROM `partnerf_secure_dreamersdb`.`mooevent_rsvps` AS `EventRsvp` WHERE `EventRsvp`.`user_id` = '' AND `EventRsvp`.`rsvp` = 1 ORDER BY `EventRsvp`.`id` desc000
60SELECT `GroupUser`.`id`, `GroupUser`.`group_id` FROM `partnerf_secure_dreamersdb`.`moogroup_users` AS `GroupUser` WHERE `GroupUser`.`user_id` = '' AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3)000
61SELECT COUNT(*) AS `count` FROM `partnerf_secure_dreamersdb`.`mooactivities` AS `Activity` LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `User` ON (`Activity`.`user_id` = `User`.`id`) LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `DreamByUser` ON (`Activity`.`dream_complete_by_user` = `DreamByUser`.`id`) WHERE ((((`Activity`.`type` = 'user') AND (`Activity`.`privacy` = 1))) OR (((`Activity`.`type` = 'user') AND (`Activity`.`privacy` = 4) AND (`shared_user` <> ''))) OR (((`Activity`.`user_id` = '') AND (`Activity`.`action` <> 'friend_add'))) OR (((`Activity`.`type` = 'user') AND (`Activity`.`user_id` IS NULL) AND (`Activity`.`privacy` <> 3))) OR (((`Activity`.`type` = 'Event_Event') AND (`Activity`.`target_id` IS NULL))) OR (((`Activity`.`type` = 'Group_Group') AND (`Activity`.`action` = 'group_join'))) OR (((`Activity`.`type` = 'Group_Group') AND (`Activity`.`target_id` IS NULL)))) AND `Activity`.`Plugin` IN ('Billing', 'Blog', 'Cron', 'Event', 'Group', 'Mail', 'Menu', 'MooUpload', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'Photo', 'SocialIntegration', 'Subscription', 'Topic', 'Video', '') AND `User`.`active` = '1'1117
62SELECT `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, (`I18n__nameTranslation`.`content`) AS `Category__i18n_nameTranslation` FROM `partnerf_secure_dreamersdb`.`moocategories` AS `Category` INNER JOIN `partnerf_secure_dreamersdb`.`mooi18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `Category`.`type` = 'Video' AND `Category`.`active` = '1' ORDER BY `Category`.`weight` asc111
63SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `partnerf_secure_dreamersdb`.`mooi18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4) ORDER BY `id` ASC111
64SELECT `Friend`.`id`, `Friend`.`friend_id` FROM `partnerf_secure_dreamersdb`.`moofriends` AS `Friend` WHERE `Friend`.`user_id` = ''000
65SELECT `EventRsvp`.`id`, `EventRsvp`.`event_id` FROM `partnerf_secure_dreamersdb`.`mooevent_rsvps` AS `EventRsvp` WHERE `EventRsvp`.`user_id` = '' AND `EventRsvp`.`rsvp` = 1 ORDER BY `EventRsvp`.`id` desc000
66SELECT `GroupUser`.`id`, `GroupUser`.`group_id` FROM `partnerf_secure_dreamersdb`.`moogroup_users` AS `GroupUser` WHERE `GroupUser`.`user_id` = '' AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3)000
67SELECT `Friend`.`id`, `Friend`.`friend_id` FROM `partnerf_secure_dreamersdb`.`moofriends` AS `Friend` WHERE `Friend`.`user_id` = ''000
68SELECT `EventRsvp`.`id`, `EventRsvp`.`event_id` FROM `partnerf_secure_dreamersdb`.`mooevent_rsvps` AS `EventRsvp` WHERE `EventRsvp`.`user_id` = '' AND `EventRsvp`.`rsvp` = 1 ORDER BY `EventRsvp`.`id` desc000
69SELECT `GroupUser`.`id`, `GroupUser`.`group_id` FROM `partnerf_secure_dreamersdb`.`moogroup_users` AS `GroupUser` WHERE `GroupUser`.`user_id` = '' AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3)000
70SELECT `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, (`I18n__nameTranslation`.`content`) AS `Category__i18n_nameTranslation` FROM `partnerf_secure_dreamersdb`.`moocategories` AS `Category` INNER JOIN `partnerf_secure_dreamersdb`.`mooi18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `Category`.`type` = 'Video' AND `Category`.`active` = '1' ORDER BY `Category`.`weight` asc111
71SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `partnerf_secure_dreamersdb`.`mooi18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4) ORDER BY `id` ASC111
72SELECT `Event`.`id`, `Event`.`category_id`, `Event`.`title`, `Event`.`description`, `Event`.`user_id`, `Event`.`location`, `Event`.`from`, `Event`.`from_time`, `Event`.`to`, `Event`.`to_time`, `Event`.`created`, `Event`.`type`, `Event`.`photo`, `Event`.`event_rsvp_count`, `Event`.`address`, `Event`.`timezone`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`dreamfeed_lastseen`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`count_birthday`, `User`.`old_birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`favorite_tv_show`, `User`.`favorite_movies`, `User`.`hobbies`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`facebook_url`, `User`.`twitter_url`, `User`.`linkedin_url`, `User`.`instagram_url`, `User`.`place_you_live`, `User`.`website`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`profile_status`, `User`.`lives_in`, `User`.`phone_number`, `User`.`studied_at`, `User`.`works_at`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`access_token`, `User`.`device_type`, `User`.`device_token`, `User`.`name_show`, `User`.`email_show`, `User`.`birthday_show`, `User`.`gender_show`, `User`.`username_show`, `User`.`about_show`, `User`.`facebook_url_show`, `User`.`twitter_url_show`, `User`.`linkedin_url_show`, `User`.`instagram_url_show`, `User`.`website_show`, `User`.`address_show`, `User`.`city_show`, `User`.`state_show`, `User`.`country_show`, `User`.`profile_status_show`, `User`.`lives_in_show`, `User`.`phone_number_show`, `User`.`studied_at_show`, `User`.`works_at_show`, `User`.`facebook_user_id`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `partnerf_secure_dreamersdb`.`mooevents` AS `Event` LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `partnerf_secure_dreamersdb`.`moocategories` AS `Category` ON (`Event`.`category_id` = `Category`.`id`) WHERE `Event`.`to` >= CURDATE() AND `Event`.`type` = 1 AND `User`.`active` = '1' ORDER BY `Event`.`from` asc LIMIT 5001
73SELECT data FROM moocake_sessions WHERE expires > 153220017431311
74SELECT `Friend`.`id`, `Friend`.`friend_id` FROM `partnerf_secure_dreamersdb`.`moofriends` AS `Friend` WHERE `Friend`.`user_id` IS NULL000
75SELECT `Friend`.`id`, `Friend`.`friend_id` FROM `partnerf_secure_dreamersdb`.`moofriends` AS `Friend` WHERE `Friend`.`user_id` = ''000
76SELECT `EventRsvp`.`id`, `EventRsvp`.`event_id` FROM `partnerf_secure_dreamersdb`.`mooevent_rsvps` AS `EventRsvp` WHERE `EventRsvp`.`user_id` = '' AND `EventRsvp`.`rsvp` = 1 ORDER BY `EventRsvp`.`id` desc000
77SELECT `GroupUser`.`id`, `GroupUser`.`group_id` FROM `partnerf_secure_dreamersdb`.`moogroup_users` AS `GroupUser` WHERE `GroupUser`.`user_id` = '' AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3)000
78SELECT `Friend`.`id`, `Friend`.`friend_id` FROM `partnerf_secure_dreamersdb`.`moofriends` AS `Friend` WHERE `Friend`.`user_id` = ''000
79SELECT `EventRsvp`.`id`, `EventRsvp`.`event_id` FROM `partnerf_secure_dreamersdb`.`mooevent_rsvps` AS `EventRsvp` WHERE `EventRsvp`.`user_id` = '' AND `EventRsvp`.`rsvp` = 1 ORDER BY `EventRsvp`.`id` desc000
80SELECT `GroupUser`.`id`, `GroupUser`.`group_id` FROM `partnerf_secure_dreamersdb`.`moogroup_users` AS `GroupUser` WHERE `GroupUser`.`user_id` = '' AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3)000
81SELECT `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, (`I18n__nameTranslation`.`content`) AS `Category__i18n_nameTranslation` FROM `partnerf_secure_dreamersdb`.`moocategories` AS `Category` INNER JOIN `partnerf_secure_dreamersdb`.`mooi18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `Category`.`type` = 'Video' AND `Category`.`active` = '1' ORDER BY `Category`.`weight` asc111
82SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `partnerf_secure_dreamersdb`.`mooi18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (4) ORDER BY `id` ASC110
83SELECT `Album`.`id`, `Album`.`user_id`, `Album`.`category_id`, `Album`.`title`, `Album`.`description`, `Album`.`created`, `Album`.`photo_count`, `Album`.`cover`, `Album`.`modified`, `Album`.`like_count`, `Album`.`dislike_count`, `Album`.`comment_count`, `Album`.`privacy`, `Album`.`type`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`dreamfeed_lastseen`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`count_birthday`, `User`.`old_birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`favorite_tv_show`, `User`.`favorite_movies`, `User`.`hobbies`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`facebook_url`, `User`.`twitter_url`, `User`.`linkedin_url`, `User`.`instagram_url`, `User`.`place_you_live`, `User`.`website`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`profile_status`, `User`.`lives_in`, `User`.`phone_number`, `User`.`studied_at`, `User`.`works_at`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`access_token`, `User`.`device_type`, `User`.`device_token`, `User`.`name_show`, `User`.`email_show`, `User`.`birthday_show`, `User`.`gender_show`, `User`.`username_show`, `User`.`about_show`, `User`.`facebook_url_show`, `User`.`twitter_url_show`, `User`.`linkedin_url_show`, `User`.`instagram_url_show`, `User`.`website_show`, `User`.`address_show`, `User`.`city_show`, `User`.`state_show`, `User`.`country_show`, `User`.`profile_status_show`, `User`.`lives_in_show`, `User`.`phone_number_show`, `User`.`studied_at_show`, `User`.`works_at_show`, `User`.`facebook_user_id`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `partnerf_secure_dreamersdb`.`mooalbums` AS `Album` LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `User` ON (`Album`.`user_id` = `User`.`id`) LEFT JOIN `partnerf_secure_dreamersdb`.`moocategories` AS `Category` ON (`Album`.`category_id` = `Category`.`id`) WHERE `Album`.`privacy` = 1 AND `Album`.`photo_count` > 0 AND `Album`.`type` = '' AND DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= Album.created AND `User`.`active` = '1' ORDER BY `Album`.`like_count` desc LIMIT 5002
84SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`dreamfeed_lastseen`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`count_birthday`, `User`.`old_birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`favorite_tv_show`, `User`.`favorite_movies`, `User`.`hobbies`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`facebook_url`, `User`.`twitter_url`, `User`.`linkedin_url`, `User`.`instagram_url`, `User`.`place_you_live`, `User`.`website`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`profile_status`, `User`.`lives_in`, `User`.`phone_number`, `User`.`studied_at`, `User`.`works_at`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`access_token`, `User`.`device_type`, `User`.`device_token`, `User`.`name_show`, `User`.`email_show`, `User`.`birthday_show`, `User`.`gender_show`, `User`.`username_show`, `User`.`about_show`, `User`.`facebook_url_show`, `User`.`twitter_url_show`, `User`.`linkedin_url_show`, `User`.`instagram_url_show`, `User`.`website_show`, `User`.`address_show`, `User`.`city_show`, `User`.`state_show`, `User`.`country_show`, `User`.`profile_status_show`, `User`.`lives_in_show`, `User`.`phone_number_show`, `User`.`studied_at_show`, `User`.`works_at_show`, `User`.`facebook_user_id`, `Country`.`id`, `Country`.`sortname`, `Country`.`name`, `Country`.`phonecode`, `Country`.`status`, `State`.`id`, `State`.`name`, `State`.`country_id`, `State`.`status`, `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`status`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `partnerf_secure_dreamersdb`.`moousers` AS `User` LEFT JOIN `partnerf_secure_dreamersdb`.`moocountries` AS `Country` ON (`User`.`country` = `Country`.`id`) LEFT JOIN `partnerf_secure_dreamersdb`.`moostates` AS `State` ON (`User`.`state` = `State`.`id`) LEFT JOIN `partnerf_secure_dreamersdb`.`moocities` AS `City` ON (`User`.`city` = `City`.`id`) LEFT JOIN `partnerf_secure_dreamersdb`.`mooroles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `active` = '1' ORDER BY `User`.`id` desc LIMIT 10101012
85SELECT `Blog`.`id`, `Blog`.`user_id`, `Blog`.`title`, `Blog`.`body`, `Blog`.`thumbnail`, `Blog`.`created`, `Blog`.`like_count`, `Blog`.`privacy`, `Blog`.`comment_count`, `Blog`.`share_count`, `Blog`.`dislike_count`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`dreamfeed_lastseen`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`count_birthday`, `User`.`old_birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`favorite_tv_show`, `User`.`favorite_movies`, `User`.`hobbies`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`facebook_url`, `User`.`twitter_url`, `User`.`linkedin_url`, `User`.`instagram_url`, `User`.`place_you_live`, `User`.`website`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`profile_status`, `User`.`lives_in`, `User`.`phone_number`, `User`.`studied_at`, `User`.`works_at`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`access_token`, `User`.`device_type`, `User`.`device_token`, `User`.`name_show`, `User`.`email_show`, `User`.`birthday_show`, `User`.`gender_show`, `User`.`username_show`, `User`.`about_show`, `User`.`facebook_url_show`, `User`.`twitter_url_show`, `User`.`linkedin_url_show`, `User`.`instagram_url_show`, `User`.`website_show`, `User`.`address_show`, `User`.`city_show`, `User`.`state_show`, `User`.`country_show`, `User`.`profile_status_show`, `User`.`lives_in_show`, `User`.`phone_number_show`, `User`.`studied_at_show`, `User`.`works_at_show`, `User`.`facebook_user_id` FROM `partnerf_secure_dreamersdb`.`mooblogs` AS `Blog` LEFT JOIN `partnerf_secure_dreamersdb`.`moousers` AS `User` ON (`Blog`.`user_id` = `User`.`id`) WHERE `Blog`.`privacy` = 1 AND `User`.`active` = '1' AND DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= Blog.created ORDER BY `Blog`.`like_count` desc LIMIT 5001
86SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `partnerf_secure_dreamersdb`.`moocore_menus` AS `Coremenu` WHERE `id` = 2 LIMIT 1110
87SELECT `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` FROM `partnerf_secure_dreamersdb`.`moocore_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (2) ORDER BY `CoreMenuItem`.`menu_order` ASC551
88SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `partnerf_secure_dreamersdb`.`mooi18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (10, 11, 12, 9, 14) ORDER BY `id` ASC550
89SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `partnerf_secure_dreamersdb`.`moocore_menu_items` AS `Coremenuitem` INNER JOIN `partnerf_secure_dreamersdb`.`mooi18n` 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` = 10 AND `is_active` = '1' ORDER BY `menu_order` ASC001
90SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `partnerf_secure_dreamersdb`.`moocore_menu_items` AS `Coremenuitem` INNER JOIN `partnerf_secure_dreamersdb`.`mooi18n` 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` ASC001
91SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `partnerf_secure_dreamersdb`.`moocore_menu_items` AS `Coremenuitem` INNER JOIN `partnerf_secure_dreamersdb`.`mooi18n` 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
92SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `partnerf_secure_dreamersdb`.`moocore_menu_items` AS `Coremenuitem` INNER JOIN `partnerf_secure_dreamersdb`.`mooi18n` 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
93SELECT `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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `partnerf_secure_dreamersdb`.`moocore_menu_items` AS `Coremenuitem` INNER JOIN `partnerf_secure_dreamersdb`.`mooi18n` 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` = 14 AND `is_active` = '1' ORDER BY `menu_order` ASC001