Top 5 posts on home page

[TECK]

I see 2 BIG mistakes rightaway.
1. You don't use a dateline cut in your first query. Just that will make your server go to it's knees, if you have a busy board.
2. You use a query in the loop. That is simply kill, also.

Do you plan to use this into a vBulletin environment?
There are better ways to do it.