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_title in ('Igor_Sechin','Kirill_Shamalov','Petr_Fradkov','Gennady_Timchenko') 
  and page_id in (9369926, 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_title in ('Igor_Sechin','Kirill_Shamalov','Petr_Fradkov','Gennady_Timchenko') 
  and page_id in (9369926, 8825193, 48956967, 70144271)
union
  select actor_name as editor, count(actor_name) as num_edits, "yes" as block, comment_text
  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_title in ('Igor_Sechin','Kirill_Shamalov','Petr_Fradkov','Gennady_Timchenko') 
  and page_id in (9369926, 8825193, 48956967, 70144271)

group by editor
SQL

Checking query status...
