john's Friends

Invite a Friend to DivorceNetwork

(default) 110 queries took 47 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`771
2DESCRIBE `acos`771
3DESCRIBE `aros_acos`771
4DESCRIBE `members`20202
5DESCRIBE `relationship_statuses`441
6DESCRIBE `zipcodes`991
7DESCRIBE `images`991
8DESCRIBE `posts`16162
9DESCRIBE `post_types`551
10DESCRIBE `events`15152
11DESCRIBE `event_attendees`661
12DESCRIBE `groups_users`771
13DESCRIBE `groups`991
14DESCRIBE `friends`991
15DESCRIBE `group_posts`551
16DESCRIBE `post_recipients`551
17DESCRIBE `post_comments`771
18DESCRIBE `photo_collections`11111
19DESCRIBE `photo_collection_items`661
20DESCRIBE `photos`881
21DESCRIBE `referrals`771
22SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted`, `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass`, `RelationshipStatus`.`id`, `RelationshipStatus`.`name`, `RelationshipStatus`.`created`, `RelationshipStatus`.`modified`, `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `members` AS `Member` LEFT JOIN `zipcodes` AS `Zipcode` ON (`Member`.`zip_code` = `Zipcode`.`zip`) LEFT JOIN `relationship_statuses` AS `RelationshipStatus` ON (`Member`.`relationship_status_id` = `RelationshipStatus`.`id`) LEFT JOIN `images` AS `ProfileImage` ON (`ProfileImage`.`member_id` = `Member`.`id` AND `ProfileImage`.`profile_image` = 1) WHERE `Member`.`username` = 'john' LIMIT 1110
23SELECT `Friends`.`id`, `Friends`.`member_id`, `Friends`.`friend_id`, `Friends`.`approved`, `Friends`.`rejected`, `Friends`.`ignored`, `Friends`.`viewed`, `Friends`.`created`, `Friends`.`modified` FROM `friends` AS `Friends` WHERE `Friends`.`member_id` = (1027) 330
24SELECT `Events`.`event_id`, `Events`.`creator_member_id`, `Events`.`access_level`, `Events`.`event_name`, `Events`.`start_date`, `Events`.`end_date`, `Events`.`addr1`, `Events`.`addr2`, `Events`.`city`, `Events`.`state`, `Events`.`zip`, `Events`.`description`, `Events`.`created`, `Events`.`modified`, `Events`.`deleted`, `EventAttendee`.`id`, `EventAttendee`.`invite_key`, `EventAttendee`.`event_id`, `EventAttendee`.`member_id`, `EventAttendee`.`status`, `EventAttendee`.`guest_email` FROM `events` AS `Events` JOIN `event_attendees` AS `EventAttendee` ON (`EventAttendee`.`member_id` = 1027 AND `EventAttendee`.`event_id` = `Events`.`event_id`) WHERE 1 = 1 LIMIT 5000
25SELECT `Friends`.`id`, `Friends`.`member_id`, `Friends`.`friend_id`, `Friends`.`approved`, `Friends`.`rejected`, `Friends`.`ignored`, `Friends`.`viewed`, `Friends`.`created`, `Friends`.`modified`, `Requestor`.`id`, `Requestor`.`username`, `Requestor`.`password`, `Requestor`.`email`, `Requestor`.`gender`, `Requestor`.`zip_code`, `Requestor`.`relationship_status_id`, `Requestor`.`registration_key`, `Requestor`.`verified`, `Requestor`.`date_of_birth`, `Requestor`.`sexual_orientation`, `Requestor`.`story`, `Requestor`.`first_name`, `Requestor`.`last_name`, `Requestor`.`created`, `Requestor`.`modified`, `Requestor`.`last_active`, `Requestor`.`display_name`, `Requestor`.`super_admin`, `Requestor`.`deleted`, `Requestee`.`id`, `Requestee`.`username`, `Requestee`.`password`, `Requestee`.`email`, `Requestee`.`gender`, `Requestee`.`zip_code`, `Requestee`.`relationship_status_id`, `Requestee`.`registration_key`, `Requestee`.`verified`, `Requestee`.`date_of_birth`, `Requestee`.`sexual_orientation`, `Requestee`.`story`, `Requestee`.`first_name`, `Requestee`.`last_name`, `Requestee`.`created`, `Requestee`.`modified`, `Requestee`.`last_active`, `Requestee`.`display_name`, `Requestee`.`super_admin`, `Requestee`.`deleted`, `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `friends` AS `Friends` LEFT JOIN `members` AS `Requestor` ON (`Friends`.`member_id` = `Requestor`.`id`) LEFT JOIN `members` AS `Requestee` ON (`Friends`.`friend_id` = `Requestee`.`id`) LEFT JOIN `members` AS `Member` ON (`Friends`.`member_id` = `Member`.`id`) WHERE `friend_id` = 1027 AND `approved` = 0 AND `rejected` = 0 AND `ignored` = 0 LIMIT 20000
26SELECT `Friends`.`id`, `Friends`.`member_id`, `Friends`.`friend_id`, `Friends`.`approved`, `Friends`.`rejected`, `Friends`.`ignored`, `Friends`.`viewed`, `Friends`.`created`, `Friends`.`modified`, `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `friends` AS `Friends` LEFT JOIN `members` AS `Member` ON (`Friends`.`friend_id` = `Member`.`id`) WHERE `member_id` = 1027 AND `rejected` = 0 AND `ignored` = 0 ORDER BY `Member`.`display_name` ASC LIMIT 10330
27SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 11 110
28SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = 44095 110
29SELECT `RelationshipStatus`.`id`, `RelationshipStatus`.`name`, `RelationshipStatus`.`created`, `RelationshipStatus`.`modified` FROM `relationship_statuses` AS `RelationshipStatus` WHERE `RelationshipStatus`.`id` = 1 110
30SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 11 AND `ProfileImage`.`profile_image` = 1 000
31SELECT `Events`.`event_id`, `Events`.`creator_member_id`, `Events`.`access_level`, `Events`.`event_name`, `Events`.`start_date`, `Events`.`end_date`, `Events`.`addr1`, `Events`.`addr2`, `Events`.`city`, `Events`.`state`, `Events`.`zip`, `Events`.`description`, `Events`.`created`, `Events`.`modified`, `Events`.`deleted`, `EventAttendee`.`id`, `EventAttendee`.`invite_key`, `EventAttendee`.`event_id`, `EventAttendee`.`member_id`, `EventAttendee`.`status`, `EventAttendee`.`guest_email` FROM `events` AS `Events` JOIN `event_attendees` AS `EventAttendee` ON (`EventAttendee`.`member_id` = 11 AND `EventAttendee`.`event_id` = `Events`.`event_id`) WHERE 1 = 1 LIMIT 5000
32SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 6 110
33SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = 44685 110
34SELECT `RelationshipStatus`.`id`, `RelationshipStatus`.`name`, `RelationshipStatus`.`created`, `RelationshipStatus`.`modified` FROM `relationship_statuses` AS `RelationshipStatus` WHERE `RelationshipStatus`.`id` = 4 110
35SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 6 AND `ProfileImage`.`profile_image` = 1 110
36SELECT `Events`.`event_id`, `Events`.`creator_member_id`, `Events`.`access_level`, `Events`.`event_name`, `Events`.`start_date`, `Events`.`end_date`, `Events`.`addr1`, `Events`.`addr2`, `Events`.`city`, `Events`.`state`, `Events`.`zip`, `Events`.`description`, `Events`.`created`, `Events`.`modified`, `Events`.`deleted`, `EventAttendee`.`id`, `EventAttendee`.`invite_key`, `EventAttendee`.`event_id`, `EventAttendee`.`member_id`, `EventAttendee`.`status`, `EventAttendee`.`guest_email` FROM `events` AS `Events` JOIN `event_attendees` AS `EventAttendee` ON (`EventAttendee`.`member_id` = 6 AND `EventAttendee`.`event_id` = `Events`.`event_id`) WHERE 1 = 1 LIMIT 5000
37SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2227 110
38SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = 55413 110
39SELECT `RelationshipStatus`.`id`, `RelationshipStatus`.`name`, `RelationshipStatus`.`created`, `RelationshipStatus`.`modified` FROM `relationship_statuses` AS `RelationshipStatus` WHERE `RelationshipStatus`.`id` = 3 110
40SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2227 AND `ProfileImage`.`profile_image` = 1 110
41SELECT `Events`.`event_id`, `Events`.`creator_member_id`, `Events`.`access_level`, `Events`.`event_name`, `Events`.`start_date`, `Events`.`end_date`, `Events`.`addr1`, `Events`.`addr2`, `Events`.`city`, `Events`.`state`, `Events`.`zip`, `Events`.`description`, `Events`.`created`, `Events`.`modified`, `Events`.`deleted`, `EventAttendee`.`id`, `EventAttendee`.`invite_key`, `EventAttendee`.`event_id`, `EventAttendee`.`member_id`, `EventAttendee`.`status`, `EventAttendee`.`guest_email` FROM `events` AS `Events` JOIN `event_attendees` AS `EventAttendee` ON (`EventAttendee`.`member_id` = 2227 AND `EventAttendee`.`event_id` = `Events`.`event_id`) WHERE 1 = 1 LIMIT 5000
42SELECT `Friends`.`id`, `Friends`.`member_id`, `Friends`.`friend_id`, `Friends`.`approved`, `Friends`.`rejected`, `Friends`.`ignored`, `Friends`.`viewed`, `Friends`.`created`, `Friends`.`modified`, `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `friends` AS `Friends` LEFT JOIN `members` AS `Member` ON (`Friends`.`member_id` = `Member`.`id`) WHERE `friend_id` = 1027 AND `approved` = 0 AND `rejected` = 0 AND `ignored` = 0 LIMIT 20000
43SELECT `Friends`.`id`, `Member`.`display_name` FROM `friends` AS `Friends` LEFT JOIN `members` AS `Member` ON (`Friends`.`friend_id` = `Member`.`id`) WHERE `member_id` = 1027 AND `rejected` = 0 AND `ignored` = 0 ORDER BY `Member`.`display_name` ASC 330
44SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`deleted` = 0 ORDER BY `Member`.`created` DESC LIMIT 4440
45SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2350 AND `Image`.`profile_image` = 1 LIMIT 1000
46SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '48706' LIMIT 1110
47SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2349 AND `Image`.`profile_image` = 1 LIMIT 1000
48SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '85204' LIMIT 1110
49SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2348 AND `Image`.`profile_image` = 1 LIMIT 1000
50SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '90015' LIMIT 1110
51SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2347 AND `Image`.`profile_image` = 1 LIMIT 1000
52SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '93726' LIMIT 1110
53SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`deleted` = 0 ORDER BY `last_active` DESC LIMIT 5550
54SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 1683 AND `Image`.`profile_image` = 1 LIMIT 1000
55SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '11111' LIMIT 1000
56SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 6 AND `Image`.`profile_image` = 1 LIMIT 1110
57SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '44685' LIMIT 1110
58SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 1084 AND `Image`.`profile_image` = 1 LIMIT 1000
59SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '44240' LIMIT 1110
60SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2199 AND `Image`.`profile_image` = 1 LIMIT 1000
61SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '21776' LIMIT 1110
62SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`member_id` = 2228 AND `Image`.`profile_image` = 1 LIMIT 1110
63SELECT `Zipcode`.`id`, `Zipcode`.`zip`, `Zipcode`.`latitude`, `Zipcode`.`longitude`, `Zipcode`.`city`, `Zipcode`.`state`, `Zipcode`.`fullstate`, `Zipcode`.`county`, `Zipcode`.`zipclass` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '11758' LIMIT 1110
64DESCRIBE `blogs`19192
65DESCRIBE `blog_series`19192
66DESCRIBE `blogs_comments`771
67DESCRIBE `tags`441
68DESCRIBE `blogs_tags`221
69DESCRIBE `pages`19192
70DESCRIBE `pages_comments`661
71DESCRIBE `pages_tags`221
72SELECT `Blog`.`id`, `Blog`.`external_id`, `Blog`.`member_id`, `Blog`.`title`, `Blog`.`page_seo`, `Blog`.`description`, `Blog`.`tags`, `Blog`.`metatitle`, `Blog`.`metadescription`, `Blog`.`metakeywords`, `Blog`.`featured`, `Blog`.`published`, `Blog`.`original_content`, `Blog`.`content`, `Blog`.`created`, `Blog`.`modified`, `Blog`.`deleted`, `Blog`.`blog_series_id`, `Blog`.`top_count`, `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted`, `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blogs` AS `Blog` LEFT JOIN `members` AS `Member` ON (`Blog`.`member_id` = `Member`.`id`) LEFT JOIN `blog_series` AS `BlogSeries` ON (`Blog`.`blog_series_id` = `BlogSeries`.`id`) WHERE 1 = 1 ORDER BY `Blog`.`created` DESC LIMIT 5551
73SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2228 110
74SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2228 AND `ProfileImage`.`profile_image` = 1 110
75SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2149 110
76SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2149 AND `ProfileImage`.`profile_image` = 1 110
77SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2181 110
78SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2181 AND `ProfileImage`.`profile_image` = 1 110
79SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2307 110
80SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2307 AND `ProfileImage`.`profile_image` = 1 110
81SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2307 110
82SELECT `ProfileImage`.`id`, `ProfileImage`.`image_path`, `ProfileImage`.`thumbnail_path`, `ProfileImage`.`member_id`, `ProfileImage`.`profile_image`, `ProfileImage`.`album_id`, `ProfileImage`.`page_id`, `ProfileImage`.`created`, `ProfileImage`.`modified` FROM `images` AS `ProfileImage` WHERE `ProfileImage`.`member_id` = 2307 AND `ProfileImage`.`profile_image` = 1 110
83SELECT `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blog_series` AS `BlogSeries` WHERE `BlogSeries`.`id` = 100005 110
84SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2228 110
85SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`id` = 130 110
86SELECT `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blog_series` AS `BlogSeries` WHERE `BlogSeries`.`id` = 7 110
87SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2149 110
88SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`id` = 40 110
89SELECT `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blog_series` AS `BlogSeries` WHERE `BlogSeries`.`id` = 13 110
90SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2181 110
91SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`id` = 56 110
92SELECT `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blog_series` AS `BlogSeries` WHERE `BlogSeries`.`id` = 100014 110
93SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2307 110
94SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`id` = 195 110
95SELECT `BlogSeries`.`id`, `BlogSeries`.`member_id`, `BlogSeries`.`name`, `BlogSeries`.`description`, `BlogSeries`.`page_seo`, `BlogSeries`.`metatitle`, `BlogSeries`.`metadescription`, `BlogSeries`.`metakeywords`, `BlogSeries`.`featured`, `BlogSeries`.`sponsored`, `BlogSeries`.`sponsor_dn`, `BlogSeries`.`sponsor_name`, `BlogSeries`.`sponsor_message`, `BlogSeries`.`sponsor_url`, `BlogSeries`.`top_count`, `BlogSeries`.`created`, `BlogSeries`.`modified`, `BlogSeries`.`deleted`, `BlogSeries`.`image_id` FROM `blog_series` AS `BlogSeries` WHERE `BlogSeries`.`id` = 100014 110
96SELECT `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted` FROM `members` AS `Member` WHERE `Member`.`id` = 2307 110
97SELECT `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `images` AS `Image` WHERE `Image`.`id` = 195 110
98SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified`, `BlogsTag`.`blog_id`, `BlogsTag`.`tag_id` FROM `tags` AS `Tag` JOIN `blogs_tags` AS `BlogsTag` ON (`BlogsTag`.`blog_id` IN (115, 114, 113, 112, 111) AND `BlogsTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 11110
99SELECT `Events`.`event_id`, `Events`.`creator_member_id`, `Events`.`access_level`, `Events`.`event_name`, `Events`.`start_date`, `Events`.`end_date`, `Events`.`addr1`, `Events`.`addr2`, `Events`.`city`, `Events`.`state`, `Events`.`zip`, `Events`.`description`, `Events`.`created`, `Events`.`modified`, `Events`.`deleted` FROM `events` AS `Events` WHERE `Events`.`start_date` >= 1283745600 AND `Events`.`deleted` = 0 ORDER BY `Events`.`event_name` ASC LIMIT 5000
100SELECT `Page`.`id`, `Page`.`title`, `Page`.`page_seo`, `Page`.`category_id`, `Page`.`subcategory_id`, `Page`.`description`, `Page`.`content`, `Page`.`metatitle`, `Page`.`metadescription`, `Page`.`metakeywords`, `Page`.`tags`, `Page`.`published`, `Page`.`featured`, `Page`.`system`, `Page`.`sitemap`, `Page`.`member_id`, `Page`.`created`, `Page`.`modified`, `Page`.`top_article_count`, `Member`.`id`, `Member`.`username`, `Member`.`password`, `Member`.`email`, `Member`.`gender`, `Member`.`zip_code`, `Member`.`relationship_status_id`, `Member`.`registration_key`, `Member`.`verified`, `Member`.`date_of_birth`, `Member`.`sexual_orientation`, `Member`.`story`, `Member`.`first_name`, `Member`.`last_name`, `Member`.`created`, `Member`.`modified`, `Member`.`last_active`, `Member`.`display_name`, `Member`.`super_admin`, `Member`.`deleted`, `Image`.`id`, `Image`.`image_path`, `Image`.`thumbnail_path`, `Image`.`member_id`, `Image`.`profile_image`, `Image`.`album_id`, `Image`.`page_id`, `Image`.`created`, `Image`.`modified` FROM `pages` AS `Page` LEFT JOIN `members` AS `Member` ON (`Page`.`member_id` = `Member`.`id`) LEFT JOIN `images` AS `Image` ON (`Image`.`page_id` = `Page`.`id`) WHERE `featured` = 1 AND `published` = 1 ORDER BY `Page`.`top_article_count` ASC, `Page`.`created` DESC LIMIT 5448
101SELECT `PagesComment`.`id`, `PagesComment`.`page_id`, `PagesComment`.`member_id`, `PagesComment`.`text`, `PagesComment`.`created`, `PagesComment`.`deleted` FROM `pages_comments` AS `PagesComment` WHERE `PagesComment`.`page_id` IN (100068, 100071, 100070, 100069) ORDER BY `PagesComment`.`created` DESC 000
102SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified`, `PagesTag`.`page_id`, `PagesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `pages_tags` AS `PagesTag` ON (`PagesTag`.`page_id` IN (100068, 100071, 100070, 100069) AND `PagesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 12120
103UPDATE `pages` AS `Page` LEFT JOIN `members` AS `Member` ON (`Page`.`member_id` = `Member`.`id`) SET `Page`.`top_article_count` = 11894 WHERE `Page`.`id` = 10006811
104SELECT COUNT(*) AS `count` FROM `friends` AS `Friend` LEFT JOIN `members` AS `Requestor` ON (`Friend`.`member_id` = `Requestor`.`id`) LEFT JOIN `members` AS `Requestee` ON (`Friend`.`friend_id` = `Requestee`.`id`) WHERE `Friend`.`approved` = 0 AND `Friend`.`rejected` = 0 AND `Friend`.`ignored` = 0 AND `Friend`.`friend_id` IS NULL 110
105SELECT COUNT(*) AS `count` FROM `friends` AS `Friend` LEFT JOIN `members` AS `Requestor` ON (`Friend`.`member_id` = `Requestor`.`id`) LEFT JOIN `members` AS `Requestee` ON (`Friend`.`friend_id` = `Requestee`.`id`) WHERE `Friend`.`approved` = 0 AND `Friend`.`rejected` = 0 AND `Friend`.`ignored` = 0 AND `Friend`.`friend_id` IS NULL AND `Friend`.`viewed` = 0 110
106DESCRIBE `he_said_she_saids`881
107DESCRIBE `he_said_she_saids_comments`881
108SELECT `HeSaidSheSaid`.`id`, `HeSaidSheSaid`.`page_seo`, `HeSaidSheSaid`.`question`, `HeSaidSheSaid`.`hesaid_text`, `HeSaidSheSaid`.`shesaid_text`, `HeSaidSheSaid`.`published`, `HeSaidSheSaid`.`created`, `HeSaidSheSaid`.`modified` FROM `he_said_she_saids` AS `HeSaidSheSaid` WHERE 1 = 1 ORDER BY `created` DESC LIMIT 1110
109SELECT COUNT(*) AS `count` FROM `he_said_she_saids_comments` AS `HeSaidSheSaidsComment` LEFT JOIN `he_said_she_saids` AS `HeSaidSheSaid` ON (`HeSaidSheSaidsComment`.`he_said_she_said_id` = `HeSaidSheSaid`.`id`) LEFT JOIN `members` AS `Member` ON (`HeSaidSheSaidsComment`.`member_id` = `Member`.`id`) WHERE `he_said_she_said_id` = 5 AND `comment_type` = 1 110
110SELECT COUNT(*) AS `count` FROM `he_said_she_saids_comments` AS `HeSaidSheSaidsComment` LEFT JOIN `he_said_she_saids` AS `HeSaidSheSaid` ON (`HeSaidSheSaidsComment`.`he_said_she_said_id` = `HeSaidSheSaid`.`id`) LEFT JOIN `members` AS `Member` ON (`HeSaidSheSaidsComment`.`member_id` = `Member`.`id`) WHERE `he_said_she_said_id` = 5 AND `comment_type` = 2 110