sp2 - Quarry

SQL

  # Simplified query to focus on blocked editors.
  # The page_id list can be manually compiled by looking at page id under "page information" in the Wiki web interface,
  # or by running Quarry query #62940 with a list of titles. 
  
select page_title as 'page title', actor_name as editor, count(actor_id) as N, comment_text as 'block 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 
(42085878,18762503,45527399,19042397,53406808,57478606,54750187,46574112)
group by actor_name
order by actor_name, page_title, N desc
SQL

Checking query status...
