SQL
AخA
SELECT CONCAT('[https://en.wikipedia.org/w/index.php?diff=', rev_id, ']') AS diff,
CONCAT('[[Wikipedia:', page_title, ']]') AS pagename,
DATE_FORMAT(rev_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,
comment_text
FROM revision_userindex
JOIN page ON page_id = rev_page
JOIN comment ON comment_id = rev_comment_id
WHERE rev_timestamp >= '201902112206'
AND rev_user_text = 'SportingFlyer'
AND page_namespace = 4 -- Wikipedia:
AND page_title LIKE 'Deletion_review/Log/%'
ORDER BY rev_timestamp ASC;
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.