How to show most liked posts in a specific time period

[Ingenious]

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]

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;

 

[Ingenious]

Many thanks Jake.