Untitled query #20353

SQL

SELECT 
   rc_title, 
   reviewed_rev_id, 
   revisions 
FROM (
  SELECT 
    rc_cur_id, 
    rc_title, 
    reviewed_rev_id, 
    COUNT(DISTINCT(rc_this_oldid)) AS rev_count, 
    GROUP_CONCAT(DISTINCT(rc_user_text)) AS user_names, 
    GROUP_CONCAT(DISTINCT(rc_this_oldid)) AS revisions, 
    fr3.fr_flags 
  FROM (
    SELECT 
       rc_id, 
       rc_cur_id, 
       rc_title, 
       fr1.fr_rev_id, 
       rc_this_oldid, 
       MIN(fr2.fr_rev_id) AS reviewed_rev_id, 
       rc_user_text 
    FROM 
       flaggedpages, 
       recentchanges LEFT JOIN flaggedrevs AS fr1 ON fr1.fr_rev_id=rc_this_oldid, 
       flaggedrevs AS fr2 
    WHERE 
       rc_source="mw.edit" 
       AND fp_page_id=rc_cur_id 
       AND fp_stable >= rc_this_oldid 
       AND fr2.fr_page_id=rc_cur_id 
       AND fr2.fr_rev_id >= rc_this_oldid 
    GROUP BY rc_id
  ) AS revs, 
  flaggedrevs AS fr3 
  WHERE 
     reviewed_rev_id=fr3.fr_rev_id 
  GROUP BY reviewed_rev_id 
) AS reviewed_revs 
WHERE 
  rev_count > 1 
  AND fr_flags NOT LIKE "%auto%"
SQL

Checking query status...
