Statistics of editing MediaWiki JS/CSS in ruwiki -markadmins

SQL

SELECT
	rev_user_text,
    COUNT(rev_user_text),
    rev_comment, -- если правка одна, видно, что
    page_title, -- и где,
    rev_timestamp -- и когда,
    -- если много - отображается случайная
FROM revision
JOIN page ON page_id = rev_page
WHERE
    rev_timestamp >= "20170701" AND
    (page_namespace = 2 AND
     (page_title LIKE '%.css' OR
      page_title LIKE '%.js') AND
     page_title NOT LIKE CONCAT(REPLACE(rev_user_text, ' ', '_'), '%') OR
    (page_namespace = 8 AND
     (page_title LIKE '%.css' OR
      page_title LIKE '%.js'))) AND
    rev_comment NOT LIKE '%Автоматическое переименование %' AND
    page_title != 'Gadget-markadmins.js'
GROUP BY rev_user_text
ORDER BY COUNT(*) DESC

SQL

Checking query status...