ruwiki: Statistics of edits that will need rights in interface-admin flag

SQL

USE ruwiki_p;
SELECT
	ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC),
    rev_user_text,
    COUNT(rev_user_text)
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
    (ug_group = 'sysop' OR  -- Позволяет исключить глобальных редакторов интерфейса
    	ug_group = 'engineer'
    ) AND
    rev_timestamp >= "20170801" 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
SQL

Checking query status...
