## mark a section (Learn more)

SELECT wp_users.display_name as author, COUNT(wp_posts.ID) as posts FROM wp_posts, wp_users WHERE wp_posts.post_author = wp_users.ID AND month(wp_posts.post_date) = 11 AND YEAR(post_date) = 2007 GROUP BY post_author ORDER BY total DESC;

This paste will be private.