Mark Hampton

  • Gender: Male
  • Born on: September 11

Friends (2)

  • 38special
  • rob46835

Groups

Upcoming Events

Most Voted Feedback

(default) 54 queries took 22 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `preppers_clever1`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1110
2SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `preppers_clever1`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'ujob9gt3atsa0tpedoprk5dqc3' LIMIT 1000
3SELECT `Plugin`.`enabled` FROM `preppers_clever1`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1110
4SELECT `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `preppers_clever1`.`users` AS `User` LEFT JOIN `preppers_clever1`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `preppers_clever1`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` = 166 LIMIT 1110
5SELECT `GroupUser`.`id`, `GroupUser`.`group_id` FROM `preppers_clever1`.`group_users` AS `GroupUser` WHERE `GroupUser`.`user_id` = 166 AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3)220
6SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`groups` AS `Group` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Group`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`categories` AS `Category` ON (`Group`.`category_id` = `Category`.`id`) WHERE ((((`Group`.`user_id` = 166) AND (`Group`.`type` <> 2))) OR (((`Group`.`id` IN (25, 24)) AND (`Group`.`type` <> 2))))110
7SELECT `Friend`.`id`, `Friend`.`user_id`, `Friend`.`friend_id`, `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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` FROM `preppers_clever1`.`friends` AS `Friend` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Friend`.`friend_id` = `User`.`id`) WHERE `Friend`.`user_id` = 166 AND `User`.`active` = '1' AND NOT (`Friend`.`friend_id` IS NULL) ORDER BY `User`.`name` asc LIMIT 10220
8SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`albums` AS `Album` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Album`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`categories` AS `Category` ON (`Album`.`category_id` = `Category`.`id`) WHERE `Album`.`privacy` = 1 AND `Album`.`photo_count` > 0 AND `Album`.`user_id` = 166 AND `User`.`active` = '1'110
9SELECT `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`.`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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `preppers_clever1`.`albums` AS `Album` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Album`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`categories` AS `Category` ON (`Album`.`category_id` = `Category`.`id`) WHERE `Album`.`user_id` = 166 AND `Album`.`type` = 'profile' ORDER BY `Album`.`id` desc LIMIT 1110
10SELECT `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`.`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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `preppers_clever1`.`albums` AS `Album` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Album`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`categories` AS `Category` ON (`Album`.`category_id` = `Category`.`id`) WHERE `Album`.`user_id` = 166 AND `Album`.`type` = 'cover' ORDER BY `Album`.`id` desc LIMIT 1111
11SELECT DISTINCT user_id FROM cake_sessions WHERE expires > 15115014821332133216
12SELECT `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `preppers_clever1`.`users` AS `User` LEFT JOIN `preppers_clever1`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `preppers_clever1`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` IN (1, 159, 6) AND `User`.`hide_online` = '0' LIMIT 12222
13SELECT `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`, `Blog`.`category_id`, `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `preppers_clever1`.`blogs` AS `Blog` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`categories` AS `Category` ON (`Blog`.`category_id` = `Category`.`id`) WHERE `Blog`.`user_id` = 166 AND `Blog`.`privacy` = 1 AND `User`.`active` = '1' ORDER BY `Blog`.`id` desc LIMIT 10001
14SELECT DISTINCT `Group`.`id`, `Group`.`name`, `Group`.`description`, `Group`.`group_user_count`, `Group`.`photo`, `Group`.`type` FROM `preppers_clever1`.`group_users` AS `GroupUser` LEFT JOIN `preppers_clever1`.`groups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `GroupUser`.`user_id` = 166 AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3) AND `Group`.`type` <> 2 ORDER BY `GroupUser`.`id` desc LIMIT 20110
15SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`group_users` AS `GroupUser` LEFT JOIN `preppers_clever1`.`groups` AS `Group` ON (`GroupUser`.`group_id` = `Group`.`id`) LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`GroupUser`.`user_id` = `User`.`id`) WHERE `GroupUser`.`group_id` = 25 AND (`GroupUser`.`status` = 1 OR `GroupUser`.`status` = 3)110
16SELECT `Video`.`id`, `Video`.`user_id`, `Video`.`category_id`, `Video`.`title`, `Video`.`description`, `Video`.`thumb`, `Video`.`destination`, `Video`.`in_process`, `Video`.`pc_upload`, `Video`.`source`, `Video`.`source_id`, `Video`.`like_count`, `Video`.`dislike_count`, `Video`.`comment_count`, `Video`.`created`, `Video`.`privacy`, `Video`.`group_id`, `Video`.`check_thumb_vimeo`, `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `preppers_clever1`.`videos` AS `Video` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Video`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`categories` AS `Category` ON (`Video`.`category_id` = `Category`.`id`) WHERE `Video`.`user_id` = 166 AND `Video`.`group_id` = 0 AND `Video`.`privacy` = 1 AND `Video`.`in_process` = '0' AND `User`.`active` = '1' ORDER BY `Video`.`id` desc LIMIT 10000
17SELECT *, `Activity`.`id` FROM `preppers_clever1`.`activities` AS `Activity` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Activity`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`user_taggings` AS `UserTagging` ON (`Activity`.`id` = `UserTagging`.`item_id` AND `UserTagging`.`item_table` = 'activities') WHERE `Activity`.`id` = 4834 ORDER BY `Activity`.`modified` desc LIMIT 1111
18SELECT `ProfileFieldValue`.`id`, `ProfileFieldValue`.`user_id`, `ProfileFieldValue`.`profile_field_id`, `ProfileFieldValue`.`value`, (`I18n`.`content`) AS `ProfileFieldValue__name`, `ProfileField`.`id`, `ProfileField`.`name`, `ProfileField`.`description`, `ProfileField`.`type`, `ProfileField`.`values`, `ProfileField`.`required`, `ProfileField`.`registration`, `ProfileField`.`searchable`, `ProfileField`.`active`, `ProfileField`.`weight`, `ProfileField`.`profile`, `ProfileField`.`plugin`, `ProfileField`.`profile_type_id` FROM `preppers_clever1`.`profile_field_values` AS `ProfileFieldValue` LEFT JOIN `preppers_clever1`.`profile_fields` AS `ProfileField` ON (`ProfileFieldValue`.`profile_field_id` = `ProfileField`.`id`) INNER JOIN `preppers_clever1`.`i18n` AS `I18n` ON (`ProfileFieldValue`.`profile_field_id` = `I18n`.`foreign_key` AND `I18n`.`locale` = 'eng' AND `I18n`.`model` = 'ProfileField') WHERE `ProfileField`.`active` = '1' AND `ProfileField`.`profile` = '1' AND `ProfileFieldValue`.`user_id` = 166 ORDER BY `ProfileField`.`weight` ASC000
19SELECT `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`.`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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `preppers_clever1`.`albums` AS `Album` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Album`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`categories` AS `Category` ON (`Album`.`category_id` = `Category`.`id`) WHERE `Album`.`privacy` = 1 AND `Album`.`photo_count` > 0 AND `Album`.`user_id` = 166 AND `User`.`active` = '1' ORDER BY `Album`.`id` desc LIMIT 10330
20SELECT *, `Activity`.`id` FROM `preppers_clever1`.`activities` AS `Activity` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Activity`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`user_taggings` AS `UserTagging` ON (`Activity`.`id` = `UserTagging`.`item_id` AND `UserTagging`.`item_table` = 'activities') WHERE `Activity`.`id` = 4834 AND `Activity`.`Plugin` IN ('Ads', 'Api', 'Billing', 'Blog', 'Contest', 'Cron', 'Event', 'Feedback', 'Feeling', 'Group', 'LatestProfileViewers', 'Livenews', 'Mail', 'Menu', 'Minify', 'MooApp', 'MooUpload', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'Photo', 'Scrolltotop', 'Slider', 'SocialIntegration', 'SocialLogin', 'SocialPublisher', 'Soundcloud', 'StatusBackground', 'Storage', 'Store', 'Subscription', 'Topic', 'UploadVideo', 'Video', '') AND `Activity`.`status` = 'ok' AND `User`.`active` = '1' AND NOT (`Activity`.`action` IN ('user_create', 'group_join', 'friend_add', 'user_avatar', 'event_attend')) ORDER BY `Activity`.`modified` desc LIMIT 12111
21SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order` FROM `preppers_clever1`.`profile_types` AS `ProfileType` WHERE `ProfileType`.`id` = 1 AND `ProfileType`.`actived` = '1'110
22SELECT `ActivityComment`.`id`, `ActivityComment`.`user_id`, `ActivityComment`.`activity_id`, `ActivityComment`.`comment`, `ActivityComment`.`like_count`, `ActivityComment`.`dislike_count`, `ActivityComment`.`created`, `ActivityComment`.`thumbnail`, `ActivityComment`.`edited` FROM `preppers_clever1`.`activity_comments` AS `ActivityComment` WHERE `ActivityComment`.`activity_id` = (4834) ORDER BY `ActivityComment`.`id` desc000
23SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`friends` AS `Friend` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Friend`.`user_id` = `User`.`id`) WHERE `user_id` = 166110
24SELECT `UserTagging`.`id`, `UserTagging`.`item_id`, `UserTagging`.`item_table`, `UserTagging`.`users_taggings`, `UserTagging`.`created`, `UserTagging`.`modified` FROM `preppers_clever1`.`user_taggings` AS `UserTagging` WHERE `UserTagging`.`users_taggings` LIKE "%166%"000
25SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`friends` AS `Friend` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Friend`.`user_id` = `User`.`id`) WHERE `Friend`.`user_id` = 166 AND `Friend`.`friend_id` = ''110
26SELECT *, `Activity`.`id` FROM `preppers_clever1`.`activities` AS `Activity` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Activity`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`user_taggings` AS `UserTagging` ON (`Activity`.`id` = `UserTagging`.`item_id` AND `UserTagging`.`item_table` = 'activities') WHERE ((((`Activity`.`user_id` = 166) AND (`Activity`.`type` = "user") AND (`Activity`.`privacy` = 1))) OR (((`Activity`.`target_id` = 166) AND (`Activity`.`type` = 'user') AND (NOT (`Activity`.`user_id` IS NULL))))) AND `Activity`.`Plugin` IN ('Ads', 'Api', 'Billing', 'Blog', 'Contest', 'Cron', 'Event', 'Feedback', 'Feeling', 'Group', 'LatestProfileViewers', 'Livenews', 'Mail', 'Menu', 'Minify', 'MooApp', 'MooUpload', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'Photo', 'Scrolltotop', 'Slider', 'SocialIntegration', 'SocialLogin', 'SocialPublisher', 'Soundcloud', 'StatusBackground', 'Storage', 'Store', 'Subscription', 'Topic', 'UploadVideo', 'Video', '') AND `Activity`.`status` = 'ok' AND `User`.`active` = '1' AND NOT (`Activity`.`action` IN ('user_create', 'group_join', 'friend_add', 'user_avatar', 'event_attend')) ORDER BY `Activity`.`modified` desc LIMIT 1212120
27SELECT `ActivityComment`.`id`, `ActivityComment`.`user_id`, `ActivityComment`.`activity_id`, `ActivityComment`.`comment`, `ActivityComment`.`like_count`, `ActivityComment`.`dislike_count`, `ActivityComment`.`created`, `ActivityComment`.`thumbnail`, `ActivityComment`.`edited` FROM `preppers_clever1`.`activity_comments` AS `ActivityComment` WHERE `ActivityComment`.`activity_id` IN (4834, 4343, 2413, 2908, 2255, 2254, 2205, 2126, 1966, 1932, 1742, 1653) ORDER BY `ActivityComment`.`id` desc550
28SELECT `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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` FROM `preppers_clever1`.`users` AS `User` WHERE `User`.`id` = 538110
29SELECT `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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` FROM `preppers_clever1`.`users` AS `User` WHERE `User`.`id` = 5110
30SELECT `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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` FROM `preppers_clever1`.`users` AS `User` WHERE `User`.`id` = 166110
31SELECT `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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` FROM `preppers_clever1`.`users` AS `User` WHERE `User`.`id` = 4110
32SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type`, `Like`.`thumb_up` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`type` = 'core_activity_comment' AND `Like`.`target_id` IN (843, 668, 667, 666, 389)220
33SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`target_id`, `Comment`.`message`, `Comment`.`created`, `Comment`.`type`, `Comment`.`like_count`, `Comment`.`dislike_count`, `Comment`.`thumbnail`, `Comment`.`edited`, `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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` FROM `preppers_clever1`.`comments` AS `Comment` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 1283 AND `Comment`.`type` = 'Photo_Photo' ORDER BY `Comment`.`id` asc000
34SELECT `Like`.`user_id`, `Like`.`thumb_up` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`target_id` = 1283 AND `Like`.`type` = 'Photo_Photo' ORDER BY `Like`.`id` desc000
35SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`target_id`, `Comment`.`message`, `Comment`.`created`, `Comment`.`type`, `Comment`.`like_count`, `Comment`.`dislike_count`, `Comment`.`thumbnail`, `Comment`.`edited`, `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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` FROM `preppers_clever1`.`comments` AS `Comment` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 889 AND `Comment`.`type` = 'Photo_Photo' ORDER BY `Comment`.`id` asc000
36SELECT `Like`.`user_id`, `Like`.`thumb_up` FROM `preppers_clever1`.`likes` AS `Like` WHERE `Like`.`target_id` = 889 AND `Like`.`type` = 'Photo_Photo' ORDER BY `Like`.`id` desc000
37SELECT `UserTagging`.`id`, `UserTagging`.`item_id`, `UserTagging`.`item_table`, `UserTagging`.`users_taggings`, `UserTagging`.`created`, `UserTagging`.`modified` FROM `preppers_clever1`.`user_taggings` AS `UserTagging` WHERE `UserTagging`.`users_taggings` LIKE "%166%"000
38SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`activities` AS `Activity` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Activity`.`user_id` = `User`.`id`) WHERE ((((`Activity`.`user_id` = 166) AND (`Activity`.`type` = "user") AND (`Activity`.`privacy` = 1))) OR (((`Activity`.`target_id` = 166) AND (`Activity`.`type` = 'user') AND (NOT (`Activity`.`user_id` IS NULL))))) AND `Activity`.`Plugin` IN ('Ads', 'Api', 'Billing', 'Blog', 'Contest', 'Cron', 'Event', 'Feedback', 'Feeling', 'Group', 'LatestProfileViewers', 'Livenews', 'Mail', 'Menu', 'Minify', 'MooApp', 'MooUpload', 'Page', 'PaymentGateway', 'PaypalAdaptive', 'PaypalExpress', 'Photo', 'Scrolltotop', 'Slider', 'SocialIntegration', 'SocialLogin', 'SocialPublisher', 'Soundcloud', 'StatusBackground', 'Storage', 'Store', 'Subscription', 'Topic', 'UploadVideo', 'Video', '') AND `Activity`.`status` = 'ok' AND `User`.`active` = '1' AND NOT (`Activity`.`action` IN ('user_create', 'group_join', 'friend_add', 'user_avatar', 'event_attend'))110
39SELECT `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 `preppers_clever1`.`categories` AS `Category` INNER JOIN `preppers_clever1`.`i18n` 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` asc12120
40SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `preppers_clever1`.`i18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (4, 6, 7, 8, 9, 84, 82, 83, 85, 86, 80, 87) ORDER BY `id` ASC12120
41SELECT DISTINCT user_id FROM cake_sessions WHERE expires > 1511501482133213320
42SELECT `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `preppers_clever1`.`users` AS `User` LEFT JOIN `preppers_clever1`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `preppers_clever1`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `User`.`id` IN (1, 159, 6) AND `User`.`hide_online` = '0' LIMIT 40220
43SELECT `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `preppers_clever1`.`users` AS `User` LEFT JOIN `preppers_clever1`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `preppers_clever1`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `active` = '1' ORDER BY `User`.`id` desc LIMIT 3030300
44SELECT `Feedback`.`id`, `Feedback`.`user_id`, `Feedback`.`title`, `Feedback`.`body`, `Feedback`.`email`, `Feedback`.`fullname`, `Feedback`.`privacy`, `Feedback`.`created`, `Feedback`.`modified`, `Feedback`.`category_id`, `Feedback`.`severity_id`, `Feedback`.`status_id`, `Feedback`.`status_body`, `Feedback`.`album_id`, `Feedback`.`views`, `Feedback`.`comment_count`, `Feedback`.`dislike_count`, `Feedback`.`like_count`, `Feedback`.`total_votes`, `Feedback`.`total_images`, `Feedback`.`featured`, `Feedback`.`approved`, `Feedback`.`ip_address`, `Feedback`.`anonymous_email`, `Feedback`.`anonymous_name`, `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `FeedbackStatus`.`id`, `FeedbackStatus`.`name`, `FeedbackStatus`.`color`, `FeedbackStatus`.`default_comment`, `FeedbackStatus`.`use_time`, `FeedbackStatus`.`is_active`, `FeedbackCategory`.`id`, `FeedbackCategory`.`name`, `FeedbackCategory`.`description`, `FeedbackCategory`.`use_time`, `FeedbackCategory`.`is_active`, `FeedbackSeverity`.`id`, `FeedbackSeverity`.`user_id`, `FeedbackSeverity`.`name`, `FeedbackSeverity`.`use_time`, `FeedbackSeverity`.`is_active` FROM `preppers_clever1`.`feedback` AS `Feedback` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Feedback`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`feedback_statuses` AS `FeedbackStatus` ON (`Feedback`.`status_id` = `FeedbackStatus`.`id`) LEFT JOIN `preppers_clever1`.`feedback_categories` AS `FeedbackCategory` ON (`Feedback`.`category_id` = `FeedbackCategory`.`id`) LEFT JOIN `preppers_clever1`.`feedback_severities` AS `FeedbackSeverity` ON (`Feedback`.`severity_id` = `FeedbackSeverity`.`id`) WHERE `Feedback`.`privacy` = 1 AND `Feedback`.`approved` = '1' ORDER BY `total_votes` DESC LIMIT 10440
45SELECT `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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`, `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core` FROM `preppers_clever1`.`users` AS `User` LEFT JOIN `preppers_clever1`.`profile_types` AS `ProfileType` ON (`User`.`profile_type_id` = `ProfileType`.`id` AND `ProfileType`.`actived` = '1') LEFT JOIN `preppers_clever1`.`roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `active` = '1' AND `featured` = '1' ORDER BY `User`.`id` desc LIMIT 3021210
46SELECT `Friend`.`id`, `Friend`.`user_id`, `Friend`.`friend_id`, `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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` FROM `preppers_clever1`.`friends` AS `Friend` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Friend`.`friend_id` = `User`.`id`) WHERE `Friend`.`user_id` = 166 AND `User`.`active` = '1' AND NOT (`Friend`.`friend_id` IS NULL) ORDER BY `User`.`name` asc LIMIT 100220
47SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`event_rsvps` AS `EventRsvp` LEFT JOIN `preppers_clever1`.`events` AS `Event` ON (`EventRsvp`.`event_id` = `Event`.`id`) LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`EventRsvp`.`user_id` = `User`.`id`) WHERE ((((`EventRsvp`.`user_id` = 166) AND ((rsvp = 1 OR rsvp = 3)))) OR (`Event`.`user_id` = 166)) GROUP BY `Event`.`id`000
48SELECT COUNT(*) AS `count` FROM `preppers_clever1`.`contests` AS `Contest` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Contest`.`user_id` = `User`.`id`) LEFT JOIN `preppers_clever1`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Contest`.`approve_status` = 'approved' AND `Contest`.`contest_status` <> 'draft' AND `Contest`.`privacy` = 1 AND `Contest`.`user_id` = 166110
49SELECT `CommentHistory`.`id`, `CommentHistory`.`user_id`, `CommentHistory`.`content`, `CommentHistory`.`created`, `CommentHistory`.`photo`, `CommentHistory`.`type`, `CommentHistory`.`target_id`, `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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` FROM `preppers_clever1`.`comment_histories` AS `CommentHistory` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`CommentHistory`.`user_id` = `User`.`id`) WHERE `type` = 'activity' AND `target_id` = 4834 ORDER BY `CommentHistory`.`id` desc LIMIT 1000
50SELECT `StatusBackground`.`id`, `StatusBackground`.`width`, `StatusBackground`.`height`, `StatusBackground`.`max_height`, `StatusBackground`.`type`, `StatusBackground`.`text_color`, `StatusBackground`.`style`, `StatusBackground`.`color`, `StatusBackground`.`gradient`, `StatusBackground`.`thumbnail`, `StatusBackground`.`active`, `StatusBackground`.`order` FROM `preppers_clever1`.`status_backgrounds` AS `StatusBackground` WHERE `StatusBackground`.`id` = 2 LIMIT 1110
51SELECT `AdsPlacementFeed`.`id`, `AdsPlacementFeed`.`ads_placement_id`, `AdsPlacementFeed`.`feed_position`, `AdsPlacement`.`id`, `AdsPlacement`.`user_id`, `AdsPlacement`.`placement_type`, `AdsPlacement`.`ads_position_id`, `AdsPlacement`.`name`, `AdsPlacement`.`description`, `AdsPlacement`.`dimension_width`, `AdsPlacement`.`dimension_height`, `AdsPlacement`.`price`, `AdsPlacement`.`period`, `AdsPlacement`.`view_limit`, `AdsPlacement`.`click_limit`, `AdsPlacement`.`number_of_ads`, `AdsPlacement`.`total_ads`, `AdsPlacement`.`enable`, `AdsPlacement`.`created`, `AdsPlacement`.`updated` FROM `preppers_clever1`.`ads_placement_feeds` AS `AdsPlacementFeed` LEFT JOIN `preppers_clever1`.`ads_placements` AS `AdsPlacement` ON (`AdsPlacementFeed`.`ads_placement_id` = `AdsPlacement`.`id`) WHERE `AdsPlacementFeed`.`feed_position` = 1 AND `AdsPlacement`.`enable` = '1' AND `AdsPlacement`.`placement_type` = 'feed'000
52SELECT `Friend`.`id`, `Friend`.`user_id`, `Friend`.`friend_id`, `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`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`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`.`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` FROM `preppers_clever1`.`friends` AS `Friend` LEFT JOIN `preppers_clever1`.`users` AS `User` ON (`Friend`.`friend_id` = `User`.`id`) WHERE `Friend`.`user_id` IS NULL AND `User`.`active` = '1' AND NOT (`Friend`.`friend_id` IS NULL) ORDER BY `User`.`name` asc LIMIT 10000
53SELECT `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 `preppers_clever1`.`settings` AS `Setting` LEFT JOIN `preppers_clever1`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1110
54SELECT `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 `preppers_clever1`.`settings` AS `Setting` LEFT JOIN `preppers_clever1`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1110