Untitled query #48986

Fork of Flagged revs reviews stats (without high volume editors) by Zache

This query is marked as a draft This query has been published by Zache.

SQL

SELECT 
	COUNT(DISTINCT(p1.page_title)) AS pages, 
    FLOOR(r1.rev_timestamp/100000000) AS monthyear, 
    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 
GROUP BY monthyear

SQL

Checking query status...