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', actor_name, 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_user=rev_actor # user is blocked
  and ipb_reason_id=comment_id # link keys
  and page_id in 
(42085878,18762503)
#(42085878,18762503,45527399,19042397,53406808,57478606,54750187,46574112)
order by page_title, actor_name
limit 999
SQL

Checking query status...
