Statistics of engineer editing of MediaWiki JS/CSS in ruwiki

SQL

USE ruwiki_p;
SELECT
	rev_user_text,
    COUNT(rev_user_text),
    rev_comment, -- если правка одна, видно, что
    page_title, -- и где,
    rev_timestamp -- и когда,
    -- если много - отображается случайная
FROM revision
JOIN page ON page_id = rev_page
JOIN user ON rev_user_text = user_name
JOIN user_groups ON user_id = ug_user
WHERE 
    page_namespace = 8 AND
    (page_title LIKE '%.css' OR
    page_title LIKE '%.js') AND
    ug_group = 'engineer'
GROUP BY rev_user_text
ORDER BY COUNT(*) DESC

SQL

Checking query status...