Get threads with most replies in last two weeks?

[sebbe]

Thanks Xenon, it works perfect.

Just on a side note, I'm also pulling out a line of text from the first post in each thread to display, I know how to do it but is there anyway to remove all words that begin with [ ? cause right now it looks like a mess if someone for example has written "[Font color=Blue]Hey this is my thread and I use this color for all the text[/font]". Also when the post is beginning with an image "[img]http://sjfiojdsifsopf.fsdfjsifjosdjfisdf.dfsd.gif[/ img]" this problem occurs.

Any help how to just remove the stuff inside of BB [] brackets would be greatly appreciated, I've tried numerous different ways but haven't come up with any that works!

Thanks again!

Nevermind, I figured it out myself!
Thanks for all help!