Most active WLM uploaders

SQL

USE commonswiki_p;

SELECT  @rownum := @rownum + 1 AS rank,
		username,
        gallery 
FROM        
(
	SELECT 
		CONCAT(
      		'[[User:', rev_user_text, '|', rev_user_text, ']]'
    	) AS username, 
    	CONCAT(
      		'[https://commons.wikimedia.org/wiki/Special:ListFiles',
      		'?user=', REPLACE(rev_user_text, ' ', '_'), 
      		' ', COUNT(1), ']'           
    	) AS gallery,
    	COUNT(1) AS images          
FROM commonswiki_p.revision r
join commonswiki_p.categorylinks c
on r.rev_page = c.cl_from
WHERE rev_parent_id = 0
and c.cl_to = "Images_from_Wiki_Loves_Monuments_2016"   
	GROUP BY rev_user_text
	ORDER BY images DESC
  	LIMIT 100
) t, 
(SELECT @rownum := 0) r
SQL

Checking query status...
