Untitled query #63657

SQL

SELECT 
  rev_id, 
  rev_page, 
  rev_timestamp, 
  rev_minor_edit, 
  rev_deleted, 
  rev_len, 
  rev_parent_id, 
  rev_sha1, 
  comment_rev_comment.comment_text AS & quot; rev_comment_text & quot;, 
  comment_rev_comment.comment_data AS & quot; rev_comment_data & quot;, 
  comment_rev_comment.comment_id AS & quot; rev_comment_cid & quot;, 
  actor_rev_user.actor_user AS & quot; rev_user & quot;, 
  actor_rev_user.actor_name AS & quot; rev_user_text & quot;, 
  temp_rev_user.revactor_actor AS & quot; rev_actor & quot;, 
  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 = rev_id
  ) AS & quot; ts_tags & quot; 
FROM 
  ip_changes 
  JOIN revision ON (
    (rev_id = ipc_rev_id)
  ) 
  JOIN revision_comment_temp & quot; temp_rev_comment & quot; ON (
    (
      temp_rev_comment.revcomment_rev = rev_id
    )
  ) 
  JOIN comment & quot; comment_rev_comment & quot; ON (
    (
      comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id
    )
  ) 
  JOIN revision_actor_temp & quot; temp_rev_user & quot; ON (
    (
      temp_rev_user.revactor_rev = rev_id
    )
  ) 
  JOIN actor & quot; actor_rev_user & quot; ON (
    (
      actor_rev_user.actor_id = temp_rev_user.revactor_actor
    )
  ) 
  JOIN page ON (
    (page_id = rev_page)
  ) 
  LEFT JOIN user ON (
    (actor_rev_user.actor_user != 0) 
    AND (
      user_id = actor_rev_user.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...
