SELECT
DATE( `post_date` ) AS `day` , COUNT( ID ) AS `cnt`
FROM
`wp_posts`
WHERE
`post_author` = 1
AND
`post_type` IN ('post', 'page')
AND
`post_status` IN ('publish')
AND
`post_date` BETWEEN '2008-10-30' AND '2012-01-30'
GROUP BY
`day`
ORDER BY
`day`