Commons:Database reports/Upload log stats
All upload logs
Top 300 users with the most upload log entries. Data as of 19:11, 7 May 2026 (UTC). See also mw:Manual:Log actions
| sql used |
|---|
SELECT
actor_image.actor_name AS username,
COUNT(logging.log_id) AS count
FROM logging
INNER JOIN actor_image
ON log_actor = actor_id
WHERE logging.log_type = "upload"
GROUP BY actor_image.actor_name
ORDER BY COUNT(actor_image.actor_name) DESC
LIMIT 300;
— Preceding unsigned comment added by Steinsplitter (talk • contribs) 18:18, 19 November 2014 (UTC) |
- DPLA bot (10652772)
- GeographBot (8055183)
- Fæ (7186095)
- Gzen92Bot (6031788)
- PantheraLeo1359531 (5089140)
- Askeuhd (3054141)
- Mr.Nostalgic (2718570)
- Panoramio upload bot (2416390)
- Doc James (1642823)
- Ser Amantio di Nicolao (1611033)
- Wmr-bot (1607708)
- File Upload Bot (Magnus Manske) (1359581)
- AskeBot (1310468)
- OptimusPrimeBot (1281439)
- Judgefloro (1280506)
- File Upload Bot (99of9) (1234071)
- Jeuwre (1197699)
- Tm (1077083)
- Polona Upload (1068519)
- Marcel coenders (862953)
- BotMultichillT (777393)
- PencakeBot (702224)
- EUResourcesBot (654343)
- Chabe01 (544233)
- CuratorBot (486603)
- DerHexer (472753)
- US National Archives bot (456514)
- SecretName101 (449978)
- Sailko (417392)
- Bot for Freedom (398987)
- BotMultichill (375958)
- Pharos (369352)
- Rudolphous (363638)
- Matlin (352048)
- Slick-o-bot (338044)
- SteinsplitterBot (337891)
- Jc86035 (336758)
- Tyler ser Noche (328067)
- GerWsUpload (320385)
- Tilman2007 (316962)
- Orizan (315566)
- Sturm (312884)
- A1Cafel (307059)
- Hansmuller (299703)
- Summer ... hier! (296683)
- Nowakki (281723)
- Flickr upload bot (262442)
- Mindmatrix (228115)
- Geagea (225790)
- Maltaper (220929)
- Jérémy-Günther-Heinz Jähnick (208698)
- Butko (205663)
- AliciaFagervingWMSE-bot (202834)
- Fabe56 (202121)
- MGeog2022 (200904)
- Artix Kreiger 2 (193951)
- C.Suthorn (186145)
- Юрий Д.К. (183506)
- TaurusEmerald (182036)
- Svema (181641)
- Oxyman (179583)
- Cewbot (179543)
- GPSLeo (179324)
- Ooligan (173272)
- Vitaly Zdanevich (170035)
- Sandro Halank (169979)
- Infrogmation (168279)
- Hiàn (alt) (167472)
- Jason.nlw (166384)
- Russavia (165837)
- DALIBRI (165799)
- FSII (164644)
- Josve05a (159406)
- 6D (159239)
- OceanAtoll (152606)
- BMacZeroBot (149875)
- Vinayaraj (148158)
- Ies (146440)
- Zarateman (145173)
- DarwIn (144059)
- RandomUserGuy1738 (143499)
- DaxServer (142963)
- Sporti (142947)
- ComputerHotline (140276)
- Donald Trung (134999)
- Famartin (128672)
- Rotatebot (125437)
- Globetrotter19 (123254)
- JonasBR (122645)
- Christian Ferrer (122079)
- Pikiwikisrael (121136)
- Yacàwotçã (118849)
- Balabinrm (117536)
- John Robert McPherson (115927)
- CdnMCG (115411)
- Daderot (115146)
- Zairon (114934)
- GazothBot (114897)
- Luisalvaz (113481)
- SeichanGant (112499)
- Roland45 (110433)
- Gerd Eichmann (109311)
- Dosseman (109157)
- LN9267 (108618)
- Mike Peel (108160)
- Ramon FVelasquez (107173)
- Marcus Cyron (106438)
- ŠJů (104030)
- Matanya (103718)
- Faebot (103017)
- Alfvanbeem (102376)
- A. Wagner (101964)
- GeorgDerReisende (101167)
- Palickap (100720)
- Pyb (99795)
- Jeangagnon (99664)
- Smaxims (99426)
- Leaderbot (98437)
- 999real (96364)
- GFreihalter (95826)
- Stefan.lefnaer (92587)
- OSX II (92038)
- Wdwdbot (90761)
- Geo Swan (88529)
- Sebastian Wallroth (88520)
- YiFeiBot (88407)
- Thirunavukkarasye-Raveendran (87848)
- Thesupermat2 (87029)
- Rufus46 (86987)
- 1Veertje (86055)
- Raboe001 (85942)
- Tournasol7 (85643)
- Luiz79 (85040)
- Țetcu Mircea Rareș (84916)
- Jmabel (84596)
- Sintegrity (84314)
- AnRo0002 (83554)
- Paris 16 (82987)
- DcoetzeeBot (82954)
- Vanished Account Byeznhpyxeuztibuo (82952)
- BArchBot (82888)
- Psubhashish (82728)
- Kingofthedead (81843)
- Kenraiz (81277)
- Syrio (80806)
- Senapa (79502)
- V Bhavya (79074)
- RobotMichiel1972 (77986)
- LBelo (WMB) (77479)
- 19Tarrestnom65 (77222)
- Svetlov Artem (76510)
- Helmy oved (74779)
- P.poschadel (74684)
- RKBot (73977)
- OgreBot (73948)
- Kidfly182 (73501)
- Raymond (72836)
- Jeanhousen (72549)
- MGA73bot2 (72344)
- GO69 (71647)
- Copyfraud (71399)
- Engelberthumperdink (70990)
- PMRMaeyaert (69493)
- KOKUYO (69176)
- Rodrigo.Argenton (68713)
- Tokumeigakarinoaoshima (68377)
- Hassocks5489 (68267)
- FinnaUploadBot (67625)
- Ssgapu22 (67374)
- Doko (66945)
- DonabelSDSU.bot (66594)
- François GOGLINS (65935)
- FrDr (65509)
- PID-Bangladesh-UploadBot (65306)
- Another Believer (65173)
- Juandev (65137)
- 円周率３パーセント (64938)
- Olaf (64793)
- Gikü (64608)
- Petr1888 (64606)
- Sic19 (64115)
- Gangulybiswarup (63540)
- Tschubby (62991)
- MasterRus21thCentury (62983)
- Kazimier Lachnovič (62715)
- Kaiketsu (62568)
- Holger.Ellgaard (62206)
- Ricardalovesmonuments (62113)
- FotothekBot (61912)
- KRLS (61817)
- Norman.seibert (61524)
- Ultra7 (61467)
- Thesupermat (61380)
- Wilfredor (61208)
- Z thomas (60799)
- Meisam (60777)
- Bybbisch94 (60523)
- Soghomon Matevosyan (60484)
- Thomas Hummel (59865)
- Titodutta (59847)
- Pere prlpz (59743)
- Solomon203 (59600)
- Poudou99 (59414)
- N509FZ (59153)
- AndreasPraefcke (58995)
- Romaine (58543)
- Atamari (57893)
- SchiDD (57745)
- Pasztilla (57105)
- Chris Light (56947)
- MOs810 (56937)
- ETH-Bibliothek (56860)
- Ванилица (56842)
- Dguendel (56388)
- Materialscientist (55991)
- MidleadingBot (55948)
- WikiLucas00 (55855)
- Rama (55429)
- Ralf Roletschek (55383)
- Iridescent (54778)
- Puramyun31 (54741)
- Frettiebot (54554)
- Victuallers (54117)
- Txllxt TxllxT (54084)
- Чаховіч Уладзіслаў (54025)
- MBHbot (53848)
- Sakib Bot (53844)
- Magnus Manske (53238)
- Hyppolyte de Saint-Rambert (53027)
- Brwz (52970)
- Pohled 111 (52801)
- Benoît Prieur (52662)
- Renhour48 (52337)
- 12akd (51951)
- Christo (50973)
- MartinVeselka (50879)
- BhagyaMohan (50740)
- Huhu Uet (50389)
- Aagnverglaser (50312)
- Retired electrician (49868)
- Vis M (49839)
- Salicyna (49758)
- Poco a poco (49648)
- Werner100359 (49611)
- Gone Postal (49588)
- Lepticed7 (49535)
- Swiss National Library (49460)
- Killarnee (49290)
- Wmilbot (49092)
- Ekirahardian (48916)
- EN-Jungwon (48811)
- Damian B Oh (48770)
- Enric (48713)
- MCastro (WMB) (48632)
- Bruno-ban (48151)
- Ebrahim (48073)
- Rakoon (48044)
- Discasto (48034)
- Nevit (47892)
- LSHuploadBot (47553)
- Michiel1972 (47076)
- Giftzwerg 88 (47065)
- HWY Shield Bot (46918)
- Indonesiagood (46784)
- Stepro (46504)
- Neuchâtel Herbarium (46305)
- Nicolas Rück (WMDE) (46289)
- Minerva97 (45772)
- Hanooz (45764)
- Aktron (45679)
- Kwangmo (45559)
- MarcBot~commonswiki (45389)
- S. Bollmann (45279)
- INeverCry (45181)
- Chatsam (45081)
- Pigsonthewing (44986)
- KITbot (44966)
- Michael Barera (44695)
- Metilsteiner (44612)
- DerbethBot (44488)
- Joanbanjo (44404)
- Llywelyn2000 (44311)
- Smallbot (44031)
- Tdorante10 (43817)
- AnankeBot (43593)
- Streamline8988 (43376)
- Rasbak (43226)
- そらみみ (43050)
- Kotavusik (42930)
- FastilyClone (42795)
- Cephas (42521)
- Embedded Data Bot (42476)
- Red panda bot (42346)
- Phương Huy (42130)
- Azniv Stepanian (WMAM) (42089)
- Zala (41776)
- Manchesterunited1234 (41612)
- Chris.sherlock2 (41549)
- Alexkrakovsky (41514)
- Gérald Garitan (41471)
Overwriting
Top 200 users with the most "overwrite" entries.
| sql used |
|---|
SELECT
actor_image.actor_name AS username,
COUNT(logging.log_id) AS count
FROM logging
INNER JOIN actor_image
ON log_actor = actor_id
WHERE logging.log_type = "upload"
AND logging.log_action = "overwrite"
GROUP BY actor_image.actor_name
ORDER BY COUNT(actor_image.actor_name) DESC
LIMIT 200;
— Preceding unsigned comment added by Steinsplitter (talk • contribs) 18:21, 19 November 2014 (UTC) |
- File Upload Bot (99of9) (1051865)
- Mr.Nostalgic (430045)
- Fæ (413318)
- SteinsplitterBot (337891)
- Summer ... hier! (294578)
- DPLA bot (284585)
- AskeBot (226559)
- Cewbot (173302)
- C.Suthorn (142445)
- Rotatebot (125431)
- Leaderbot (97398)
- Faebot (85750)
- OgreBot (73072)
- Jc86035 (54636)
- Doc James (51679)
- Sebastian Wallroth (46881)
- Embedded Data Bot (42444)
- Hbf878 (33310)
- FSII (32159)
- FlickreviewR 2 (30100)
- Jeuwre (27977)
- FlickreviewR (27431)
- Beao (27235)
- Ras67 (27071)
- Cropbot (26920)
- Thirunavukkarasye-Raveendran (26585)
- PantheraLeo1359531 (25320)
- Pelikana (24815)
- Slick-o-bot (24318)
- Materialscientist (23924)
- Eiabot (22875)
- Jochen Burghardt (21414)
- Fry1989 (20761)
- LanguageScreenshotBot (20503)
- NordNordWest (19921)
- Txllxt TxllxT (19395)
- Geograph Update Bot (18305)
- Putitonamap98 (16510)
- Hohum (15328)
- Poco a poco (15268)
- Tschubby (14961)
- Dosseman (14506)
- VortBot (14273)
- Michiel1972 (14267)
- Jacek Halicki (14176)
- BhagyaMohan (14085)
- Kazimier Lachnovič (14002)
- R8cocin8 (13011)
- Cmdrjameson (12961)
- Kwamikagami (12927)
- MPF (12908)
- Lomita (12857)
- Renamed user 995577823Xyn (12534)
- PawełMM (12466)
- Smasongarrison (12255)
- XRay (12166)
- NearEMPTiness (12150)
- XplusMapBot (12075)
- FMSky (11726)
- HWY Shield Bot (11705)
- Wdwdbot (11140)
- UKBot (11084)
- JonasBR (11031)
- Jmabel (10727)
- Krdbot (10326)
- TaurusEmerald (10258)
- WiebkeCBo (10215)
- Paris 16 (10135)
- ColaziviBot (10090)
- WikiPedant (10021)
- Meow (9856)
- Rauenstein (9854)
- Țetcu Mircea Rareș (9733)
- Vysotsky (9680)
- Salicyna (9549)
- Twofortnights (9494)
- YannBot (9220)
- Thomascampbell123 (9180)
- DonabelSDSU.bot (9055)
- Michael Barera (8952)
- McZusatz (8761)
- Remitamine (8748)
- CoronaBot (8658)
- Fredddie (8636)
- Wvdp (8611)
- Ekirahardian (8334)
- Irypixel (8316)
- File Upload Bot (Magnus Manske) (8291)
- Milenioscuro (8160)
- Holger.Ellgaard (8069)
- Supportstorm (7918)
- Bruno-ban (7874)
- Minorax (7851)
- Impru20 (7686)
- ديفيد عادل وهبة خليل 2 (7528)
- Jahobr (7452)
- Ich (7020)
- BMacZeroBot (6999)
- MasterRus21thCentury (6960)
- Aquintero82 (6938)
- Finavon (6891)
- Plozessor (6808)
- Watchduck (6640)
- Joalbertine (6622)
- Jeangagnon (6604)
- Monaneko (6542)
- HermannSchachner (6512)
- Geagea (6330)
- Cobatfor (6315)
- Bzhqc (6239)
- Wilfredor (6216)
- Janwillemvanaalst (6197)
- Tbm (6162)
- Panoramio upload bot (6100)
- Adam Cuerden (6043)
- Yann (5978)
- Chris06 (5865)
- पाटलिपुत्र (5806)
- Sailko (5806)
- Sporti (5788)
- Ducksoup (5734)
- Mediatus (5633)
- SpinnerLaserzthe2nd (5560)
- Illegitimate Barrister (5558)
- AnonMoos (5463)
- M2545 (5382)
- Acabashi (5379)
- Subbass1 (5325)
- OSX (5311)
- 1970gemini (5254)
- Quibik (5254)
- Tilman2007 (5237)
- Hans G. Oberlack (5201)
- Trzęsacz (5149)
- Swiss Federal Archives (5131)
- ReneeWrites (5095)
- Roland zh (5090)
- Enyavar (5063)
- Chabe01 (5038)
- Ron Clausen (4980)
- Jarekt (4979)
- TUBS (4958)
- Edithsme (4924)
- LoKiLeCh (4901)
- Heralder (4901)
- Marcus Cyron (4869)
- Hansmuller (4864)
- Marcel coenders (4835)
- Sameboat (4747)
- KAVEBEAR (4738)
- Vincent Steenberg (4731)
- HerrAdams (4722)
- Shakko (4711)
- มองโกเลีย๔๔ (4687)
- Ssgapu22 (4608)
- Vyacheslav Bukharov (4607)
- FunkMonk (4607)
- Jan Arkesteijn (4560)
- Fma12 (4516)
- Soerfm (4504)
- Hic et nunc (4490)
- Ebrahim (4446)
- Tomruen (4443)
- Perhelion (4398)
- Cookie030307 (4395)
- Ajpvalente (4381)
- US National Archives bot (4378)
- Kwlam259 (4323)
- Nux (4304)
- Common Good (4304)
- GerWsUpload (4272)
- Tm (4268)
- Pi.1415926535 (4260)
- JuTa (4243)
- Moumou82 (4243)
- Arbalete (4238)
- Noclador (4224)
- Jbarta (4219)
- Mike Peel (4216)
- Fleets (4176)
- Animalparty (4165)
- Titodutta (4124)
- Zinoviev (4121)
- IBryanDP (4051)
- Archaeodontosaurus (4025)
- Sangjinhwa (4018)
- Bjh21 (4006)
- Vzeebjtf (3998)
- Golbez (3963)
- User-duck (3886)
- Lojwe (3873)
- Togabi (3862)
- Furfur (3848)
- Neuchâtel Herbarium (3830)
- Shyamal (3804)
- Alonso de Mendoza (3799)
- LostplanetKD73 (3798)
- Skjoldbro (3791)
- Madboy74 (3745)
- Sarang (3723)
Upload
Top 200 users with the most "uploads" entries.
| sql used |
|---|
SELECT
actor_image.actor_name AS username,
COUNT(logging.log_id) AS count
FROM logging
INNER JOIN actor_image
ON log_actor = actor_id
WHERE logging.log_type = "upload"
AND logging.log_action = "upload"
GROUP BY actor_image.actor_name
ORDER BY COUNT(actor_image.actor_name) DESC
LIMIT 200;
— Preceding unsigned comment added by Steinsplitter (talk • contribs) 18:26, 19 November 2014 (UTC) |
- DPLA bot (10368187)
- GeographBot (8052158)
- Fæ (6772692)
- Gzen92Bot (6031784)
- PantheraLeo1359531 (5063558)
- Askeuhd (3053965)
- Panoramio upload bot (2410290)
- Mr.Nostalgic (2288442)
- Ser Amantio di Nicolao (1610929)
- Wmr-bot (1606808)
- Doc James (1591132)
- File Upload Bot (Magnus Manske) (1351289)
- Judgefloro (1280036)
- OptimusPrimeBot (1278665)
- Jeuwre (1169684)
- AskeBot (1083909)
- Tm (1070859)
- Polona Upload (1068518)
- Marcel coenders (858116)
- BotMultichillT (777089)
- PencakeBot (702224)
- EUResourcesBot (654343)
- Chabe01 (539147)
- CuratorBot (486603)
- DerHexer (472293)
- US National Archives bot (452136)
- SecretName101 (447450)
- Sailko (411539)
- Bot for Freedom (398975)
- BotMultichill (375660)
- Pharos (367322)
- Rudolphous (363605)
- Matlin (351605)
- Tyler ser Noche (328064)
- GerWsUpload (316113)
- Orizan (315566)
- Slick-o-bot (313726)
- Sturm (312848)
- Tilman2007 (311723)
- A1Cafel (305531)
- Hansmuller (294834)
- Jc86035 (282071)
- Nowakki (281721)
- Flickr upload bot (258986)
- Mindmatrix (227969)
- Geagea (219328)
- Maltaper (219007)
- Jérémy-Günther-Heinz Jähnick (206931)
- Butko (203466)
- AliciaFagervingWMSE-bot (202618)
- Fabe56 (202108)
- MGeog2022 (200889)
- Artix Kreiger 2 (193950)
- Юрий Д.К. (182250)
- File Upload Bot (99of9) (182206)
- Svema (181534)
- Oxyman (179565)
- GPSLeo (178952)
- Ooligan (172365)
- TaurusEmerald (171747)
- Vitaly Zdanevich (169906)
- Sandro Halank (169519)
- Hiàn (alt) (167469)
- Infrogmation (166399)
- DALIBRI (165746)
- Jason.nlw (165148)
- Russavia (164238)
- 6D (159164)
- Josve05a (158821)
- OceanAtoll (152606)
- Vinayaraj (147545)
- Ies (145878)
- Zarateman (144803)
- DaxServer (142947)
- BMacZeroBot (142876)
- RandomUserGuy1738 (142727)
- DarwIn (141419)
- ComputerHotline (140077)
- Sporti (137144)
- Donald Trung (134258)
- FSII (132485)
- Famartin (126441)
- Globetrotter19 (121486)
- Pikiwikisrael (120974)
- Yacàwotçã (118501)
- Christian Ferrer (118356)
- Balabinrm (117313)
- John Robert McPherson (115725)
- Daderot (115011)
- Zairon (114929)
- GazothBot (114897)
- CdnMCG (113628)
- Luisalvaz (113362)
- SeichanGant (112436)
- JonasBR (110802)
- Roland45 (109912)
- Gerd Eichmann (109249)
- LN9267 (108528)
- Ramon FVelasquez (107090)
- Mike Peel (103938)
- Matanya (103581)
- ŠJů (102596)
- Alfvanbeem (102311)
- Marcus Cyron (101553)
- GeorgDerReisende (101091)
- A. Wagner (100458)
- Palickap (100161)
- Smaxims (99068)
- Pyb (96565)
- 999real (95743)
- GFreihalter (95434)
- Dosseman (94603)
- Jeangagnon (93059)
- Stefan.lefnaer (92455)
- OSX II (91477)
- YiFeiBot (87590)
- Thesupermat2 (87028)
- Rufus46 (86893)
- Geo Swan (86226)
- Raboe001 (85158)
- Luiz79 (85028)
- Tournasol7 (84961)
- Sintegrity (84225)
- AnRo0002 (83227)
- BArchBot (82888)
- 1Veertje (82850)
- Vanished Account Byeznhpyxeuztibuo (82651)
- DcoetzeeBot (82090)
- Kenraiz (81169)
- Syrio (80572)
- Wdwdbot (79621)
- Psubhashish (79447)
- Kingofthedead (79245)
- Senapa (78682)
- RobotMichiel1972 (77967)
- V Bhavya (77611)
- LBelo (WMB) (77332)
- 19Tarrestnom65 (77205)
- Țetcu Mircea Rareș (75183)
- Svetlov Artem (74935)
- Helmy oved (74070)
- P.poschadel (73982)
- RKBot (73830)
- Jmabel (73741)
- Kidfly182 (73501)
- Paris 16 (72828)
- Jeanhousen (72458)
- MGA73bot2 (71872)
- GO69 (71420)
- Copyfraud (71399)
- Engelberthumperdink (70857)
- Raymond (70111)
- Rodrigo.Argenton (68371)
- Hassocks5489 (68108)
- KOKUYO (68047)
- Tokumeigakarinoaoshima (67528)
- Doko (66033)
- PMRMaeyaert (66018)
- François GOGLINS (65789)
- FrDr (65507)
- PID-Bangladesh-UploadBot (65306)
- Juandev (65047)
- Another Believer (65023)
- 円周率３パーセント (64916)
- FinnaUploadBot (64878)
- Petr1888 (64540)
- Gikü (64308)
- Sic19 (64100)
- Olaf (63599)
- Gangulybiswarup (63531)
- Ssgapu22 (62766)
- FotothekBot (61912)
- KRLS (61672)
- Kaiketsu (61514)
- Thirunavukkarasye-Raveendran (61263)
- Ultra7 (61045)
- Thesupermat (61036)
- Norman.seibert (60929)
- Meisam (60713)
- Z thomas (60694)
- Bybbisch94 (60488)
- Soghomon Matevosyan (59917)
- Pere prlpz (59643)
- Thomas Hummel (59518)
- Ricardalovesmonuments (59308)
- N509FZ (58902)
- Romaine (58413)
- Poudou99 (58327)
- Solomon203 (58124)
- DonabelSDSU.bot (57539)
- Atamari (57218)
- Pasztilla (57064)
- MOs810 (56929)
- AndreasPraefcke (56902)
- ETH-Bibliothek (56834)
- Ванилица (56798)
- Chris Light (56559)
- SchiDD (55948)
- MasterRus21thCentury (55914)
- MidleadingBot (55912)