select
posts.*
, count(*) as '# of posts'
from wp_pp_stat as stat
inner join wp_posts as posts
on posts.id = stat.post_id
where stat.access_time > now() - interval 1 month
group by stat.post_id
order by count(*) desc
limit 5