Flagged revs: multiple revisions approved once

SQL

USE fiwiki_p;
SELECT 
   rc_title, 
   reviewed_rev_id, 
   same_time_reviewed_revisions,
   concat("https://fi.wikipedia.org/w/index.php?uselang=en&title=special:log&dir=next&limit=1&offset=",(fr_timestamp+1) ,"&type=review&page=", rc_title, "&user=", replace(user_name, " ", "_")) as log_url
FROM (
  SELECT 
    rc_cur_id, 
    rc_title, 
    reviewed_rev_id, 
    COUNT(DISTINCT(rc_this_oldid)) AS rev_count, 
    GROUP_CONCAT(DISTINCT(rc_user_text) SEPARATOR ", ") AS reviewed_user_names, 
    GROUP_CONCAT(DISTINCT(rc_this_oldid) SEPARATOR ", ") AS same_time_reviewed_revisions, 
    fr3.fr_flags,
    fr3.fr_timestamp,
    first_reviewed_rev_id,
    user_name
  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, 
       MIN(fr4.fr_rev_id) AS first_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,
       flaggedrevs AS fr4
    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 
       AND fr4.fr_page_id=rc_cur_id
    GROUP BY rc_id
  ) AS revs, 
  flaggedrevs AS fr3,
  user 
  WHERE
     reviewed_rev_id=fr3.fr_rev_id 
     AND fr3.fr_user=user_id  
  GROUP BY reviewed_rev_id 
) AS reviewed_revs
WHERE 
  rev_count > 1 
  AND reviewed_rev_id!=first_reviewed_rev_id
  AND fr_flags NOT LIKE "%auto%"
SQL

Checking query status...
