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

DatGuy's edits to the areas he plans to admin in, by month and page.

For [[Wikipedia:Requests for adminship/DatGuy]] circa 9 August 2022.

SQL

SELECT LEFT(rev_timestamp, 6) AS 'year/month',
       page_title,
       EXISTS (SELECT 1
               FROM change_tag
               JOIN change_tag_def ON ctd_id = ct_tag_id
               WHERE ct_rev_id = rev_id
                 AND ctd_name IN ('huggle', 'twinkle')) AS edits_are_automated,
       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, edits_are_automated
ORDER BY rev_timestamp DESC;

SQL

Checking query status...