search revisions

SQL

/* search revisions 
*/
SET @END_TIME = 20240616153600;
SET @START_TIME = 20230516153600;

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 = "Mys 721tx"
        
ORDER BY rev_timestamp DESC;
-- Executed in 1500.66 seconds as of Tue, 23 Jul 2024 18:46:42 UTC.  Resultset (4757 rows)
SQL

Checking query status...
