New edits last 30 minutes on ptwiki per revision table

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

SQL

SELECT
COUNT(*) AS "Live edits"
FROM
revision
WHERE
rev_id > 65320000 #block on 17-02-2023, to avoid search the entire table
AND
rev_timestamp >= 20230217160000
AND
rev_timestamp <= 20230217165959;

SELECT
COUNT(*) AS "Deleted edits"
FROM
archive
WHERE
ar_id > 9482000 #block on 17-02-2023, to avoid search the entire table
AND
ar_timestamp >= 20230217160000
AND
ar_timestamp <= 20230217165959;

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