Untitled query #63657

SQL

SELECT 
  revision.rev_id AS "rev_id", 
  revision.rev_page AS "rev_page", 
  revision.rev_timestamp AS "rev_timestamp", 
  revision.rev_minor_edit AS "rev_minor_edit", 
  revision.rev_deleted AS "rev_deleted", 
  revision.rev_len AS "rev_len", 
  revision.rev_parent_id AS "rev_parent_id", 
  revision.rev_sha1 AS "rev_sha1", 
  comment.comment_text AS "rev_comment_text", 
  comment.comment_data AS "rev_comment_data", 
  comment.comment_id AS "rev_comment_cid", 
  actor.actor_user AS "rev_user", 
  actor.actor_name AS "rev_user_text", 
  revision_actor_temp.revactor_actor AS "rev_actor", 
  page_namespace, 
  page_title, 
  page_id, 
  page_latest, 
  page_is_redirect, 
  page_len, 
  user_name, 
  page_is_new, 
  ipc_rev_timestamp, 
  (
    SELECT 
      group_concat(ctd_name, ',') 
    FROM 
      change_tag 
      JOIN change_tag_def ON (
        (ct_tag_id = ctd_id)
      ) 
    WHERE 
      ct_rev_id = revision.rev_id
  ) AS "ts_tags" 
FROM 
  ip_changes 
  JOIN revision ON (
    (revision.rev_id = ipc_rev_id)
  ) 
  JOIN revision_compat ON (
    (
      revision_compat.revcomment_rev = revision.rev_id
    )
  ) 
  JOIN comment ON (
    (
      comment.comment_id = revision_compat.revcomment_comment_id
    )
  ) 
  JOIN revision_actor_temp ON (
    (
      revision_actor_temp.revactor_rev = revision.rev_id
    )
  ) 
  JOIN actor ON (
    (
      actor.actor_id = revision_actor_temp.revactor_actor
    )
  ) 
  JOIN page ON (
    (page_id = rev_page)
  ) 
  LEFT JOIN user ON (
    (actor.actor_user != 0) 
    AND (
      user_id = actor.actor_user
    )
  ) 
WHERE 
  (
    ipc_hex BETWEEN 'v6-200102D8000000000000000000000000' 
    AND 'v6-200102D8FFFFFFFFFFFFFFFFFFFFFFFF'
  ) 
ORDER BY 
  ipc_rev_timestamp DESC, 
  ipc_rev_id DESC 
LIMIT 
  51
SQL

Checking query status...
