Senate.3rd - 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 
(4472401,13396981,10636471,16939161,6778068, 288299,27380096,363279,25708300,1461855,28036647,10936603)
group by page_title,user_name
order by user_name,page_title
limit 9999
SQL

Checking query status...
