48小时(按点击)
select top 20 * from [4k_forum_threads] where datediff(hour,datecreated,getdate())<=48 order by hits desc
48小时(按回复)
select top 20 * from [4k_forum_threads] where datediff(hour,datecreated,getdate())<=4
order by resplies desc
一周
datediff(day,datecreated,getdate())<=7
一月
datediff(day,datecreated,getdate())<=30