Fawiki revert ratio

SQL

SELECT
	floor(rev_timestamp/100000000) as yearmonth,
    count(rev_id) as refs, 
    sum(tags IS NULL) as edits,
    sum(tags IS NOT NULL) as revertedits,
    (sum(tags IS NOT NULL)/sum(1)) as p 
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...
