/* 

*/

SET @END_TIME = 20240616153600;

SET @START_TIME = 20230616153600;;

​

WITH all_revision AS (

    SELECT rev_id, rev_actor, rev_page, rev_timestamp

    FROM revision_userindex

    UNION

    SELECT ar_id AS rev_id, ar_actor AS rev_actor, ar_page_id AS rev_page, ar_timestamp AS rev_timestamp

    FROM archive_userindex

)

​

​

SELECT actor_id, actor_name, rev_id, rev_actor, rev_page, rev_timestamp

    FROM actor

    JOIN all_revision ON actor_id = all_revision.rev_actor

    JOIN page ON page_id = all_revision.rev_page

    JOIN user ON actor_user = user_id

    WHERE actor_user IS NOT NULL

        AND page_namespace = 0

        AND rev_timestamp <= @END_TIME

        AND rev_timestamp >= @START_TIME

        AND actor_name = "Gluo88"

ORDER BY rev_timestamp;

​

​

​