|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
What I'm really looking for is a query that will list and rank users by the absolute top number of characters in a post. select t1.USER_DISPLAY_NAME as Name, count(t2.POST_ID) as Total, length(t2.POST_BODY) as CarpalTunnelSize from ubbt_POSTS as t2,
ubbt_USERS as t1
where t1.USER_ID = t2.USER_ID and length(t2.POST_BODY) > 65000
group by t2.USER_ID, CarpalTunnelSize
having Total > 0
order by CarpalTunnelSize desc, Total desc
limit 5
Name Total CarpalTunnelSize
yulee 5 65535
OiyOiy 1 65535
Sirdude 1 65070
Yoyo 1 65010
ro0t0os 1 64567
it pegs @ 65535, so i chose a number perty close (65000) ... other ways to do it, but i'm in a hurry
|
|
|
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
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
1 members (Ruben),
764
guests, and
215
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|