Most AWB edits past month

Fork of Most AutoWikiBrowser edits in last 30 days by Novem Linguae

This query is marked as a draft This query has been published by Infrastruktur.

SQL

USE nowiki_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 revision.rev_actor 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...