|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Here's the query:
select t1.USER_DISPLAY_NAME,count(t2.POST_ID) as total
from ubbt_POSTS as t2,
ubbt_USERS as t1
where length(t2.POST_BODY) < 15
and t1.USER_ID = t2.USER_ID
group by t2.USER_ID
having total > 5
order by total desc
limit 11
|
|
|
Entire Thread
|
2,000!!
|
Ian
|
06/20/2007 9:22 AM
|
Re: 2,000!!
|
driv
|
06/20/2007 9:51 AM
|
Re: 2,000!!
|
Gizmo
|
06/20/2007 10:25 AM
|
Re: 2,000!!
|
driv
|
06/20/2007 10:42 AM
|
Re: 2,000!!
|
Gizmo
|
06/20/2007 10:46 AM
|
Re: 2,000!!
|
ScriptKeeper
|
06/20/2007 2:01 PM
|
Re: 2,000!!
|
Gizmo
|
06/20/2007 11:02 PM
|
Re: 2,000!!
|
Mark S
|
06/20/2007 11:04 PM
|
Re: 2,000!!
|
Rick
|
06/20/2007 11:12 PM
|
Re: 2,000!!
|
Gizmo
|
06/20/2007 11:12 PM
|
Re: 2,000!!
|
Mark S
|
06/20/2007 11:14 PM
|
Re: 2,000!!
|
Mark S
|
06/20/2007 11:15 PM
|
Re: 2,000!!
|
Rick
|
06/20/2007 11:17 PM
|
Re: 2,000!!
|
Mark S
|
06/20/2007 11:18 PM
|
Re: 2,000!!
|
gliderdad
|
06/21/2007 4:28 AM
|
Re: 2,000!!
|
SD
|
06/20/2007 11:14 PM
|
Re: 2,000!!
|
gliderdad
|
06/21/2007 4:35 AM
|
Re: 2,000!!
|
ntdoc
|
06/21/2007 4:46 AM
|
Re: 2,000!!
|
Gizmo
|
06/21/2007 6:16 AM
|
Re: 2,000!!
|
Ian
|
06/21/2007 6:44 AM
|
Re: 2,000!!
|
Harold
|
06/27/2007 3:13 AM
|
Re: 2,000!!
|
SD
|
06/27/2007 3:47 AM
|
Re: 2,000!!
|
ntdoc
|
06/27/2007 6:15 AM
|
Re: 2,000!!
|
Harold
|
06/27/2007 12:01 PM
|
Re: 2,000!!
|
SD
|
06/27/2007 1:00 PM
|
Re: 2,000!!
|
Ian
|
06/27/2007 2:27 PM
|
Re: 2,000!!
|
SD
|
06/27/2007 2:51 PM
|
Re: 2,000!!
|
Gizmo
|
06/28/2007 1:03 AM
|
Re: 2,000!!
|
Harold
|
06/28/2007 3:22 AM
|
Re: 2,000!!
|
SD
|
06/28/2007 3:25 AM
|
Re: 2,000!!
|
AllenAyres
|
06/28/2007 7:10 PM
|
Re: 2,000!!
|
Gizmo
|
06/28/2007 11:45 PM
|
Re: 2,000!!
|
Gizmo
|
06/28/2007 11:45 PM
|
Re: 2,000!!
|
Mark S
|
06/28/2007 11:52 PM
|
Re: 2,000!!
|
Gizmo
|
06/29/2007 12:50 AM
|
|
|
Test
by Phun - 05/28/2024 7:31 PM
|
|
|
|
|
|
|