CollectionStation.com - Groups

The Lord of the Rings
This is a group for collectors and fans of 'The Lord of the Rings' and the works of J.R.R. Tolkien.
Created on June 18, 2008 at 1:57 pm
4 members
5 discussions with 12 posts

Star Wars
Hasbro, Sideshow Collectibles, Gentle Giant, eFX Collectibles, Kotobukiya, LEGO, and more!
Created on May 21, 2008 at 10:47 pm
44 members
39 discussions with 65 posts

Power Rangers
This group is about discussing anything and everything regarding the Power Rangers franchise directly and/or collecting said franchise's merchandise; be it the television show, movies, video games, toys, fast food premiums, and whatever else you can think of.
Created on August 5, 2008 at 7:11 am
4 members
3 discussions with 3 posts

Playmobil
Playmobil is a toy line of small figures and playsets made in Germany. There are several different themes to Playmobil sets including Pirates, Knights, Romans, Vikings, Barbarians, Western and more. They are very easy to customize to create you're very own figures and to satisfy collectors there are even exclusives that are only available at Target, TRU etc.
Created on August 4, 2008 at 9:48 pm
2 members
2 discussions with 2 posts

LEGO
All LEGO, all the time
Created on September 23, 2008 at 2:18 pm
6 members
0 discussions with 0 posts

Garbage Pail Kids
They are Garbage Pail Kids! Those gross, yet funny, cards from the 80's and recently reintroduced to a new generation!
Created on May 28, 2008 at 1:42 pm
2 members
2 discussions with 2 posts

G.I. Joe
All things G.I. Joe, from the original Moveable Fighting Man to the live-action Rise of Cobra movie. (And, of course, the Real American Hero line that has dominated the Joe franchise since 1982.)
Created on September 12, 2008 at 5:09 pm
12 members
3 discussions with 3 posts

Disney Pixar Die Cast Cars
This is a group for all of the people who collect Disney Pixar 1:55 Die Cast cars made by Mattel.
Created on September 17, 2008 at 7:26 pm
4 members
1 discussions with 1 posts

CollectionStation
CollectionStation Talk! Have questions, comments regarding CollectionStation? This is the place to ask!
Created on July 12, 2008 at 3:21 pm
848 members
9 discussions with 38 posts

Batman Collectibles
Collections of Batman Action Figures, Bust, Statues and all collectibles items
Created on March 22, 2010 at 6:56 am
1 members
0 discussions with 0 posts

Barbie Doll
Barbie is a fashion doll manufactured by the American toy-company Mattel, Inc. and launched in March 1959. American businesswoman Ruth Handler is credited with the creation of the doll using a German doll called Bild Lilli as her inspiration.
Created on March 23, 2011 at 5:37 am
2 members
0 discussions with 0 posts

all about action figures
all we talk about is action figures
Created on November 11, 2008 at 4:43 pm
2 members
0 discussions with 0 posts

BENCHMARKS

Loading Time: Base Classes	0.0135
Controller Execution Time ( Groups / Viewall )	0.3838
Total Execution Time	0.3973

GET DATA

No GET data exists

MEMORY USAGE

8,763,760 bytes

POST DATA

No POST data exists

URI STRING

groups/signin

CLASS/METHOD

groups/viewall

DATABASE: cs_live QUERIES: 340 (Show)

0.0003	`select * from User where UserID = -1 LIMIT 1`
0.0003	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	`select * from User where UserID = 93 LIMIT 1`
0.0002	`select * from User where UserID = 218 LIMIT 1`
0.0002	`select * from User where UserID = 61 LIMIT 1`
0.0002	`select * from User where UserID = 243 LIMIT 1`
0.0002	`select * from User where UserID = 87 LIMIT 1`
0.0002	`select * from User where UserID = 314 LIMIT 1`
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	`select * from User where UserID = 901 LIMIT 1`
0.0002	`select * from User where UserID = 1156 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 50 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 54 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0003	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 54 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0003	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 50 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 50 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 54 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0003	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 163 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 165 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 76 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 165 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 165 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 165 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 829 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 179 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0003	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 179 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 187 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 188 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 188 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 54 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 54 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 164 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 164 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 164 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 93 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 201 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 54 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 54 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0003	`select * from User where UserID = 164 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 54 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 218 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 218 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 218 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 218 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 218 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0003	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 61 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 49 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 109 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 281 LIMIT 1`
0.0003	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 218 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 213 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 314 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 53 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 93 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 284 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 284 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 284 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 51 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 51 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0003	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0003	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 785 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 860 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 161 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 945 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = -1 LIMIT 1`
0.0003	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 1136 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0003	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	select g.*, (select count(GroupMemberID) from Group_Member where GroupID = g.GroupID and Accepted > 0 and (Declined is null or Declined = 0)) as MemberCount, (select count(DiscussionID) from Group_Discussion where GroupID = g.GroupID and Removed = 0) as DiscussionCount, (select count(ThreadID) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as ThreadCount, (select max(gt.Date) from Group_Thread gt inner join Group_Discussion gd on gd.DiscussionID = gt.DiscussionID where gd.GroupID = g.GroupID and gd.Removed = 0 and gt.Removed = 0) as LastActive from `Group` g
0.0002	`select * from User where UserID = 37 LIMIT 1`
0.0002	SELECT * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
0.0002	`select * from Notification_Filter`
0.0001	`select * from Notification`
0.0002	`select * from Notification`
0.0002	`select * from Zone`
0.0002	`select * from Zone`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 22 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 15 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 13 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 7 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 3 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 14 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 12 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 18 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 6 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 16 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 17 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 1 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 23 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 24 order by ImageID DESC`
0.0002	`select * from Image where GenericType = 'group' and GenericID = 21 order by ImageID DESC`
0.0002	`select * from Zone`
0.0002	`select * from Zone`

HTTP HEADERS (Show)

SESSION DATA (Show)

session_id	ff05253b59930391b215301454cacab5
ip_address	38.107.179.230
user_agent	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
last_activity	1337870137
category_id	997
recently_viewed	5512,707,722,7563,7564

CONFIG VARIABLES (Show)

base_url	http://www.collectionstation.com/
index_page
uri_protocol	AUTO
url_suffix
language	english
charset	UTF-8
enable_hooks
subclass_prefix	MY_
permitted_uri_chars
enable_query_strings
directory_trigger	d
controller_trigger	c
function_trigger	m
log_threshold	0
log_path
log_date_format	Y-m-d H:i:s
cache_path
encryption_key	0BA565C0218E95F2FDE363571E4568262E6AE87002118329AD6CD62F802741AE
sess_cookie_name	cs_session
sess_expiration	86400
sess_encrypt_cookie	1
sess_use_database
sess_table_name	Session
sess_match_ip
sess_match_useragent
sess_time_to_update	300
cookie_prefix
cookie_domain
cookie_path	/
global_xss_filtering
compress_output
time_reference	local
rewrite_short_tags
Upload_AllowedTypes	Array ( [image/pjpeg] => jpg [image/jpeg] => jpg [image/gif] => gif [image/bmp] => bmp [image/x-png] => png [image/png] => png [image/zip] => zip [image/x-zip-compressed] => zip [application/pdf] => pdf )
Upload_MaxFileSize	52428800
Support	Array ( [Server] => mail.collectionstation.com [Port] => 110 [Email] => help@collectionstation.com [Username] => help@collectionstation.com [Password] => 28412ssg )
Email_DefaultSender	Array ( [Email] => no-reply@collectionstation.com [Name] => CollectionStation.com )
Emails	Array ( [Report] => Array ( [Collectible] => support@collectionstation.com [Blog] => support@collectionstation.com [Comment] => support@collectionstation.com ) [Collectible] => Array ( [CSV] => support@collectionstation.com ) )
Months	Array ( [0] => Array ( [0] => 1 [1] => Jan [2] => January ) [1] => Array ( [0] => 2 [1] => Feb [2] => February ) [2] => Array ( [0] => 3 [1] => Mar [2] => March ) [3] => Array ( [0] => 4 [1] => Apr [2] => April ) [4] => Array ( [0] => 5 [1] => May [2] => May ) [5] => Array ( [0] => 6 [1] => Jun [2] => June ) [6] => Array ( [0] => 7 [1] => Jul [2] => July ) [7] => Array ( [0] => 8 [1] => Aug [2] => August ) [8] => Array ( [0] => 9 [1] => Sep [2] => September ) [9] => Array ( [0] => 10 [1] => Oct [2] => October ) [10] => Array ( [0] => 11 [1] => Nov [2] => November ) [11] => Array ( [0] => 12 [1] => Dec [2] => December ) )
invalid_usernames	Array ( [0] => admin [1] => staff [2] => hasbro [3] => mattel [4] => neca [5] => star_wars [6] => starwars [7] => wwe [8] => sideshow [9] => sideshow_collectibles [10] => gentle_giant [11] => gentlegiant )
WatermarkImage	/home/stevecs/domains/collectionstation.com/git/githome/trunk/assets/images/watermark.png
signup_minimumage	13
captchaKeyPublic	6LcktQAAAAAAAKVsuDvlOPjFyoxpapzxqDkvnjoT
captchaKeyPrivate	6LcktQAAAAAAALaEVNO9bxWkHXS92Q4GcOsosPxR
CronPath	/home/stevecs/domains/collectionstation.com/git/githome/trunk/assets/_private/cron/
ReviewEditTimeout	3600
AllowCSVUpload
Pagination	Array ( [my] => Array ( [feeds] => 50 [messages] => Array ( [inbox] => 25 [sent] => 25 [trash] => 25 ) [friends] => Array ( [index] => 15 [requests] => 15 [pending] => 15 [suggestions] => 5 ) [groups] => Array ( [index] => 15 [created] => 15 [invites] => 15 ) [selling] => 20 [reviews] => 20 [collections] => Array ( [view] => 20 ) ) [profile] => Array ( [friends] => 25 [groups] => 25 [articles] => 25 [reviews] => 25 [favorites] => 25 [collectionitems] => 25 [photos] => 25 [collections] => 25 [selling] => 25 ) [groups] => Array ( [viewall] => 8 [threads] => 10 [discussions] => 10 [members] => 24 [latestthreads] => 10 ) [tags] => Array ( [search] => 10 ) [blog] => Array ( [articles] => 10 [latestarticles] => 10 [article] => Array ( [comments] => 10 ) ) [collectibles] => Array ( [index] => Array ( [categories] => Array ( [random] => 5 [newest] => 5 [right] => 15 ) [collectibles] => Array ( [random] => 5 [newest] => 5 [popular] => 5 [comments] => 5 ) [collectors] => Array ( [reviews] => 5 ) [view] => 20 ) [view] => Array ( [comments] => 50 [reviews] => 5 ) ) [category] => Array ( [view] => Array ( [collectibles] => 24 [right] => 15 ) ) [collections] => Array ( [index] => 20 ) [search] => Array ( [collectibles] => 20 [categories] => 20 [collections] => 20 [groups] => 20 [blogs] => 20 ) )
Ebay	Array ( [Mode] => Sandbox [Urls] => Array ( [ItemUrl] => http://rover.ebay.com/rover/1/711-53200-19255-0/1?type=2&campid=5335816071&toolid=10001&customid=&ext=%s&item=%s ) [Sandbox] => Array ( [Affiliation] => Array ( [TrackingID] => 5335816071 [TrackingPartnerCode] => 9 ) [Keys] => Array ( [App] => Collecti-6abf-4222-994a-f29b91034597 [Cert] => 2311c370-0c7d-4890-8c7e-86eb0caf9d70 [Dev] => 87e00c2e-beee-4d5f-8dcd-608966f590ed ) [Login] => Array ( [Username] => TESTUSER_csuser1 [Password] => amanda ) [RUName] => CollectionStati-Collecti-f256-4-lbbiez [SiteID] => 0 [Token] => AgAAAAAQAAAAaAAAAALFRiSQnY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wFk4CoDJKApgudj6x9nY+seQGe4AAAAAMAAAA35sPpDzizBTO7Ahi85dzdrrHHtJE5jovqcOjbcasSka02//i9Tsa0d1e9AJ3KCLcqOpB88xahaDpeRV4rH2SYlxN+XEsuKfWfUt9kRk5hZ3YQ590mNnkYno3ooTwxwr2d/d6qbP+PAsu891U3Ic+xKZ1z5rzMSv2oDBl0g8AcbG+MleSVFQa4YadFPQUS6Y7jJtCbY6mt1sclU+TH97bEwHIT9Ub/Qnub868hBk1CDVLJ+5N+kKLik+zpDCyP4OBsMx1CpWMbb/+/D5ktmnXD7y2Dk+OFTWzd6FbQbw5gEqL5ORmUr9RMjBJF//gUdgXfsdP+BzSDVB4OQowrfzF7NW9tsyRGsm++jdz6bMD1KYOXTDnr1gGS2MQgdNUeJBrOCQHgxWCmnLQkAF8cHqrNzCPHWnYagHiIUVbwYHeRruTJOhD7HgvsD7g2CkVLlHIIkTyKR/uBbgc3EuTaoIegoG4wCrbPDX3PbxK4tt/SHQ85dFelJQHYsYn5DhlRLNMVJbUwD/sar4TVbItCIMeoOpCBJTRUVjQZ4k/TwoLI8ozP/hUzU9N+GSK4fl0XXd5zv4Uexgn9fSIG1tS3SPeUZAMaiASJLJYMiiGfQMomu4TobRkc3Oy3JSc0Te1v5/9573V4T6+0Z7Z6SlNsQ65MAVmcCsQOFzYaCEeDS1KJxwpuN3jLX/y2Ln1j8ifrtWo1q1drBvU0AHAIZLCaniT3ENnRHWFExkbgbe+Jbumr0vqmF2OReF0woW1ObQhuM0 [TokenExpiry] => 1277836844 [Urls] => Array ( [Trading] => https://api.sandbox.ebay.com/ws/api.dll [Shopping] => http://open.api.sandbox.ebay.com/shopping [Login] => https://signin.sandbox.ebay.com/ws/eBayISAPI.dll?SignIn ) ) [Production] => Array ( [Affiliation] => Array ( [TrackingID] => 5335816071 [TrackingPartnerCode] => 9 ) [Keys] => Array ( [App] => Collecti-f256-4970-964b-45a0e5e42da4 [Cert] => e3bea769-4a3e-4862-8391-eae1168fc4d4 [Dev] => 87e00c2e-beee-4d5f-8dcd-608966f590ed ) [Login] => Array ( [Username] => collectionstation [Password] => 28412cs123 ) [RUName] => CollectionStati-Collecti-f256-4-lbbiez [SiteID] => 0 [Token] => AgAAAAAQAAAAaAAAAASS3ZSAnY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6wDlIOgDpiFoAudj6x9nY+seQgWkAAAAAMAAAy9A44mmIUjsJVs/BKJFHZmyYA6vfKdYpVshki9s4n1qkR6KrDs+igww0sw5Z/vtME3+TYlTZ/R/0w9okIgPqJiXrOveXKAgqk/U1HOngaAUkzjsoAOpjgpbQ7aBOJdLGafdlYjJo4Y1p6KuB3eptVnz96mTqXE8Uiq/KJnQlxdUGl8V3/aENG5LyNVVkr460gEXiHsBhGZMUcNY3Cj4g5ScpRnNhs4fm7IIjehzdsxy2zp/Q1LeiNQp44n1H5xjQ+/GJWbTCFfaacoMg6TlldgvS+6pZoXde0wOXYXAeBirxefYFbor3Cfb9OjFTomBoU36PDs8pecvNXEm6tUsH95xRgnA8xhQc8oVqGfKIhbAIaRuf63JQ4ESiEQo2ftnRjc1reWZRUu6CxCmaMBU+A/DL+Gp+m6/I14/0pfNeVYR6AUBWq1LlLWTlvYpaTpFUU/8koYI9gQHrrvEbebYAbtckuJC8agRCHTKiBnYLOUUNnYuv7wKlcubueQVqb8oGRb61rE948e+xCoISgSWmVJxkKCUSkXGxFmjIJ9/giDxQz7SX0pEnmZ+2zMNiGfLF1c2V9qDJK6+VnrsoM6R1qq/KyK0rmvv+B3Doefk7XDhZJspnEJukS6gdqVB6ysLsmPvhfquqe5YVyk/ibX6EQfc93yk8RzxOPSv6Y2n1T79bsysO4zp2xz7kpeDegQX1vDpSI1LpIwIb6YMow4BnfA/g+n6VlvDZs4NiKyJjBgxnntpLjOCpcFVIDKAPoKFI [TokenExpiry] => 1277836844 [Urls] => Array ( [Trading] => https://api.ebay.com/ws/api.dll [Shopping] => http://open.api.ebay.com/shopping [Login] => https://signin.ebay.com/ws/eBayISAPI.dll?SignIn ) ) )
Amazon	Array ( [WSDL] => https://webservices.amazon.com/AWSECommerceService/AWSECommerceService.wsdl [Key] => 01NSVJN3ZJDBJ0CKB082 [SecretKey] => QQj24a5D5xHpJ8vMNuzF5adS02ddxUZJ2axFnbzU [Tag] => collectioncom-20 [CertPath] => /home/stevecs/domains/collectionstation.com/git/githome/trunk/assets//_private/cert-XLJLFUMSMJO27XFNSFYWA73DRIYQV5AX.pem )
CommissionJunction	Array ( [WSDL] => https://pubcommission.api.cj.com/wsdl/version2/publisherCommissionServiceV2.wsdl [Key] => 00adcd6482b3e6b7b46f10f8cbadec5bb32c3a124dfb0657aa5c9ee8ab27cfffc688ebfe6aef86384ded52c84d29b951584944e8184d7a19baaffd79e4b00de88d/7126d6380dbdb87dfd0d349d0e3762200d3c256ca57024a4e23606ce5f56187367e8022feed3c6e433488ad908defdb9ab32b92431a7173b5d15a71e55984e81 )
DataUnison	Array ( [Mode] => Sandbox [Sandbox] => Array ( [Keys] => Array ( [User] => 68df413c6cd87412016fb9195bbe67 [Dev] => collectionstation_steve_comenzo ) [SiteID] => 0 [Token] => d16bda03700aac097dd79e20e110ee [Urls] => http://api.dataunison.com/ ) [Production] => Array ( [Keys] => Array ( [User] => 68df413c6cd87412016fb9195bbe67 [Dev] => collectionstation_steve_comenzo ) [SiteID] => 0 [Token] => d16bda03700aac097dd79e20e110ee [Urls] => http://api.dataunison.com/ ) )
Cache	Array ( [Servers] => Array ( [0] => Array ( [Host] => localhost [Port] => 11211 ) ) )

HTTP_ACCEPT	text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,/;q=0.5
HTTP_USER_AGENT	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_CONNECTION	close
SERVER_PORT	80
SERVER_NAME	as.collectionstation.com
REMOTE_ADDR	38.107.179.234
SERVER_SOFTWARE	Apache/2
HTTP_ACCEPT_LANGUAGE	en-us,en;q=0.5
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	gzip
HTTP_X_FORWARDED_FOR