Fawiki revert ratio

SQL

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 
LIMIT 10;
SQL

Checking query status...
