Most liked blogposts

query.sql

SELECT p.guid, CAST(pm.meta_value AS UNSIGNED) as abc FROM `wp_postmeta` AS `pm`

left join wp_posts AS p ON pm.post_id = p.id

where 
p.post_date between '2014-01-01' and '2015-01-01'

and 
pm.meta_key = 'like_count' 

order by abc  DESC