Untitled query #80138

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, MAX(rev_id) AS last_rev_id, COUNT(rev_id) AS rev_count
  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
WHERE p.page_namespace = 14
AND cat.cat_pages = 0
AND cat.cat_subcats = 0
AND cat.cat_files = 0
AND first_actor.actor_name IN (
  SELECT ipblocks.ipb_address FROM ipblocks
  INNER JOIN comment block_comment
  ON ipblocks.ipb_reason_id = block_comment.comment_id
  WHERE
  (block_comment.comment_text LIKE '%Ellsiemall%'
       OR block_comment.comment_text LIKE '%ELLS%'
       OR block_comment.comment_text LIKE '%Color Actor%'
  )
  AND ipblocks.ipb_range_start = ipblocks.ipb_range_end
  AND ipblocks.ipb_address LIKE '2%'
)
ORDER BY first_actor.actor_name
SQL

Checking query status...
