Skip to content

Instantly share code, notes, and snippets.

View samjarman's full-sized avatar

Sam Jarman samjarman

100 followers · 32 following
View GitHub Profile
@samjarman
samjarman / TopPostsHitCount.sql
Created December 10, 2013 23:26
Useful query for finding out your top posts on your blog (for all posts) if you use Statpress for Wordpress.
SELECT urlrequested, COUNT(urlrequested)
FROM `wp_statpress`
WHERE urlrequested LIKE '%THEPOSTTITLES%'
GROUP BY urlrequested
ORDER BY COUNT(urlrequested) DESC