UBB.threads PHP Forum Software Community Forums General Off Topic 2,000!!

Gizmo	       156
Ian	        79
Mark S	        33
Mitch P.        30
Zarzal	        25
Rick	        22
David Dreezer	22
ntdoc	        21
J.C.	        21
gliderdad	18

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

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) > 400 
and t1.USER_ID = t2.USER_ID 
group by t2.USER_ID 
having total > 5 
order by total desc 
limit 11

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