Skip to content

Instantly share code, notes, and snippets.

@Page-Carbajal

Page-Carbajal/Aggregate Posts by Day of the Year

Last active August 29, 2015 14:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Page-Carbajal/d2df1eb677a83c6da6e0 to your computer and use it in GitHub Desktop.
Save Page-Carbajal/d2df1eb677a83c6da6e0 to your computer and use it in GitHub Desktop.
Download ZIP
Query to Aggregate Published posts by Day
Raw
Aggregate Posts by Day of the Year
Select post_date, count(post_date) as post_count from wp_posts
where post_status = 'publish'
and ( post_date between '2015-05-01' And '2015-05-30' )
Group By DAYOFYEAR( post_date )
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment