Untitled query #80120

SQL

SELECT *
FROM page p
INNER JOIN category cat
ON p.page_title = cat.cat_title
INNER JOIN (
  SELECT rev_page, MIN(rev_id) AS first_rev_id
  FROM revision
  GROUP BY rev_page) rev_group
ON p.page_id = rev_group.rev_page
INNER JOIN revision first_rev
ON rev_group.rev_page = first_rev.rev_page
AND rev_group.first_rev_id = first_rev.rev_id
INNER JOIN actor first_actor
ON first_rev.rev_actor = first_actor.actor_id
INNER JOIN ipblocks block
ON first_actor.actor_user = block.ipb_user
INNER JOIN comment block_comment
ON block.ipb_reason_id = block_comment.comment_id
WHERE p.page_namespace = 14
--AND cat.cat_pages = 0
AND cat.cat_subcats = 0
AND cat.cat_files = 0
AND (block_comment.comment_text LIKE '%RAYA%'
     OR block_comment.comment_text LIKE '%小作%'
     /*
     OR block_comment.comment_text LIKE '%ILLEGIT%'
     OR block_comment.comment_text LIKE '%SCRUTINY%'
     */
    )
SQL

Checking query status...
