Statistics of editing MediaWiki JS/CSS in ruwiki

SQL

USE ruwiki_p;
SELECT rev_timestamp,
	rev_user_text,
    COUNT(*), -- 
    rev_comment,
    page_title,
    page_namespace
FROM revision
JOIN page ON page_id = rev_page
WHERE 
    rev_timestamp >= "20170701" AND
    page_namespace = 8 AND -- 828
    (page_title LIKE '%.css' OR
    page_title LIKE '%.js') AND
    page_title <> 'Gadget-markadmins.js' AND
    page_title <> 'Script/Voting.js'-- AND
--    rev_comment NOT LIKE 'Automatically upload by deploy script'
	AND rev_user_text = 'Facenapalm'
GROUP BY rev_user_text -- 
ORDER BY COUNT(*) DESC
;

SQL

Checking query status...