How to show most liked posts in a specific time period

Ingenious

Well-known member
What would be the MySQL query please to show the most liked posts which were posted in a particular month?

Plain english version: Display most liked posts, ordered with the most liked first, between dates X and Y

Thanks :)
 

Jake Bunce

XenForo moderator
Staff member
Rich (BB code):
SELECT *
FROM xf_post
WHERE post_date BETWEEN UNIX_TIMESTAMP('2008-01-15 00:00:00') AND UNIX_TIMESTAMP('2012-03-15 00:00:00')
ORDER BY likes
DESC;
 
Top