SELECT b.blog_id, b.blog_title, b.blog_title_display, b.blog_body, b.blog_create_datetime, b.blog_import_title, b.blog_import_body, b.blog_import_source_title, b.blog_import_source_link, b.blog_import_link, b.blog_highlight, b.blog_published, b.blog_accept_comment, u.user_name, count(c.blog_id) as comment_total FROM roundhouse_blog b LEFT JOIN roundhouse_blog_comment c ON b.blog_id=c.blog_id INNER JOIN roundhouse_user u ON b.user_id=u.user_id WHERE b.user_id=1 AND YEAR(b.blog_create_datetime)=2007 AND MONTH(b.blog_create_datetime)=index.php AND b.blog_published=1 AND 1=1 GROUP BY b.blog_id ORDER BY b.blog_create_datetime desc LIMIT 200