Users which are without editor user right (Flagged revs)

SQL

USE fiwiki_p;
SELECT 
  rc_user_text,
  SUM(1) AS rc_ec,
  user_editcount,
  (seuloja_user IS NOT NULL ) AS seuloja,
  (ug_user IS NOT NULL) AS "automaattisesti seulottu",
  (ufg_user IS NOT NULL) AS "ollut automaattisesti seulottu",
  thanks_to AS kiitoksia,
  thanks_from AS kiittänyt
FROM 
  user,
  recentchanges_userindex
  LEFT JOIN
  (
	SELECT 
	  ufg_user 
	FROM 
	  user_former_groups 
	WHERE 
	  ufg_group IN ("bot", "sysop", "reviewer", "autoreview", "editor") 
	GROUP BY ufg_user
   ) AS ufg
   ON ufg.ufg_user=rc_user
   LEFT JOIN
  (
	SELECT 
	  ug_user as seuloja_user
	FROM 
	  user_groups 
	WHERE 
	  ug_group IN ( "reviewer",  "editor") 
	GROUP BY ug_user
   ) AS seuloja
   ON seuloja.seuloja_user=rc_user
  LEFT JOIN
  (
	SELECT 
	  ug_user 
	FROM 
	  user_groups 
	WHERE 
	  ug_group IN ("bot", "sysop", "reviewer", "autoreview", "editor") 
	GROUP BY ug_user
   ) AS ug
   ON ug.ug_user=rc_user
   LEFT JOIN
   (
	SELECT 
	  SUM(1) AS thanks_to, 
	  log_title as thanks_to_user 
	FROM 
	  logging 
	WHERE 
	  log_action="thank" 
	GROUP BY log_title
   )
   AS thanks_to
   ON thanks_to_user=rc_user_text
   LEFT JOIN
   (
	SELECT 
	  SUM(1) AS thanks_from, 
	  log_user as thanks_from_user 
	FROM 
	  logging_userindex 
	WHERE 
	  log_action="thank" 
	GROUP BY log_user_text
   )
   AS thanks_from
   ON thanks_from_user=rc_user
WHERE 
  rc_user 
  AND rc_user=user_id
  AND rc_source = "mw.edit" 
  AND seuloja_user IS NULL
  AND user_editcount > 100
  GROUP BY rc_user 
  ORDER BY rc_ec DESC
SQL

Checking query status...
