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 )
;