T303010 - range contribs

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",
    actor_rev_user.actor_id 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_userindex revision
    ON ((rev_id = ipc_rev_id))
JOIN comment comment_rev_comment
    ON ((comment_rev_comment.comment_id = revision.rev_comment_id))
JOIN actor actor_rev_user
    ON ((actor_rev_user.actor_id = revision.rev_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 'BA029000' AND 'BA0293FF')
    AND ((rev_deleted & 12) != 12)
    AND (((ipc_rev_timestamp<'20210615235959')))
    AND (ipc_rev_timestamp>='20210101000000')
    AND (ipc_rev_timestamp<='20210615235959')
ORDER BY ipc_rev_timestamp DESC, ipc_rev_id DESC
LIMIT 51;
SQL

Checking query status...
