Fawiki revert ratio

SQL

SELECT 
	floor(rev_timestamp/100000000) as yearmonth,
    count(rev_id) as refs,
    count(distinct(rev_id)) as drefs,
    sum(tags IS NULL) as revertedits,
    sum(tags IS NULL) as otheredits
FROM (
	SELECT 
		rev_id,
    	rev_timestamp,
    	group_concat(ct_tag_id) as tags
	FROM 
		page, 
    	revision_compat 
    	LEFT JOIN change_tag ON rev_id=ct_rev_id AND ct_tag_id IN (276, 280, 7, 10) 
    	LEFT JOIN (
      		SELECT 
      			user_id, user_name 
      		FROM 
      			user 
      			LEFT JOIN user_groups ON ug_user=user_id 
      			LEFT JOIN user_former_groups ON ufg_user=user_id 
      		WHERE 
      			ug_group='bot' OR ufg_user='bot' OR user_name REGEXP '[bB][oO0][tT]\b' 
      		GROUP BY user_id
    	) AS bots ON rev_user=bots.user_id 
	WHERE 
		rev_page=page_id 
    	AND page_namespace=0 
    	AND rev_id>27914582 
    	AND rev_timestamp>20201000000000  
    	AND bots.user_id IS NULL  
	GROUP BY rev_id 
) as t
GROUP BY yearmonth
SQL

Checking query status...
