SELECT

    YEAR(rev_timestamp) AS `Year`,

    MONTH(rev_timestamp) AS `Month`,    •••

​

    COUNT(rev_id) AS `SPI_Edits`

FROM revision_userindex

JOIN page ON (rev_page = page_id)

WHERE page_title LIKE 'Sockpuppet_investigations%'

AND rev_actor = (SELECT actor_id

                   FROM actor_revision

                   WHERE actor_name = 'Robertsky')

GROUP BY YEAR(rev_timestamp), MONTH(rev_timestamp)