SELECTrev_user,rev_user_text,YEAR(rev_timestamp)asyear,MONTH(rev_timestamp)asmonth,rev_timestamp,/* TODO: This column should be an aggregate function */COUNT(*)FROMrevisionINNERJOINpageONrevision.rev_page=page.page_idWHERELOWER(CONVERT(rev_user_textUSINGlatin1))NOTLIKE'%bot%'ANDrev_user!=0ANDpage_namespace=0ANDpage_is_redirect=0GROUPBYrev_user,LEFT(rev_timestamp,6)HAVINGCOUNT(*)>=5;