Thanks a lot for your help, it's almost what I want!
But when I use "ORDER BY replycount", the threads with VERY many posts show up in the top of the list, even though they haven't got the most new replies within the last two weeks.
It seems like threads (which has many replies) get onto this list that has only got a FEW new posts in the last two weeks but is put in the top because of their high replycount.
I hope you understand what I'm trying to say here!?
Again thanks for helping!