sp2.13g - 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', user_name, comment_text as 'block reason'
from page, revision, ipblocks, user, actor, comment
where page_id=rev_page
  and actor_id=rev_actor # link keys
  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 
(15169563,11292570,3781829,70747760,871095,290527)
group by page_title,user_name
order by user_name,page_title
limit 999
SQL

Checking query status...
