Special:Nuke substitute

Nicely-formatted links to delete all pages where User:MagieRouge authored the first currently-non-deleted revision.

For [[WP:VPT#Special:Nuke only finding a few pages]] circa 29 June 2020.

SQL

SELECT CONCAT('*[{{fullurl:{{ns:', page_namespace, '}}:', page_title, '|action=delete}} delete] ',
              '{{pagelinks|{{ns:', page_namespace, '}}:', page_title, '}}') AS 'paste me'
FROM page
JOIN revision_userindex r1 ON r1.rev_page = page_id
JOIN actor_revision ON actor_id = r1.rev_actor
WHERE r1.rev_timestamp = (SELECT MIN(r2.rev_timestamp)
                          FROM revision r2 WHERE r2.rev_page = page_id) -- this is slower but more robust than WHERE r1.rev_parent_id = 0
  AND actor_name='MagieRouge'
ORDER BY r1.rev_timestamp DESC;

SQL

Checking query status...