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
FROM
revision
WHERE
rev_id > 65320000 #block on 17-02-2023, to avoid search the entire table
AND
rev_timestamp >= 20230301000000
AND
rev_timestamp <= 20230331235959

SELECT
ar_timestamp
FROM
archive
WHERE
ar_id > 9482000 #block on 17-02-2023, to avoid search the entire table
AND
ar_timestamp >= 20230301000000
AND
ar_timestamp <= 20230331235959

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...