# 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 

(52286158,73102735,51897188,46964560)

group by page_title,user_name

order by user_name,page_title

limit 999