Deletion requests created by AshFriday

SQL

USE commonswiki_p;
SELECT RIGHT( LEFT(rev_timestamp, 8), 8 ) 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 > 20180101001122
JOIN actor_revision ON actor_id = rev_actor
  AND actor_name = "AshFriday"
JOIN comment_revision on comment_id = rev_comment_id
  AND comment_text IN ("Starting deletion request", "Starting mass deletion request") OR comment_text LIKE "Files uploaded%"
WHERE page_namespace = 4
AND SUBSTRING(page_title, 19, 24) != "File:"
AND SUBSTRING(page_title, 1, 17) = "Deletion_requests"
GROUP BY Page
ORDER BY Date DESC;
SQL

Checking query status...
