recentchanges reverts

SQL

select month(rc_timestamp) as month, day(rc_timestamp) as day, (rc_comment RLIKE "(Reverted ([0-9]+ )?edits by \[\[Special:Contributions/[^\|]+\|[^]]+\]\] \(\[\[User talk:[^\|]+\|talk\]\]\) to last version by .+)" or rc_comment LIKE "Undid revision%" or rc_comment LIKE '%WP:HG%' OR rc_comment LIKE '%WP:HUGGLE%' or rc_comment LIKE '%WP:TW%' or rc_bot = 1 or rc_comment like '%rv%' or rc_comment like '%revert%') as reverts, count(*) as total 
from recentchanges 
where rc_new_len is not null and rc_old_len is not null 
group by 1,2,3 order by 1,2
SQL

Checking query status...
