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_subcats = 0
AND cat.cat_files = 0
AND (block_comment.comment_text LIKE '%Ellsiemall%'
     OR block_comment.comment_text LIKE '%ELLS%'
     OR block_comment.comment_text LIKE '%Color Actor%')
AND p.page_title LIKE '%分類群'
ORDER BY cat.cat_pages
SQL

Checking query status...
