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 "rev_comment_text",comment_rev_comment.comment_data AS "rev_comment_data",comment_rev_comment.comment_id AS "rev_comment_cid",actor_rev_user.actor_user AS "rev_user",actor_rev_user.actor_name AS "rev_user_text",temp_rev_user.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=rev_id ) AS "ts_tags" FROM ip_changes JOIN revision ON ((rev_id = ipc_rev_id)) JOIN revision_comment_temp "temp_rev_comment" ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN comment "comment_rev_comment" ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN revision_actor_temp "temp_rev_user" ON ((temp_rev_user.revactor_rev = rev_id)) JOIN actor "actor_rev_user" 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...
