Flagged revs reviews stats (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_flags LIKE "%auto%") + SUM(fr1.fr_user = 324508 )))/(SUM(fr1.fr_rev_id IS NOT NULL)))*100) AS 'autoreviews_%'
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
        LEFT JOIN (
			SELECT 
    			actor_id
			FROM
				actor_revision
    			LEFT JOIN user_former_groups ON actor_user=ufg_user
    			LEFT JOIN user_groups ON actor_user=ug_user
			WHERE
   				actor_name REGEXP "[bB][oO0][tT]"
   				OR actor_name REGEXP "[aA][wW][bB]"
                OR actor_name REGEXP "Putsari|Xyäöz"
   				OR ug_group = "bot"
   				OR ufg_group = "bot"
			GROUP BY ug_user        
        ) as high_volume_edits ON r1.rev_actor=high_volume_edits.actor_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 high_volume_edits.actor_id IS NOT NULL
    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...
