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...
