| 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.0003 |
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.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 = 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 = 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.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 = 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.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 = 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.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 = 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.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 = 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 = 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.0003 |
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.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 = 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.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 = 61 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 = 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.0003 |
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.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 = 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.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 = 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.0003 |
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.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 = 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.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.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 = 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.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 = 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.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 * FROM Message WHERE `To` = '-1' ORDER BY MessageID DESC
|
| 0.0002 |
select * from Notification_Filter
|
| 0.0002 |
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.0001 |
select * from Image where GenericType = 'group' and GenericID = 14 order by ImageID DESC
|
| 0.0001 |
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.0001 |
select * from Image where GenericType = 'group' and GenericID = 1 order by ImageID DESC
|
| 0.0001 |
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
|
