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 (6085359, 7957925, 2712286, 6363842, 6869390, 4064061, 5064353, 7575925, 7898289, 6359905) #is a staff account
AND r.rev_timestamp > 20130101000000
GROUP BY `year`, `month` 
ORDER BY `year` ASC, `month` ASC;

SQL

Checking query status...