Wikipedia:List of wikipedians by Commons upload sizes

From Wikipedia, the free encyclopedia
Jump to: navigation, search

This is a list of Wikipedians by the amount of data they have uploaded to Commons.

Generating the data[edit]

To generate this query, find someone who has toolserver access and have them run the following query on the commonswiki_p database:

mysql> SELECT img_user_text AS user, SUM(img_size) AS total_upload_size FROM image GROUP BY user ORDER BY total_upload_size DESC LIMIT 10;

October 2009[edit]

Rank User Bytes
1 GerWsUpload 166499435239
2 BotMultichillT 107938157960
3 File Upload Bot (Magnus Manske) 81956504267
4 Dcoetzee 80231173764
5 Flickr upload bot 71037988356
6 DcoetzeeBot 46907282948
7 Infrogmation 38930964998
8 Mbdortmund 35006791514
9 Jmabel 33851460443
10 AndreasPraefcke 32845272248

Top 1000


September 2007[edit]

Rank User Bytes
1 GerWsUpload 45728473908
2 Infrogmation 17630099277
3 MarcBot 11654894160
4 G.dallorto 9792359453
5 Red Rooster 8735780555
6 Jastrow 7452304928
7 Sailko 7285896135
8 AndreasPraefcke 7093517481
9 Rama 7056929041
10 663highland 6947084813

Top 1000