search revisions

SQL

/* 
*/
SET @END_TIME = 20240616153600;
SET @START_TIME = 20240416153600;

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, page_title, 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;
SQL

Checking query status...
