sp2.1 - 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', rev_actor, actor_name,  count(actor_id) as N, comment_text as 'block reason'
from page, revision, ipblocks, actor, comment
where page_id=rev_page
  and actor_id=rev_actor # link keys
  and ipb_reason_id=comment_id # link keys
  and ipb_user=rev_actor # user is blocked
  and page_id in 
(42085878,18762503)
order by actor_name
limit 100
SQL

Checking query status...
