SELECT b.blog_id, b.blog_title, b.blog_title_display, b.blog_body, 
			b.blog_create_datetime, b.blog_source_url, b.blog_imported, 
			b.blog_source_name, b.blog_highlight, b.blog_published, 
			b.blog_accept_comment, u.user_name, 
			count(c.blog_id) as comment_total 
			FROM am_blog b 
			LEFT JOIN am_blog_comment c ON  b.blog_id=c.blog_id 
			INNER JOIN am_user u ON b.user_id=u.user_id 
			WHERE 
			b.user_id=1 AND 
			YEAR(b.blog_create_datetime)=2008 AND MONTH(b.blog_create_datetime)=9;msg20551 AND b.blog_published=1 AND 
			1=1 
			GROUP BY b.blog_id 
			ORDER BY b.blog_create_datetime desc LIMIT 200