select actor_name as editor, page_title, comment_text as reason

  from page, revision, actor, user, ipblocks, comment

  where page_id=rev_page

  and  rev_actor=actor_id 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 (1324566,13020970,44376708,45502218,53651336,9369926,58641489,17684964,46574112,48956967,27544155,354597,24229148,9316859,70144271,353535,9358525,966006,56606572)

order by page_title, editor

​