Wikipedia:List of wikipedians by Commons upload sizes
Appearance
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 |
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 |