Edits by WMF staff to Commons talkpages by month

SQL

#
SELECT EXTRACT(Year from DATE_FORMAT(rev_timestamp,'%Y%m%d%H%i%s')) as `year`, 
EXTRACT(Month from DATE_FORMAT(rev_timestamp,'%Y%m%d%H%i%s')) as `month`, 
COUNT(rev_id) AS staff_edits FROM commonswiki_p.revision r
INNER JOIN commonswiki_p.page AS p
ON r.rev_page = p.page_id 
WHERE p.page_namespace IN (3, 5, 7) #Commons, File, and User talk namespaces
AND r.rev_actor IN (1975, 2345, 2859, 6573, 10237, 12620, 13250, 13477, 17463, 18055) #is a staff account
AND r.rev_timestamp > 20130101000000
GROUP BY `year`, `month` 
ORDER BY `year` ASC, `month` ASC;

SQL

Checking query status...