User:Krinkle/Queries/commonswiki recenthumantopuploaders

commons.wikimedia.org : Recent (human) top uploaders
    Last update: 2014-07-26 12:53 (UTC)

# file.sh
sql commonswiki_p < recenthumantopuploaders.sql > commonswiki_recenthumantopuploaders.txt

# file.sql
SELECT

	concat(
		'<tr><td>(',
			'[[commons:User_talk:',
			rc_user_text,
			'|talk]] | [[commons:Special:Contributions/',
			rc_user_text,
			'|contribs]] | [[commons:Special:ListFiles/',
			rc_user_text,
			'|uploads]] | [[sulutil:',
			rc_user_text,
			'|SUL-util]] | [[commons:Special:UserRights/',
			rc_user_text,
			'|userrights]]',
		') [[commons:User:',
		rc_user_text,
		'|',
		rc_user_text,
		']]</td><td>',
		COUNT(*),
		'</td></tr> '
	)

FROM recentchanges
WHERE rc_namespace = 6
AND rc_bot = 0
AND rc_type = 3
AND rc_log_action = 'upload' /* don't count re-uploads etc. */
GROUP BY rc_user
ORDER BY COUNT(*) DESC
LIMIT 25;


# file.txt