This query is marked as a draft This query has been published by Zache.

SQL

​x
 
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 
​
​
​
​
​
​
​
​
​
​
​
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...