SELECT COUNT( comment_author ) AS cnt, comment_author, comment_author_url, comment_author_email FROM (SELECT *FROM dianso_comments LEFT OUTER JOIN dianso_posts ON ( dianso_posts.ID = dianso_comments.comment_post_ID ) WHERE MONTH( comment_date ) = '6' AND YEAR( comment_date ) = '2010' AND user_id = '0' AND comment_author != 'Dianso' AND post_password = '' AND comment_approved = '1') AS tempcmt GROUP BY comment_author ORDER BY cnt DESC LIMIT 21;
就这么的吧，关于时间，数量，还有过滤管理员，自己可以修改。
。
