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;
WITH s AS (
  SELECT LEFT(rev_timestamp, 6) as month, page_title LIKE "Deletion_requests/%" as `dr_page`, COUNT(*) as `num`
  FROM revision_userindex
  JOIN page ON rev_page = page_id
  WHERE 
      rev_actor = (SELECT actor_id FROM actor_revision WHERE actor_name = "Ainz Ooal Gown")
      AND page_namespace = 4
  GROUP BY LEFT(rev_timestamp, 6), page_title LIKE "Deletion_requests/%"
)
SELECT other.month, drs.num, other.num, drs.num/other.num*100
FROM 
	(SELECT * FROM s WHERE s.dr_page = 0) other
JOIN (SELECT * FROM s WHERE s.dr_page = 1) drs ON other.month = drs.month

SQL

Checking query status...