Oli editors blocks

SQL

# ------------------------------------------------------------------------------------------------------------------
# | This SQL query will return the status of IPs/registered editors to a selected set of Wikipedia pages on enwiki.
# | Editors with more than EDITCOUNT_MIN edits will not be examined.
# | Due to technical restrictions the page list has to be hand coded at the three page_id lines.
# | A page list can be generated using Quarry query #62940, or by examining the page id on the Wikipedia web interface. E.g. Alexei Mordashov is page ID 1324566.
# |
# | In the results, num_edits reflects the number of times the editor has touched the pages in the page list (not all of enwiki).
# ------------------------------------------------------------------------------------------------------------------


set @EDITCOUNT_MIN=1000000;
  select  actor_name as editor, count(actor_name) as num_edits, "no" as block, "" as reason
  from page, revision, actor
  where page_id=rev_page
  and  rev_actor=actor_id and actor_user is null
  and page_id in (1324566,13020970,44944712,59790490,9369926,1319085,8749043,23168605,27544155,354597,1313676,26787092,353535,3548462,60421900,965991,3909189,476001,1324506,966006,8825193,48956967,70144271)
union
  select actor_name as editor, count(actor_name) as num_edits, "no" as block, "" as reason
  from page, revision, actor, user
  where page_id=rev_page
  and  rev_actor=actor_id and actor_user=user_id 
  and user_editcount < @EDITCOUNT_MIN # user is unblocked and under some threshold
  and page_id in (1324566,13020970,44944712,59790490,9369926,1319085,8749043,23168605,27544155,354597,1313676,26787092,353535,3548462,60421900,965991,3909189,476001,1324506,966006,8825193,48956967,70144271)
union
  select actor_name as editor, count(actor_name) as num_edits, "yes" as block, comment_text as reason
  from page, revision, actor, user, ipblocks, comment
  where page_id=rev_page
  and  rev_actor=actor_id and actor_user=user_id 
  and ipb_user=user_id # user is blocked
  and ipb_reason_id=comment_id # link keys
  and page_id in (1324566,13020970,44944712,59790490,9369926,1319085,8749043,23168605,27544155,354597,1313676,26787092,353535,3548462,60421900,965991,3909189,476001,1324506,966006,8825193,48956967,70144271)

group by editor
SQL

Checking query status...
