Archives

SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts ,wp_term_relationships WHERE post_type = 'post' AND post_status = 'publish' AND ID=object_id AND term_taxonomy_id='' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC