timestamps of all live & deleted edits: ptwiki, March 2023

Fork of New edits last 30 minutes on ptwiki per revision table by Stanglavine

This query is marked as a draft This query has been published by Stanglavine.

SQL

SELECT
rev_timestamp, actor_name
FROM
revision, actor
WHERE
rev_id > 65320000 #block on 17-02-2023, to avoid search the entire table
AND
rev_timestamp >= 20230314213000
AND
rev_timestamp <= 20230314215959
AND
rev_actor = actor_id;

SELECT
ar_timestamp, actor_name
FROM
archive, actor
WHERE
ar_id > 9482000 #block on 17-02-2023, to avoid search the entire table
AND
ar_timestamp >= 20230314213000
AND
ar_timestamp <= 20230314215959
AND
ar_actor = actor_id;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...