recentchanges reverts

SQL

select month(rc_timestamp) as month, day(rc_timestamp) as day, (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 '%WP:AWB%') and rc_old_len > rc_new_len) or rc_comment like '%rv%' or rc_comment like '%revert%' 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 and rc_namespace = 0 
group by 1,2,3 order by 1,2
SQL

Checking query status...
