show the most views threads from the last month

[derdiedastim]

Hi,
is there a SQL-Query that read out the thread(ids) with the most views last month?

I didn't find a solution.
Ich can only read out the most views threads ALL TIME...
SELECT threadid,title FROM thread ORDER BY views DESC

Thanks..

[kh99]

I don't think that information is in the database. Of course what you could do it make a monthly scheduled task to save the views for each thread to another db table, then starting next month you would be able to calculate the value you want.