Users which are without editor user right (Flagged revs)

SQL

SELECT 
  rc_user_text,
  SUM(1) AS rc_ec,
  user_editcount,
  ug_user,
  ufg_user,
  thanks_to,
  thanks_from
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 
	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 ug_user IS NULL
  AND user_editcount > 100
  GROUP BY rc_user 
  ORDER BY rc_ec DESC
SQL

Checking query status...
