Attribution for [[List of anthropogenic disasters by death toll]]

Fork of Publically-available info about deleted revisions (WCJ) by Cryptic

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

Every user who edited [[List of anthropogenic disasters by death toll]] (deleted revisions) or [[Draft:List of anthropogenic disasters by death toll]] (already-restored revisions), listed in increasing order of their earliest edit's timestamp.

For [[User talk:Star Mississippi#Request to restore List of anthropogenic disasters by death toll to draft]] circa 30 July 2024, and [[Draft talk:List of anthropogenic disasters by death toll]].

SQL

SELECT actor_name,
       COUNT(*) AS '#/edits',
       CAST(MIN(ar_timestamp) AS DATETIME) AS 'first edit',
       CAST(MAX(ar_timestamp) AS DATETIME) AS 'last edit'
FROM
(
SELECT actor_name, ar_timestamp
FROM archive
LEFT JOIN actor_archive ON actor_id = ar_actor
WHERE ar_namespace = 0 AND ar_title = 'List_of_anthropogenic_disasters_by_death_toll'

UNION

SELECT actor_name, rev_timestamp
FROM revision
JOIN page ON page_id = rev_page
LEFT JOIN actor_revision ON actor_id = rev_actor
WHERE page_namespace = 118 AND page_title = 'List_of_anthropogenic_disasters_by_death_toll'
) sq
GROUP BY actor_name
ORDER BY MIN(ar_timestamp) ASC;

SQL

Checking query status...