Skip to content

Instantly share code, notes, and snippets.

@samjarman

samjarman/TopPostsHitCount.sql

Created December 10, 2013 23:26
Show Gist options
  • Save samjarman/7902277 to your computer and use it in GitHub Desktop.
Save samjarman/7902277 to your computer and use it in GitHub Desktop.
Download ZIP
Useful query for finding out your top posts on your blog (for all posts) if you use Statpress for Wordpress.
Raw
TopPostsHitCount.sql
SELECT urlrequested, COUNT(urlrequested)
FROM `wp_statpress`
WHERE urlrequested LIKE '%THEPOSTTITLES%'
GROUP BY urlrequested
ORDER BY COUNT(urlrequested) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment