nancyjh87's Groups

DIVORCE PROPERTY HELP

Invite a Friend to DivorceNetwork

kandmmomFemale
CeltMale, Bay City, MI
christianh72Male, Mesa, AZ
kellybMale, Los Angeles, CA

» He Said She Said

Should counseling be mandatory before filing for divorce?

0 for him

2 for her

See answers & respond »
» Poll of the Week
» I Got Screwed...

I got screwed.....by my Ex
..by my Lawyer
..by my Judge
..by my Friends
..by my Family
..by my:

» Recent Blogs
- 7 Lessons to Learn from the BP Oil Spill By: DivorceCoachLori
- Pain is Inevitable, But Suffering is Not. By: OneJourney
- Are you a Survivor or Enhancer? By: OneJourney
See more blogs »
» Upcoming Events
See more events »
» Recent Articles
- Losing Love Has Similarities to Addiction
  
  The aftermath to a Romantic Breakup Is Marked by...
- The Role of Fertility in Marriage and Divorce
  
  Does fertility play a role in marriage and...
See more articles »

(default) 105 queries took 80 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `aros`	7	7	1
2	DESCRIBE `acos`	7	7	1
3	DESCRIBE `aros_acos`	7	7	1
4	DESCRIBE `members`	20	20	2
5	DESCRIBE `relationship_statuses`	4	4	1
6	DESCRIBE `zipcodes`	9	9	1
7	DESCRIBE `images`	9	9	1
8	DESCRIBE `posts`	16	16	2
9	DESCRIBE `post_types`	5	5	1
10	DESCRIBE `events`	15	15	2
11	DESCRIBE `event_attendees`	6	6	1
12	DESCRIBE `groups_users`	7	7	1
13	DESCRIBE `groups`	9	9	2
14	DESCRIBE `friends`	9	9	1
15	DESCRIBE `group_posts`	5	5	1
16	DESCRIBE `post_recipients`	5	5	1
17	DESCRIBE `post_comments`	7	7	1
18	DESCRIBE `photo_collections`	11	11	2
19	DESCRIBE `photo_collection_items`	6	6	1
20	DESCRIBE `photos`	8	8	1
21	DESCRIBE `referrals`	7	7	1
22	DESCRIBE `groups_invites`	10	10	1
23	SELECT `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` = 'nancyjh87' LIMIT 1	1	1	19
24	SELECT `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` = (2265)	281	281	1
25	SELECT `GroupInvites`.`id`, `GroupInvites`.`group_id`, `GroupInvites`.`member_id`, `GroupInvites`.`invitee_id`, `GroupInvites`.`message`, `GroupInvites`.`approved`, `GroupInvites`.`rejected`, `GroupInvites`.`ignored`, `GroupInvites`.`created`, `GroupInvites`.`modified` FROM `groups_invites` AS `GroupInvites` WHERE `GroupInvites`.`member_id` = (2265)	550	550	3
26	SELECT `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` = 2265 AND `EventAttendee`.`event_id` = `Events`.`event_id`) WHERE 1 = 1 LIMIT 5	0	0	0
27	SELECT `GroupsUsers`.`id`, `GroupsUsers`.`group_id`, `GroupsUsers`.`member_id`, `GroupsUsers`.`admin`, `GroupsUsers`.`confirm_id`, `GroupsUsers`.`joined`, `GroupsUsers`.`removed`, `Groups`.`group_id`, `Groups`.`name`, `Groups`.`short_name`, `Groups`.`description`, `Groups`.`zip_code`, `Groups`.`private`, `Groups`.`created`, `Groups`.`modified`, `Groups`.`deleted` FROM `groups_users` AS `GroupsUsers` LEFT JOIN `groups` AS `Groups` ON (`GroupsUsers`.`group_id` = `Groups`.`group_id`) WHERE `GroupsUsers`.`member_id` = 2265 AND `GroupsUsers`.`removed` = 0	1	1	1
28	SELECT `Groups`.`group_id`, `Groups`.`name`, `Groups`.`short_name`, `Groups`.`description`, `Groups`.`zip_code`, `Groups`.`private`, `Groups`.`created`, `Groups`.`modified`, `Groups`.`deleted` FROM `groups` AS `Groups` WHERE `Groups`.`group_id` = 7	1	1	1
29	SELECT `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` = 21231	1	1	0
30	SELECT `Owner`.`id`, `Owner`.`group_id`, `Owner`.`member_id`, `Owner`.`admin`, `Owner`.`confirm_id`, `Owner`.`joined`, `Owner`.`removed` FROM `groups_users` AS `Owner` WHERE `Owner`.`group_id` = 7 AND `admin` = 1	1	1	1
31	SELECT `GroupsUsers`.`id`, `GroupsUsers`.`group_id`, `GroupsUsers`.`member_id`, `GroupsUsers`.`admin`, `GroupsUsers`.`confirm_id`, `GroupsUsers`.`joined`, `GroupsUsers`.`removed` FROM `groups_users` AS `GroupsUsers` WHERE `removed` = 0 AND `GroupsUsers`.`group_id` = (7)	1	1	1
32	SELECT `GroupsUsers`.`id`, `GroupsUsers`.`group_id`, `GroupsUsers`.`member_id`, `GroupsUsers`.`admin`, `GroupsUsers`.`confirm_id`, `GroupsUsers`.`joined`, `GroupsUsers`.`removed`, `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`, `Groups`.`group_id`, `Groups`.`name`, `Groups`.`short_name`, `Groups`.`description`, `Groups`.`zip_code`, `Groups`.`private`, `Groups`.`created`, `Groups`.`modified`, `Groups`.`deleted` FROM `groups_users` AS `GroupsUsers` LEFT JOIN `members` AS `Member` ON (`GroupsUsers`.`member_id` = `Member`.`id`) LEFT JOIN `groups` AS `Groups` ON (`GroupsUsers`.`group_id` = `Groups`.`group_id`) WHERE `GroupsUsers`.`group_id` = 7 AND `GroupsUsers`.`removed` = 0 AND `GroupsUsers`.`member_id` != 2265	0	0	1
33	SELECT `GroupsInvites`.`id`, `GroupsInvites`.`group_id`, `GroupsInvites`.`member_id`, `GroupsInvites`.`invitee_id`, `GroupsInvites`.`message`, `GroupsInvites`.`approved`, `GroupsInvites`.`rejected`, `GroupsInvites`.`ignored`, `GroupsInvites`.`created`, `GroupsInvites`.`modified`, `Group`.`group_id`, `Group`.`name`, `Group`.`short_name`, `Group`.`description`, `Group`.`zip_code`, `Group`.`private`, `Group`.`created`, `Group`.`modified`, `Group`.`deleted`, `Inviter`.`id`, `Inviter`.`username`, `Inviter`.`password`, `Inviter`.`email`, `Inviter`.`gender`, `Inviter`.`zip_code`, `Inviter`.`relationship_status_id`, `Inviter`.`registration_key`, `Inviter`.`verified`, `Inviter`.`date_of_birth`, `Inviter`.`sexual_orientation`, `Inviter`.`story`, `Inviter`.`first_name`, `Inviter`.`last_name`, `Inviter`.`created`, `Inviter`.`modified`, `Inviter`.`last_active`, `Inviter`.`display_name`, `Inviter`.`super_admin`, `Inviter`.`deleted`, `Invitee`.`id`, `Invitee`.`username`, `Invitee`.`password`, `Invitee`.`email`, `Invitee`.`gender`, `Invitee`.`zip_code`, `Invitee`.`relationship_status_id`, `Invitee`.`registration_key`, `Invitee`.`verified`, `Invitee`.`date_of_birth`, `Invitee`.`sexual_orientation`, `Invitee`.`story`, `Invitee`.`first_name`, `Invitee`.`last_name`, `Invitee`.`created`, `Invitee`.`modified`, `Invitee`.`last_active`, `Invitee`.`display_name`, `Invitee`.`super_admin`, `Invitee`.`deleted` FROM `groups_invites` AS `GroupsInvites` LEFT JOIN `groups` AS `Group` ON (`GroupsInvites`.`group_id` = `Group`.`group_id`) LEFT JOIN `members` AS `Inviter` ON (`GroupsInvites`.`member_id` = `Inviter`.`id`) LEFT JOIN `members` AS `Invitee` ON (`GroupsInvites`.`invitee_id` = `Invitee`.`id`) WHERE `invitee_id` = 2265 AND `approved` = 0 AND `rejected` = 0 AND `ignored` = 0	0	0	2
34	SELECT `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 4	4	4	0
35	SELECT `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` = 2351 AND `Image`.`profile_image` = 1 LIMIT 1	0	0	0
36	SELECT `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` = '92011' LIMIT 1	0	0	0
37	SELECT `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 1	0	0	0
38	SELECT `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 1	1	1	0
39	SELECT `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 1	0	0	0
40	SELECT `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 1	1	1	0
41	SELECT `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 1	0	0	0
42	SELECT `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 1	1	1	0
43	SELECT `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 5	5	5	0
44	SELECT `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` = 2351 AND `Image`.`profile_image` = 1 LIMIT 1	0	0	0
45	SELECT `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` = '92011' LIMIT 1	0	0	0
46	SELECT `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 1	0	0	0
47	SELECT `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 1	0	0	0
48	SELECT `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 1	1	1	0
49	SELECT `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 1	1	1	0
50	SELECT `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 1	0	0	0
51	SELECT `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 1	1	1	0
52	SELECT `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 1	0	0	0
53	SELECT `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 1	1	1	0
54	DESCRIBE `blogs`	19	19	2
55	DESCRIBE `blog_series`	19	19	2
56	DESCRIBE `blogs_comments`	7	7	1
57	DESCRIBE `tags`	4	4	1
58	DESCRIBE `blogs_tags`	2	2	1
59	DESCRIBE `pages`	19	19	2
60	DESCRIBE `pages_comments`	6	6	1
61	DESCRIBE `pages_tags`	2	2	1
62	SELECT `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 5	5	5	1
63	SELECT `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	1	1	0
64	SELECT `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	1	1	0
65	SELECT `GroupInvites`.`id`, `GroupInvites`.`group_id`, `GroupInvites`.`member_id`, `GroupInvites`.`invitee_id`, `GroupInvites`.`message`, `GroupInvites`.`approved`, `GroupInvites`.`rejected`, `GroupInvites`.`ignored`, `GroupInvites`.`created`, `GroupInvites`.`modified` FROM `groups_invites` AS `GroupInvites` WHERE `GroupInvites`.`member_id` = (2228)	0	0	0
66	SELECT `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	1	1	0
67	SELECT `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	1	1	0
68	SELECT `GroupInvites`.`id`, `GroupInvites`.`group_id`, `GroupInvites`.`member_id`, `GroupInvites`.`invitee_id`, `GroupInvites`.`message`, `GroupInvites`.`approved`, `GroupInvites`.`rejected`, `GroupInvites`.`ignored`, `GroupInvites`.`created`, `GroupInvites`.`modified` FROM `groups_invites` AS `GroupInvites` WHERE `GroupInvites`.`member_id` = (2149)	0	0	0
69	SELECT `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	1	1	0
70	SELECT `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	1	1	0
71	SELECT `GroupInvites`.`id`, `GroupInvites`.`group_id`, `GroupInvites`.`member_id`, `GroupInvites`.`invitee_id`, `GroupInvites`.`message`, `GroupInvites`.`approved`, `GroupInvites`.`rejected`, `GroupInvites`.`ignored`, `GroupInvites`.`created`, `GroupInvites`.`modified` FROM `groups_invites` AS `GroupInvites` WHERE `GroupInvites`.`member_id` = (2181)	0	0	0
72	SELECT `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	1	1	0
73	SELECT `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	1	1	0
74	SELECT `GroupInvites`.`id`, `GroupInvites`.`group_id`, `GroupInvites`.`member_id`, `GroupInvites`.`invitee_id`, `GroupInvites`.`message`, `GroupInvites`.`approved`, `GroupInvites`.`rejected`, `GroupInvites`.`ignored`, `GroupInvites`.`created`, `GroupInvites`.`modified` FROM `groups_invites` AS `GroupInvites` WHERE `GroupInvites`.`member_id` = (2307)	0	0	0
75	SELECT `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	1	1	0
76	SELECT `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	1	1	0
77	SELECT `GroupInvites`.`id`, `GroupInvites`.`group_id`, `GroupInvites`.`member_id`, `GroupInvites`.`invitee_id`, `GroupInvites`.`message`, `GroupInvites`.`approved`, `GroupInvites`.`rejected`, `GroupInvites`.`ignored`, `GroupInvites`.`created`, `GroupInvites`.`modified` FROM `groups_invites` AS `GroupInvites` WHERE `GroupInvites`.`member_id` = (2307)	0	0	0
78	SELECT `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	1	1	0
79	SELECT `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	1	1	0
80	SELECT `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	1	1	0
81	SELECT `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	1	1	0
82	SELECT `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	1	1	0
83	SELECT `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	1	1	0
84	SELECT `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	1	1	0
85	SELECT `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	1	1	0
86	SELECT `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	1	1	0
87	SELECT `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	1	1	0
88	SELECT `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	1	1	0
89	SELECT `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	1	1	0
90	SELECT `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	1	1	0
91	SELECT `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	1	1	0
92	SELECT `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	1	1	0
93	SELECT `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	11	11	0
94	SELECT `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` >= 1283918400 AND `Events`.`deleted` = 0 ORDER BY `Events`.`event_name` ASC LIMIT 5	0	0	0
95	SELECT `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 5	4	4	8
96	SELECT `PagesComment`.`id`, `PagesComment`.`page_id`, `PagesComment`.`member_id`, `PagesComment`.`text`, `PagesComment`.`created`, `PagesComment`.`deleted` FROM `pages_comments` AS `PagesComment` WHERE `PagesComment`.`page_id` IN (100071, 100070, 100069, 100068) ORDER BY `PagesComment`.`created` DESC	0	0	0
97	SELECT `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 (100071, 100070, 100069, 100068) AND `PagesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1	12	12	0
98	UPDATE `pages` AS `Page` LEFT JOIN `members` AS `Member` ON (`Page`.`member_id` = `Member`.`id`) SET `Page`.`top_article_count` = 12356 WHERE `Page`.`id` = 100071	1		1
99	SELECT 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	1	1	0
100	SELECT 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	1	1	0
101	DESCRIBE `he_said_she_saids`	8	8	1
102	DESCRIBE `he_said_she_saids_comments`	8	8	1
103	SELECT `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 1	1	1	0
104	SELECT 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	1	1	0
105	SELECT 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	1	1	0

(default) 105 queries took 80 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `aros`

DESCRIBE `acos`

DESCRIBE `aros_acos`

DESCRIBE `members`

DESCRIBE `relationship_statuses`

DESCRIBE `zipcodes`

DESCRIBE `images`

DESCRIBE `posts`

DESCRIBE `post_types`

DESCRIBE `events`

DESCRIBE `event_attendees`

DESCRIBE `groups_users`

DESCRIBE `groups`

DESCRIBE `friends`

DESCRIBE `group_posts`

DESCRIBE `post_recipients`

DESCRIBE `post_comments`

DESCRIBE `photo_collections`

DESCRIBE `photo_collection_items`

DESCRIBE `photos`

DESCRIBE `referrals`

DESCRIBE `groups_invites`

SELECT `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` = 'nancyjh87' LIMIT 1

SELECT `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` = (2265)

281

SELECT `GroupInvites`.`id`, `GroupInvites`.`group_id`, `GroupInvites`.`member_id`, `GroupInvites`.`invitee_id`, `GroupInvites`.`message`, `GroupInvites`.`approved`, `GroupInvites`.`rejected`, `GroupInvites`.`ignored`, `GroupInvites`.`created`, `GroupInvites`.`modified` FROM `groups_invites` AS `GroupInvites` WHERE `GroupInvites`.`member_id` = (2265)

550

SELECT `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` = 2265 AND `EventAttendee`.`event_id` = `Events`.`event_id`) WHERE 1 = 1 LIMIT 5

SELECT `GroupsUsers`.`id`, `GroupsUsers`.`group_id`, `GroupsUsers`.`member_id`, `GroupsUsers`.`admin`, `GroupsUsers`.`confirm_id`, `GroupsUsers`.`joined`, `GroupsUsers`.`removed`, `Groups`.`group_id`, `Groups`.`name`, `Groups`.`short_name`, `Groups`.`description`, `Groups`.`zip_code`, `Groups`.`private`, `Groups`.`created`, `Groups`.`modified`, `Groups`.`deleted` FROM `groups_users` AS `GroupsUsers` LEFT JOIN `groups` AS `Groups` ON (`GroupsUsers`.`group_id` = `Groups`.`group_id`) WHERE `GroupsUsers`.`member_id` = 2265 AND `GroupsUsers`.`removed` = 0

SELECT `Groups`.`group_id`, `Groups`.`name`, `Groups`.`short_name`, `Groups`.`description`, `Groups`.`zip_code`, `Groups`.`private`, `Groups`.`created`, `Groups`.`modified`, `Groups`.`deleted` FROM `groups` AS `Groups` WHERE `Groups`.`group_id` = 7

SELECT `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` = 21231

SELECT `Owner`.`id`, `Owner`.`group_id`, `Owner`.`member_id`, `Owner`.`admin`, `Owner`.`confirm_id`, `Owner`.`joined`, `Owner`.`removed` FROM `groups_users` AS `Owner` WHERE `Owner`.`group_id` = 7 AND `admin` = 1

SELECT `GroupsUsers`.`id`, `GroupsUsers`.`group_id`, `GroupsUsers`.`member_id`, `GroupsUsers`.`admin`, `GroupsUsers`.`confirm_id`, `GroupsUsers`.`joined`, `GroupsUsers`.`removed`, `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`, `Groups`.`group_id`, `Groups`.`name`, `Groups`.`short_name`, `Groups`.`description`, `Groups`.`zip_code`, `Groups`.`private`, `Groups`.`created`, `Groups`.`modified`, `Groups`.`deleted` FROM `groups_users` AS `GroupsUsers` LEFT JOIN `members` AS `Member` ON (`GroupsUsers`.`member_id` = `Member`.`id`) LEFT JOIN `groups` AS `Groups` ON (`GroupsUsers`.`group_id` = `Groups`.`group_id`) WHERE `GroupsUsers`.`group_id` = 7 AND `GroupsUsers`.`removed` = 0 AND `GroupsUsers`.`member_id` != 2265

SELECT `GroupsInvites`.`id`, `GroupsInvites`.`group_id`, `GroupsInvites`.`member_id`, `GroupsInvites`.`invitee_id`, `GroupsInvites`.`message`, `GroupsInvites`.`approved`, `GroupsInvites`.`rejected`, `GroupsInvites`.`ignored`, `GroupsInvites`.`created`, `GroupsInvites`.`modified`, `Group`.`group_id`, `Group`.`name`, `Group`.`short_name`, `Group`.`description`, `Group`.`zip_code`, `Group`.`private`, `Group`.`created`, `Group`.`modified`, `Group`.`deleted`, `Inviter`.`id`, `Inviter`.`username`, `Inviter`.`password`, `Inviter`.`email`, `Inviter`.`gender`, `Inviter`.`zip_code`, `Inviter`.`relationship_status_id`, `Inviter`.`registration_key`, `Inviter`.`verified`, `Inviter`.`date_of_birth`, `Inviter`.`sexual_orientation`, `Inviter`.`story`, `Inviter`.`first_name`, `Inviter`.`last_name`, `Inviter`.`created`, `Inviter`.`modified`, `Inviter`.`last_active`, `Inviter`.`display_name`, `Inviter`.`super_admin`, `Inviter`.`deleted`, `Invitee`.`id`, `Invitee`.`username`, `Invitee`.`password`, `Invitee`.`email`, `Invitee`.`gender`, `Invitee`.`zip_code`, `Invitee`.`relationship_status_id`, `Invitee`.`registration_key`, `Invitee`.`verified`, `Invitee`.`date_of_birth`, `Invitee`.`sexual_orientation`, `Invitee`.`story`, `Invitee`.`first_name`, `Invitee`.`last_name`, `Invitee`.`created`, `Invitee`.`modified`, `Invitee`.`last_active`, `Invitee`.`display_name`, `Invitee`.`super_admin`, `Invitee`.`deleted` FROM `groups_invites` AS `GroupsInvites` LEFT JOIN `groups` AS `Group` ON (`GroupsInvites`.`group_id` = `Group`.`group_id`) LEFT JOIN `members` AS `Inviter` ON (`GroupsInvites`.`member_id` = `Inviter`.`id`) LEFT JOIN `members` AS `Invitee` ON (`GroupsInvites`.`invitee_id` = `Invitee`.`id`) WHERE `invitee_id` = 2265 AND `approved` = 0 AND `rejected` = 0 AND `ignored` = 0

SELECT `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` = 2351 AND `Image`.`profile_image` = 1 LIMIT 1

DESCRIBE `blogs`

DESCRIBE `blog_series`

DESCRIBE `blogs_comments`

DESCRIBE `tags`

DESCRIBE `blogs_tags`

DESCRIBE `pages`

DESCRIBE `pages_comments`

DESCRIBE `pages_tags`

SELECT `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 5

SELECT `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

SELECT `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

SELECT `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

SELECT `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 5

SELECT `PagesComment`.`id`, `PagesComment`.`page_id`, `PagesComment`.`member_id`, `PagesComment`.`text`, `PagesComment`.`created`, `PagesComment`.`deleted` FROM `pages_comments` AS `PagesComment` WHERE `PagesComment`.`page_id` IN (100071, 100070, 100069, 100068) ORDER BY `PagesComment`.`created` DESC

SELECT `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 (100071, 100070, 100069, 100068) AND `PagesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1

UPDATE `pages` AS `Page` LEFT JOIN `members` AS `Member` ON (`Page`.`member_id` = `Member`.`id`) SET `Page`.`top_article_count` = 12356 WHERE `Page`.`id` = 100071

SELECT 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

100

101

DESCRIBE `he_said_she_saids`

102

DESCRIBE `he_said_she_saids_comments`

103

SELECT `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 1

104

SELECT 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

105

nancyjh87's Groups

DIVORCE PROPERTY HELP

Invite a Friend to DivorceNetwork

» He Said She Said

Should counseling be mandatory before filing for divorce?

» Poll of the Week

» I Got Screwed...

» Recent Blogs

» Upcoming Events

» Recent Articles