Commons:Database reports/Upload log stats
All upload logs
Top 300 users with the most upload log entries. Data as of 19:19, 19 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 (10949789)
- GeographBot (8065376)
- Fæ (7186095)
- Gzen92Bot (6031788)
- PantheraLeo1359531 (5305954)
- Askeuhd (3054141)
- Mr.Nostalgic (2718570)
- Panoramio upload bot (2416390)
- Doc James (1759964)
- Ser Amantio di Nicolao (1611033)
- Wmr-bot (1607708)
- File Upload Bot (Magnus Manske) (1359581)
- AskeBot (1310468)
- OptimusPrimeBot (1291615)
- Judgefloro (1280506)
- File Upload Bot (99of9) (1234071)
- Jeuwre (1204783)
- Tm (1083728)
- Polona Upload (1068519)
- Marcel coenders (863865)
- BotMultichillT (777393)
- PencakeBot (702224)
- EUResourcesBot (654343)
- Chabe01 (545507)
- CuratorBot (486603)
- DerHexer (472753)
- US National Archives bot (456514)
- SecretName101 (449983)
- Sailko (418494)
- Bot for Freedom (398987)
- BotMultichill (375958)
- Pharos (369354)
- Rudolphous (363638)
- Matlin (352048)
- SteinsplitterBot (341073)
- Slick-o-bot (338044)
- Jc86035 (336758)
- Tyler ser Noche (328067)
- GerWsUpload (320385)
- Tilman2007 (316976)
- Orizan (315566)
- Sturm (312884)
- A1Cafel (307298)
- Hansmuller (299703)
- Summer ... hier! (296683)
- Nowakki (281723)
- Flickr upload bot (262442)
- Mindmatrix (228139)
- Geagea (225803)
- Maltaper (222072)
- MGeog2022 (211251)
- Jérémy-Günther-Heinz Jähnick (208698)
- Butko (205801)
- AliciaFagervingWMSE-bot (202834)
- Fabe56 (202122)
- Artix Kreiger 2 (193951)
- C.Suthorn (186146)
- Svema (185983)
- Юрий Д.К. (183957)
- TaurusEmerald (182250)
- GPSLeo (180885)
- Oxyman (179984)
- Cewbot (179695)
- Ooligan (174231)
- Sandro Halank (170129)
- Vitaly Zdanevich (170037)
- Infrogmation (168847)
- Hiàn (alt) (167472)
- Jason.nlw (166384)
- Russavia (165837)
- DALIBRI (165801)
- FSII (164644)
- 6D (160859)
- Josve05a (159406)
- OceanAtoll (152606)
- BMacZeroBot (149875)
- Vinayaraj (148162)
- Ies (146440)
- Zarateman (145512)
- DarwIn (144099)
- RandomUserGuy1738 (143821)
- Sporti (142974)
- DaxServer (142963)
- ComputerHotline (141063)
- Donald Trung (135005)
- Famartin (128884)
- Rotatebot (125437)
- Globetrotter19 (123549)
- JonasBR (122772)
- Christian Ferrer (122299)
- Pikiwikisrael (121380)
- Yacàwotçã (118900)
- Balabinrm (117536)
- John Robert McPherson (116140)
- CdnMCG (115411)
- Daderot (115216)
- Zairon (114934)
- GazothBot (114897)
- Luisalvaz (114100)
- SeichanGant (112499)
- LN9267 (110910)
- Roland45 (110433)
- Dosseman (110372)
- Gerd Eichmann (109546)
- Mike Peel (108160)
- Ramon FVelasquez (107173)
- Marcus Cyron (106450)
- ŠJů (104030)
- Matanya (103718)
- Faebot (103017)
- Alfvanbeem (102376)
- A. Wagner (102081)
- GeorgDerReisende (101814)
- Palickap (101028)
- Leaderbot (100486)
- Jeangagnon (100050)
- Pyb (99795)
- Smaxims (99522)
- 999real (96399)
- GFreihalter (95981)
- Stefan.lefnaer (92587)
- OSX II (92038)
- Wdwdbot (90761)
- Geo Swan (88746)
- Sebastian Wallroth (88692)
- YiFeiBot (88407)
- Thirunavukkarasye-Raveendran (87848)
- Rufus46 (87258)
- Thesupermat2 (87029)
- 1Veertje (86059)
- Tournasol7 (85943)
- Raboe001 (85942)
- Țetcu Mircea Rareș (85073)
- Luiz79 (85071)
- Jmabel (84738)
- Sintegrity (84415)
- AnRo0002 (83727)
- Paris 16 (82987)
- DcoetzeeBot (82954)
- Vanished Account Byeznhpyxeuztibuo (82952)
- BArchBot (82888)
- Psubhashish (82759)
- Kingofthedead (81843)
- Kenraiz (81558)
- Syrio (80868)
- Senapa (79504)
- V Bhavya (79074)
- RobotMichiel1972 (77986)
- LBelo (WMB) (77479)
- 19Tarrestnom65 (77222)
- Svetlov Artem (76510)
- MGA73bot2 (75584)
- Helmy oved (74779)
- P.poschadel (74684)
- RKBot (73977)
- OgreBot (73948)
- Kidfly182 (73728)
- Raymond (73011)
- Jeanhousen (72549)
- GO69 (71647)
- Copyfraud (71399)
- Engelberthumperdink (70990)
- PMRMaeyaert (69493)
- KOKUYO (69176)
- Rodrigo.Argenton (68713)
- Tokumeigakarinoaoshima (68415)
- Hassocks5489 (68267)
- FinnaUploadBot (67706)
- Ssgapu22 (67374)
- Doko (67044)
- DonabelSDSU.bot (66594)
- François GOGLINS (65984)
- Gikü (65723)
- PID-Bangladesh-UploadBot (65694)
- FrDr (65540)
- 円周率３パーセント (65285)
- Another Believer (65206)
- Juandev (65137)
- Olaf (64793)
- Petr1888 (64606)
- Sic19 (64115)
- MasterRus21thCentury (63749)
- Gangulybiswarup (63540)
- Tschubby (63012)
- Kazimier Lachnovič (62715)
- Ricardalovesmonuments (62693)
- Kaiketsu (62568)
- Holger.Ellgaard (62206)
- FotothekBot (61912)
- KRLS (61817)
- Norman.seibert (61524)
- Ultra7 (61467)
- Thesupermat (61380)
- Wilfredor (61224)
- Bybbisch94 (60947)
- Z thomas (60930)
- Meisam (60777)
- Soghomon Matevosyan (60484)
- Thomas Hummel (60125)
- Pere prlpz (59860)
- Titodutta (59847)
- Solomon203 (59786)
- Poudou99 (59415)
- N509FZ (59262)
- AndreasPraefcke (58995)
- Romaine (58586)
- Atamari (57893)
- SchiDD (57881)
- Chris Light (57191)
- Pasztilla (57105)
- MOs810 (57087)
- ETH-Bibliothek (56871)
- Ванилица (56842)
- Dguendel (56623)
- Materialscientist (55999)
- MidleadingBot (55948)
- WikiLucas00 (55855)
- Rama (55429)
- Ralf Roletschek (55384)
- Iridescent (54778)
- Puramyun31 (54741)
- Frettiebot (54554)
- Victuallers (54460)
- Txllxt TxllxT (54084)
- Чаховіч Уладзіслаў (54027)
- MBHbot (53848)
- Sakib Bot (53844)
- Pohled 111 (53645)
- Magnus Manske (53238)
- Hyppolyte de Saint-Rambert (53027)
- Brwz (52970)
- Benoît Prieur (52662)
- Renhour48 (52337)
- 12akd (51951)
- Christo (51429)
- MartinVeselka (50952)
- BhagyaMohan (50740)
- Retired electrician (50622)
- Huhu Uet (50389)
- Aagnverglaser (50388)
- Vis M (49845)
- Werner100359 (49763)
- Salicyna (49758)
- Poco a poco (49655)
- Gone Postal (49588)
- Lepticed7 (49535)
- Swiss National Library (49460)
- Killarnee (49290)
- Wmilbot (49092)
- Ekirahardian (48916)
- EN-Jungwon (48811)
- Damian B Oh (48770)
- Enric (48742)
- MCastro (WMB) (48632)
- Bruno-ban (48382)
- Ebrahim (48073)
- Rakoon (48044)
- Discasto (48034)
- HWY Shield Bot (47915)
- Nevit (47892)
- LSHuploadBot (47553)
- Giftzwerg 88 (47316)
- Michiel1972 (47076)
- Indonesiagood (46784)
- Stepro (46671)
- Neuchâtel Herbarium (46305)
- Nicolas Rück (WMDE) (46289)
- Minerva97 (46278)
- Aktron (45836)
- Hanooz (45764)
- YannBot (45659)
- Kwangmo (45559)
- MarcBot~commonswiki (45389)
- S. Bollmann (45279)
- INeverCry (45181)
- Chatsam (45087)
- Pigsonthewing (45018)
- KITbot (44966)
- Michael Barera (44956)
- Metilsteiner (44612)
- DerbethBot (44488)
- Joanbanjo (44434)
- Llywelyn2000 (44312)
- Smallbot (44031)
- Tdorante10 (43968)
- AnankeBot (43593)
- Streamline8988 (43376)
- Rasbak (43252)
- そらみみ (43050)
- Kotavusik (42930)
- Manchesterunited1234 (42920)
- FastilyClone (42795)
- Cephas (42687)
- Zafer (42509)
- Embedded Data Bot (42476)
- Red panda bot (42422)
- Phương Huy (42130)
- Azniv Stepanian (WMAM) (42089)
- Zala (41934)
- Alexkrakovsky (41551)
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 (341073)
- Summer ... hier! (294578)
- DPLA bot (284594)
- AskeBot (226559)
- Cewbot (173444)
- C.Suthorn (142445)
- Doc James (136850)
- Rotatebot (125431)
- Leaderbot (99447)
- Faebot (85750)
- OgreBot (73072)
- Jc86035 (54636)
- Sebastian Wallroth (47041)
- Embedded Data Bot (42444)
- Hbf878 (33310)
- FSII (32159)
- FlickreviewR 2 (30104)
- Jeuwre (27977)
- Beao (27509)
- FlickreviewR (27431)
- Ras67 (27077)
- Cropbot (26920)
- Thirunavukkarasye-Raveendran (26585)
- PantheraLeo1359531 (25363)
- Pelikana (24850)
- Slick-o-bot (24318)
- Materialscientist (23927)
- Eiabot (22875)
- Jochen Burghardt (21415)
- Fry1989 (20771)
- LanguageScreenshotBot (20503)
- NordNordWest (19932)
- Txllxt TxllxT (19395)
- YannBot (18951)
- Geograph Update Bot (18305)
- Putitonamap98 (16561)
- Hohum (15341)
- Poco a poco (15275)
- Tschubby (14978)
- Dosseman (14506)
- VortBot (14273)
- Michiel1972 (14267)
- Jacek Halicki (14246)
- BhagyaMohan (14085)
- Kazimier Lachnovič (14002)
- R8cocin8 (13017)
- Cmdrjameson (12961)
- MPF (12938)
- Kwamikagami (12933)
- Lomita (12873)
- Renamed user 995577823Xyn (12534)
- PawełMM (12466)
- Smasongarrison (12255)
- XRay (12180)
- NearEMPTiness (12161)
- XplusMapBot (12075)
- FMSky (11726)
- HWY Shield Bot (11705)
- Wdwdbot (11140)
- UKBot (11130)
- JonasBR (11080)
- Jmabel (10771)
- Krdbot (10331)
- TaurusEmerald (10304)
- WiebkeCBo (10215)
- Paris 16 (10135)
- ColaziviBot (10090)
- WikiPedant (10034)
- Meow (9865)
- Rauenstein (9854)
- Vysotsky (9744)
- Țetcu Mircea Rareș (9733)
- Salicyna (9549)
- Twofortnights (9494)
- Thomascampbell123 (9228)
- DonabelSDSU.bot (9055)
- Michael Barera (9054)
- McZusatz (8761)
- Remitamine (8748)
- CoronaBot (8658)
- Fredddie (8636)
- Wvdp (8611)
- Ekirahardian (8334)
- Irypixel (8318)
- File Upload Bot (Magnus Manske) (8291)
- Milenioscuro (8161)
- Holger.Ellgaard (8069)
- Supportstorm (7918)
- Bruno-ban (7884)
- Minorax (7852)
- Impru20 (7694)
- ديفيد عادل وهبة خليل 2 (7528)
- Jahobr (7452)
- Ich (7185)
- MasterRus21thCentury (7023)
- BMacZeroBot (6999)
- Aquintero82 (6941)
- Finavon (6891)
- Plozessor (6810)
- Joalbertine (6680)
- Watchduck (6640)
- Jeangagnon (6604)
- Monaneko (6542)
- HermannSchachner (6512)
- Geagea (6332)
- Cobatfor (6322)
- Bzhqc (6240)
- Wilfredor (6231)
- Janwillemvanaalst (6197)
- Tbm (6162)
- Panoramio upload bot (6100)
- Adam Cuerden (6043)
- Yann (5984)
- Chris06 (5888)
- Pataliputra! (5851)
- Sailko (5810)
- Sporti (5788)
- Ducksoup (5734)
- Mediatus (5633)
- Illegitimate Barrister (5567)
- SpinnerLaserzthe2nd (5562)
- AnonMoos (5463)
- M2545 (5382)
- Acabashi (5380)
- Subbass1 (5325)
- OSX (5311)
- 1970gemini (5266)
- Quibik (5254)
- Tilman2007 (5237)
- Hans G. Oberlack (5202)
- Trzęsacz (5149)
- Swiss Federal Archives (5131)
- Enyavar (5120)
- ReneeWrites (5095)
- Roland zh (5090)
- Chabe01 (5039)
- Jarekt (4996)
- Ron Clausen (4980)
- มองโกเลีย๔๔ (4967)
- TUBS (4958)
- Edithsme (4924)
- LoKiLeCh (4901)
- Heralder (4901)
- Marcus Cyron (4872)
- Hansmuller (4864)
- Marcel coenders (4836)
- Sameboat (4747)
- KAVEBEAR (4738)
- Vincent Steenberg (4738)
- HerrAdams (4722)
- Shakko (4715)
- Ssgapu22 (4608)
- FunkMonk (4608)
- Vyacheslav Bukharov (4607)
- Jan Arkesteijn (4560)
- Fma12 (4523)
- Soerfm (4504)
- Hic et nunc (4490)
- Ebrahim (4446)
- Tomruen (4443)
- Perhelion (4398)
- Cookie030307 (4395)
- Ajpvalente (4394)
- US National Archives bot (4378)
- Kwlam259 (4323)
- Nux (4310)
- Common Good (4304)
- GerWsUpload (4272)
- Tm (4268)
- Pi.1415926535 (4263)
- JuTa (4243)
- Moumou82 (4243)
- Arbalete (4238)
- Noclador (4232)
- Jbarta (4219)
- Mike Peel (4216)
- Fleets (4179)
- Animalparty (4178)
- Titodutta (4124)
- Zinoviev (4121)
- IBryanDP (4053)
- Archaeodontosaurus (4026)
- Sangjinhwa (4018)
- Bjh21 (4006)
- Vzeebjtf (3998)
- Golbez (3963)
- Lojwe (3899)
- User-duck (3886)
- Togabi (3862)
- Furfur (3853)
- Neuchâtel Herbarium (3830)
- Shyamal (3809)
- Alonso de Mendoza (3799)
- LostplanetKD73 (3798)
- Skjoldbro (3791)
- Madboy74 (3746)
- Llez (3726)
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 (10665195)
- GeographBot (8062351)
- Fæ (6772692)
- Gzen92Bot (6031784)
- PantheraLeo1359531 (5280327)
- Askeuhd (3053965)
- Panoramio upload bot (2410290)
- Mr.Nostalgic (2288442)
- Doc James (1623102)
- Ser Amantio di Nicolao (1610929)
- Wmr-bot (1606808)
- File Upload Bot (Magnus Manske) (1351289)
- OptimusPrimeBot (1288623)
- Judgefloro (1280036)
- Jeuwre (1176768)
- AskeBot (1083909)
- Tm (1077504)
- Polona Upload (1068518)
- Marcel coenders (859027)
- BotMultichillT (777089)
- PencakeBot (702224)
- EUResourcesBot (654343)
- Chabe01 (540420)
- CuratorBot (486603)
- DerHexer (472293)
- US National Archives bot (452136)
- SecretName101 (447455)
- Sailko (412637)
- Bot for Freedom (398975)
- BotMultichill (375660)
- Pharos (367324)
- Rudolphous (363605)
- Matlin (351605)
- Tyler ser Noche (328064)
- GerWsUpload (316113)
- Orizan (315566)
- Slick-o-bot (313726)
- Sturm (312848)
- Tilman2007 (311737)
- A1Cafel (305770)
- Hansmuller (294834)
- Jc86035 (282071)
- Nowakki (281721)
- Flickr upload bot (258986)
- Mindmatrix (227993)
- Maltaper (220143)
- Geagea (219339)
- MGeog2022 (211236)
- Jérémy-Günther-Heinz Jähnick (206931)
- Butko (203604)
- AliciaFagervingWMSE-bot (202618)
- Fabe56 (202109)
- Artix Kreiger 2 (193950)
- Svema (185876)
- Юрий Д.К. (182684)
- File Upload Bot (99of9) (182206)
- GPSLeo (180513)
- Oxyman (179966)
- Ooligan (173323)
- TaurusEmerald (171915)
- Vitaly Zdanevich (169908)
- Sandro Halank (169669)
- Hiàn (alt) (167469)
- Infrogmation (166966)
- DALIBRI (165748)
- Jason.nlw (165148)
- Russavia (164238)
- 6D (160783)
- Josve05a (158821)
- OceanAtoll (152606)
- Vinayaraj (147549)
- Ies (145878)
- Zarateman (145142)
- RandomUserGuy1738 (143049)
- DaxServer (142947)
- BMacZeroBot (142876)
- DarwIn (141448)
- ComputerHotline (140863)
- Sporti (137171)
- Donald Trung (134264)
- FSII (132485)
- Famartin (126652)
- Globetrotter19 (121780)
- Pikiwikisrael (121218)
- Christian Ferrer (118575)
- Yacàwotçã (118551)
- Balabinrm (117313)
- John Robert McPherson (115938)
- Daderot (115081)
- Zairon (114929)
- GazothBot (114897)
- Luisalvaz (113981)
- CdnMCG (113628)
- SeichanGant (112436)
- JonasBR (110878)
- LN9267 (110816)
- Roland45 (109912)
- Gerd Eichmann (109484)
- Ramon FVelasquez (107090)
- Mike Peel (103938)
- Matanya (103581)
- ŠJů (102596)
- Alfvanbeem (102311)
- GeorgDerReisende (101736)
- Marcus Cyron (101562)
- A. Wagner (100575)
- Palickap (100469)
- Smaxims (99164)
- Pyb (96565)
- Dosseman (95818)
- 999real (95773)
- GFreihalter (95589)
- Jeangagnon (93445)
- Stefan.lefnaer (92455)
- OSX II (91477)
- YiFeiBot (87590)
- Rufus46 (87164)
- Thesupermat2 (87028)
- Geo Swan (86443)
- Tournasol7 (85260)
- Raboe001 (85158)
- Luiz79 (85059)
- Sintegrity (84326)
- AnRo0002 (83400)
- BArchBot (82888)
- 1Veertje (82854)
- Vanished Account Byeznhpyxeuztibuo (82651)
- DcoetzeeBot (82090)
- Kenraiz (81449)
- Syrio (80634)
- Wdwdbot (79621)
- Psubhashish (79475)
- Kingofthedead (79245)
- Senapa (78684)
- RobotMichiel1972 (77967)
- V Bhavya (77611)
- LBelo (WMB) (77332)
- 19Tarrestnom65 (77205)
- Țetcu Mircea Rareș (75340)
- MGA73bot2 (75112)
- Svetlov Artem (74935)
- Helmy oved (74070)
- P.poschadel (73982)
- Jmabel (73839)
- RKBot (73830)
- Kidfly182 (73728)
- Paris 16 (72828)
- Jeanhousen (72458)
- GO69 (71420)
- Copyfraud (71399)
- Engelberthumperdink (70857)
- Raymond (70281)
- Rodrigo.Argenton (68371)
- Hassocks5489 (68108)
- KOKUYO (68047)
- Tokumeigakarinoaoshima (67566)
- Doko (66131)
- PMRMaeyaert (66018)
- François GOGLINS (65838)
- PID-Bangladesh-UploadBot (65694)
- FrDr (65538)
- Gikü (65422)
- 円周率３パーセント (65263)
- Another Believer (65056)
- Juandev (65047)
- FinnaUploadBot (64959)
- Petr1888 (64540)
- Sic19 (64100)
- Olaf (63599)
- Gangulybiswarup (63531)
- Ssgapu22 (62766)
- FotothekBot (61912)
- KRLS (61672)
- Kaiketsu (61514)
- Thirunavukkarasye-Raveendran (61263)
- Ultra7 (61045)
- Thesupermat (61036)
- Norman.seibert (60929)
- Bybbisch94 (60912)
- Z thomas (60825)
- Meisam (60713)
- Soghomon Matevosyan (59917)
- Ricardalovesmonuments (59880)
- Thomas Hummel (59777)
- Pere prlpz (59760)
- N509FZ (59010)
- Romaine (58456)
- Poudou99 (58327)
- Solomon203 (58269)
- DonabelSDSU.bot (57539)
- Atamari (57218)
- MOs810 (57079)
- Pasztilla (57064)
- AndreasPraefcke (56902)
- ETH-Bibliothek (56845)
- Chris Light (56803)
- Ванилица (56798)
- MasterRus21thCentury (56616)
- SchiDD (56081)
- MidleadingBot (55912)