DECLARE @days AS INTEGER

SET @days = 30

SELECT TOP 50 *
FROM
(
SELECT msg_from,
COUNT(*) AS cnt,
SUM( ( @days*24 + 1 - DATEDIFF( hour, date_msg, GETDATE() ) ) * ( @days*24 + 1 - DATEDIFF( hour, date_msg, GETDATE() ) ) ) / 10000 AS activity
FROM forum_msgs
WHERE date_msg > DATEADD( day, -@days, GETDATE() )
GROUP BY msg_from
) sums
ORDER BY activity DESC






李颖 1683 36425
老玉米 799 16146
haitao 670 15631
pcplayer 652 12880
ninja 295 12263
Fish 589 11397
没脾气2x 621 10496
coolbjwolf 580 10341
fogbound 713 10249
Miracle 479 8622
tweety 363 7803
zengr 392 6246
十方 312 6245
pigprince 359 5811
pinxue 235 5746
小东 362 5513
有狐 298 5397
1.097secs 138 5111
pkuuuu 232 5049
王中王 251 4691
Jonney 179 4620
七零年代 246 4243
乌烟 199 4183
CJF 260 4157
ycm0263 218 4095
summerrose 224 4050
bjwf 176 3833
Water-E 141 3753
疯子张 275 3511
bmkun 266 3476
lookyour 175 3470
mhappy 250 3310
村支书 312 3087
looklook 268 3005
雨蝶 112 3002
咔波碧宝 153 2877
Yxd 110 2514
furnace 285 2513
DeepBlue 126 2488
JoJo 165 2399
盘丝小仙 100 2278
xiaolongren 76 2200
oyjt 179 2193
羚菲菲 83 2191
核弹头 271 2165
GoodHope 243 2158
holly 66 2121
垃圾 91 2086
空山新雨 85 2004
UnKnow365 140 1923