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 user_name AS 'Név', IF(cnt, cnt, 0) AS 'Szerkesztések', IF(ug_group = 'sysop', 'admin', 'felületszerkesztő') AS 'Csoport'
	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_table ON name = user_name
	ORDER BY cnt DESC;

SQL

Checking query status...