Untitled query #20773

SQL

SELECT 
  sum(1) as pages, 
  sum(page_is_redirect) as is_redirect, 
  sum(fp_page_id IS NOT NULL) AS flaggedpages, 
  r2.rev_user_text 
FROM (
    SELECT 
    	rev_page, 
    	min(rev_timestamp) AS min_rev_timestamp 
    FROM revision 
    GROUP BY rev_page 
    ORDER BY rev_timestamp  
  ) AS r1, 
  revision_userindex AS r2, 
  page 
  LEFT JOIN flaggedpages ON fp_page_id=page_id 
WHERE 
  r1.rev_page=page_id 
  AND page_namespace=0 
  AND r1.rev_page=r2.rev_page 
  AND r1.min_rev_timestamp=r2.rev_timestamp 
GROUP BY r2.rev_user_text 
ORDER BY pages DESC 
LIMIT 100
SQL

Checking query status...
