Fork of Stewards statistics (Final) by علاء
This query is marked as a draft This query has been published by Taavi.

SQL

​x
 
select 
  concat ("{{u|", user_name, "}}") as "username", 
  (
    select 
      count(*) 
    from 
      logging 
      inner join actor on actor_id = log_actor 
    where 
      actor_user = user_id 
      and log_type = "gblblock"
  ) as "+Global block", 
  (
    select 
      count(*) 
    from 
      logging 
      inner join actor on actor_id = log_actor 
    where 
      actor_user = user_id 
      and log_type = "globalauth"
  ) as "+Global lock", 
  (
    select 
      count(*) 
    from 
      logging 
      inner join actor on actor_id = log_actor 
    where 
      actor_user = user_id 
      and log_type = "gblrename"
  ) as "+Global rename", 
  (
    select 
      count(*) 
    from 
      logging 
      inner join actor on actor_id = log_actor 
    where 
      actor_user = user_id 
      and log_type = "gblrights"
  ) as "+Global rights", 
  (
    select 
      count(*) 
    from 
      logging 
      inner join actor on actor_id = log_actor 
    where 
      actor_user = user_id 
      and log_type = "rights"
  ) as "+Rights", 
  (
    select 
      count(*) 
    from 
      logging 
      inner join actor on actor_id = log_actor 
    where 
      actor_user = user_id 
      and log_type = "abusefilter"
  ) as "+Af edits", 
  (
    (
      select 
        count(*) 
      from 
        revision 
        inner join actor on actor_id = rev_actor 
      where 
        actor_user = user_id 
      and rev_page IN (32244, 130130, 164533, 135805, 31937, 84820, 9476, 117752, 167407)
    ) + (
      select 
        count(*) 
      from 
        revision 
        inner join actor on actor_id = rev_actor 
      where 
        actor_user = user_id 
        and rev_page = 13356 
        and rev_minor_edit = 0
    )
  ) as "SR edits"
from 
  user 
  inner join user_groups on ug_user = user_id 
where 
  ug_group = "steward";
​
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...