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;