Search and list popular threads?

[pewa]

Hi,

Im looking for a way to search and find the most popular threads(most replies) for lets say the last month. Any idea how?

I can go to the "advanced serach" and set the limitations, but I must still use a specific search word.

[Lats]

If you're comfortable running a query, this will help...

[LEFT][COLOR=#000000]SELECT[/COLOR][/LEFT]
[LEFT][COLOR=#000000]    title,[/COLOR][/LEFT]
[LEFT][COLOR=#000000]    replycount AS posts[/COLOR][/LEFT]
[LEFT][COLOR=#000000]FROM[/COLOR][/LEFT]
[LEFT][COLOR=#000000]    forum[/COLOR][/LEFT]
[LEFT][COLOR=#000000]WHERE[/COLOR][/LEFT]
[LEFT][COLOR=#000000]    parentid > 0[/COLOR][/LEFT]
[LEFT][COLOR=#000000]ORDER BY[/COLOR][/LEFT]
[LEFT][COLOR=#000000]    replycount DESC[/COLOR][/LEFT]