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

SELECT s.month, drs.num, other.num, drs.num/other.num*100
FROM (
  SELECT LEFT(rev_timestamp, 6) as `month`, page_title LIKE "Deletion_requests/%" as `dr_page`, COUNT(*) as `num`
  FROM commonswiki_p.revision_userindex
  JOIN commonswiki_p.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/%"
)s
JOIN (SELECT * FROM s WHERE s.dr_page = 0) other ON s.month = drs.month 
JOIN (SELECT * FROM s WHERE s.dr_page = 1) drs ON s.month = drs.month

SQL

Checking query status...