Ainz Ooal Gown edits in Commons:

Fork of Ainz Ooal Gown edits in Commons: by AntiCompositeNumber

This query is marked as a draft This query has been published by AntiCompositeNumber.

SQL

USE commonswiki_p;
SELECT LEFT(rev_timestamp, 6) as month, COUNT(*)
FROM revision_userindex
JOIN page ON rev_page = page_id
JOIN comment_revision ON rev_comment_id = comment_id
WHERE 
	rev_actor = (SELECT actor_id FROM actor_revision WHERE actor_name = "Ainz Ooal Gown")
    AND page_namespace = 3
    AND (
      comment_text LIKE "Please send permission%"
      OR comment_text LIKE "Notification of possible copyright violation%"
      OR comment_text LIKE "Notification of possible speedy deletion%"
    )
      
GROUP BY LEFT(rev_timestamp, 6)
ORDER BY LEFT(rev_timestamp, 6) DESC, COUNT(*) DESC

SQL

Checking query status...