DatGuy's edits to [[WP:AIV]]/[[WP:RFPP]]/[[WP:ITNC]] by month

SQL

SELECT LEFT(rev_timestamp, 6) AS 'year/month', page_title, COUNT(*)
FROM revision_userindex
JOIN actor_revision ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE actor_name = 'DatGuy'
  AND page_namespace = 4
  AND page_title IN ('Administrator_intervention_against_vandalism', 'Requests_for_page_protection', 'In_the_news/Candidates')
GROUP BY LEFT(rev_timestamp, 6), page_title
ORDER BY rev_timestamp DESC;

AخA
 
SELECT LEFT(rev_timestamp, 6) AS 'year/month', page_title, COUNT(*)FROM revision_userindexJOIN actor_revision ON actor_id = rev_actorJOIN page ON page_id = rev_pageWHERE actor_name = 'DatGuy'  AND page_namespace = 4  AND page_title IN ('Administrator_intervention_against_vandalism', 'Requests_for_page_protection', 'In_the_news/Candidates')GROUP BY LEFT(rev_timestamp, 6), page_titleORDER BY rev_timestamp DESC;

SQL

Checking query status...