Untitled query #79411

SQL

SELECT * FROM 
(
  SELECT p.page_title, first_rev.rev_timestamp, first_actor.actor_name
  FROM page p
  INNER JOIN category cat
  ON p.page_title = cat.cat_title
  AND cat.cat_pages = 0
  AND cat.cat_subcats = 0
  AND cat.cat_files = 0
  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
  WHERE p.page_namespace = 14
) p
INNER JOIN
(
  SELECT logging.log_title, logging.log_timestamp, log_comment.comment_text
  FROM logging
  INNER JOIN comment log_comment
  ON logging.log_comment_id = log_comment.comment_id
  AND (log_comment.comment_text LIKE '%Ellsiemall%'
       OR log_comment.comment_text LIKE '%ELLS%'
       OR log_comment.comment_text LIKE '%Color Actor%'
       OR log_comment.comment_text LIKE '%NTT%'
       OR log_comment.comment_text LIKE '%HEATHROW%'
       OR log_comment.comment_text LIKE '%HGTCHDP%'
       OR log_comment.comment_text LIKE '%SUZU%'
       OR log_comment.comment_text LIKE '%RAYA%'
       OR log_comment.comment_text LIKE '%SCRUTINY%'
       OR log_comment.comment_text LIKE '%小作%')
  WHERE logging.log_type = 'block'
) logging
ON p.actor_name = logging.log_title
SQL

Checking query status...
