Oli editors blocks

SQL

set @EDITCOUNT_MIN=100;
  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)
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)
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)

group by editor
SQL

Checking query status...
