Flagged revs reviews stats (without high volume editors)

SQL

use fiwiki_p;
SELECT 
	COUNT(DISTINCT(p1.page_title)) AS pages, 
    FLOOR(r1.rev_timestamp/100000000) AS yearmonth, 
    SUM(fr1.fr_rev_id IS NOT NULL) AS reviews, 
    SUM((fr1.fr_flags LIKE "%auto%")) AS autoreviews, 
    SUM(1) AS total_revs 
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  
WHERE 
	page_namespace=0 
    AND r1.rev_page=p1.page_id 
    AND r1.rev_id>=fr2.min_fr_rev_id
/*    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...
