SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.