Central notice template top editors

SQL

SET SESSION group_concat_max_len = 1000000;
SET @row = 0;
SELECT 
	@row := @row+1 as `#`,
    userpage,
    number,
    (CASE WHEN userpage LIKE "%(WM%"  OR userpage LIKE "%-WM%" THEN "staff" ELSE "volunteer" END) AS role,
    banners
FROM(
  SELECT 
  	CONCAT("[[User:", rev_user_text, "|", rev_user_text, "]]") AS userpage,
  	COUNT(*) AS number,
  	CONCAT(
      "[[Mediawiki:",
      GROUP_CONCAT(DISTINCT page_title ORDER BY page_title ASC SEPARATOR "]], [[Mediawiki:"),
      "]]") as banners
  FROM metawiki_p.page p
  JOIN metawiki_p.revision_userindex r
  	ON p.page_namespace = 8
  	AND p.page_title LIKE "Centralnotice-template%"
  	AND rev_timestamp > 20170101000000
  	AND p.page_id = r.rev_page 
  GROUP BY rev_user 
  ORDER BY number DESC
) resultset
SQL

Checking query status...
