Flagged revs reviews stats (without high volume editors)

SQL

use fiwiki_p;
SELECT 
    FLOOR(r1.rev_timestamp/100000000) AS yearmonth, 
    COUNT(DISTINCT(fr1.fr_user)) AS reviewers,
	COUNT(DISTINCT(p1.page_title)) AS pages,     
    SUM(fr1.fr_rev_id IS NOT NULL) AS reviews, 
    SUM(fr1.fr_flags LIKE "%auto%") AS autoreviews,
    SUM(fr1.fr_user = 324508 ) AS SeulojaBot_reviews,
    (SUM(fr1.fr_rev_id IS NOT NULL) - (SUM(fr1.fr_flags LIKE "%auto%") + SUM(fr1.fr_user = 324508 ))) AS manualreviews,
    SUM(1) AS total_revs,
    (SUM(a1.actor_user>0)) AS user_edits,
    FLOOR((SUM(a1.actor_user>0)/SUM(1))*100) AS useredit%
    FLOOR((SUM(fr1.fr_rev_id IS NOT NULL) - (SUM(fr1.fr_flags LIKE "%auto%") + SUM(fr1.fr_user = 324508 )))/SUM(fr1.fr_rev_id IS NOT NULL)*100) AS auto%,    
FROM page AS p1  
    	LEFT JOIN (
          SELECT 
          	MIN(fr_rev_id) AS min_fr_rev_id, 
          	MIN(fr_rev_timestamp) AS min_fr_rev_ts, 
          	fr_page_id 
          FROM 
          	flaggedrevs 
          GROUP BY fr_page_id
        ) AS fr2 
        ON fr2.fr_page_id=p1.page_id, 
     revision_userindex AS r1 
     	LEFT JOIN flaggedrevs AS fr1 
        ON fr1.fr_rev_id=r1.rev_id,
     actor_revision AS a1
WHERE 
	page_namespace=0 
    AND r1.rev_page=p1.page_id 
    AND r1.rev_id>=fr2.min_fr_rev_id
    AND a1.actor_id=r1.rev_actor
    AND r1.rev_id>=18630374
    AND r1.rev_id<=19231068
    AND r1.rev_timestamp>=20200101000001
    AND r1.rev_timestamp<=20201013082310
GROUP BY yearmonth;
SQL

Checking query status...
