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",
    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 '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...
