List deletion requests by user Seazzy

Analysis to discover DRs created by a user from a given date. Results formatted to be easily pasted in a wiki format, just export as a wikitable.

SQL

USE commonswiki_p;
SELECT RIGHT( LEFT(rev_timestamp, 8), 4 ) AS Date,
  REPLACE(CONCAT("[[Commons:", page_title, "|", SUBSTRING(page_title, 19), "]]"), "_", " ") AS Page
FROM page
JOIN revision_userindex ON rev_page = page_id
  AND rev_timestamp > 20140101001122
JOIN actor_revision ON actor_id = rev_actor
  AND actor_name = "Seazzy"
JOIN comment_revision ON comment_id = rev_comment_id
  AND comment_text IN ("Starting deletion request", "Starting mass deletion request")
WHERE page_namespace = 4
AND SUBSTRING(page_title, 1, 17) = "Deletion_requests"
ORDER BY Date DESC;

SQL

Checking query status...