User:Krinkle/Queries/commonswiki recenthumantopuploaders
Appearance
< User:Krinkle | Queries
commons.wikimedia.org : Recent (human) top uploaders
Last update: 2014-07-26 12:53 (UTC)
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