Admins’ JavaScript and CSS edits on huwiki

Current admins’ and interface-editors’ edits to JavaScript and CSS pages in MediaWiki namespace. Based on query by Tgr at T190015#4203100.

SQL

USE huwiki_p;

SELECT name, cnt FROM user JOIN user_groups ON (ug_group = 'sysop' OR ug_group = 'interface-editor') AND ug_user = user_id LEFT JOIN (
	SELECT rev_user_text AS name, COUNT(*) AS cnt FROM page STRAIGHT_JOIN revision ON rev_page = page_id
		WHERE page_namespace = 8 AND page_title RLIKE '^.*\.(css|js)$'
		GROUP BY rev_user_text
) edits ON name = user_name;


select user, cnt from user join user_groups on ug_group = 'interface-editor' and ug_user = user_id left join (select rev_user_text user, count(*) cnt from page straight_join revision on rev_page = page_id where page_namespace = 8 and page_title rlike '^.*\.(css|js)$' group 
by rev_user_text) edits on user = user_name;

SQL

Checking query status...