Log in

View Full Version : Need Mysql query: Find x threads started in the past x days with the most views


kontrabass
03-31-2006, 06:50 PM
Title says it all :)

I'm starting a community newsletter and want to highlight 10 or so threads that have received the most attention.

I need to find threads that:
- have been started in the last two weeks
- of these, the 10 which have received the most views.

TIA!

kontrabass
04-13-2006, 06:03 PM
bump? :)