Commons:Database reports/Upload log stats
All upload logs
Top 300 users with the most upload log entries. Data as of 20:47, 23 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 (11068286)
- GeographBot (8068579)
- Fæ (7186095)
- Gzen92Bot (6031788)
- PantheraLeo1359531 (5349959)
- Askeuhd (3054141)
- Mr.Nostalgic (2718570)
- Panoramio upload bot (2416390)
- Doc James (1770472)
- Ser Amantio di Nicolao (1611033)
- Wmr-bot (1607708)
- File Upload Bot (Magnus Manske) (1359581)
- AskeBot (1310468)
- OptimusPrimeBot (1295006)
- Judgefloro (1280506)
- File Upload Bot (99of9) (1234071)
- Jeuwre (1212330)
- Tm (1083729)
- Polona Upload (1068519)
- Marcel coenders (864020)
- BotMultichillT (777393)
- PencakeBot (702224)
- EUResourcesBot (654343)
- Chabe01 (545868)
- CuratorBot (486603)
- DerHexer (472754)
- US National Archives bot (456514)
- SecretName101 (449983)
- Sailko (419076)
- Bot for Freedom (398987)
- BotMultichill (375958)
- Pharos (369354)
- Rudolphous (363638)
- Matlin (352048)
- SteinsplitterBot (341164)
- Slick-o-bot (338044)
- Jc86035 (336758)
- Tyler ser Noche (328067)
- GerWsUpload (320385)
- Tilman2007 (316976)
- Orizan (315566)
- Sturm (312884)
- A1Cafel (307340)
- Hansmuller (299703)
- Summer ... hier! (296683)
- Nowakki (281723)
- Flickr upload bot (262442)
- Mindmatrix (228139)
- Geagea (225803)
- Maltaper (222073)
- MGeog2022 (211252)
- Jérémy-Günther-Heinz Jähnick (208698)
- Butko (205804)
- AliciaFagervingWMSE-bot (202834)
- Fabe56 (202124)
- Artix Kreiger 2 (193951)
- C.Suthorn (186146)
- Svema (185983)
- Юрий Д.К. (184013)
- TaurusEmerald (182277)
- GPSLeo (180885)
- Oxyman (180335)
- Cewbot (179701)
- Ooligan (174467)
- 6D (170745)
- Sandro Halank (170129)
- Vitaly Zdanevich (170037)
- Infrogmation (168919)
- Hiàn (alt) (167472)
- Jason.nlw (166386)
- Russavia (165837)
- DALIBRI (165801)
- FSII (164644)
- Josve05a (159406)
- OceanAtoll (152606)
- BMacZeroBot (149875)
- Vinayaraj (148629)
- Ies (146440)
- Zarateman (145534)
- DarwIn (144761)
- RandomUserGuy1738 (143942)
- Sporti (142974)
- DaxServer (142963)
- ComputerHotline (141106)
- Donald Trung (135005)
- Famartin (128975)
- Rotatebot (125437)
- Globetrotter19 (123594)
- JonasBR (122821)
- Christian Ferrer (122348)
- Pikiwikisrael (121581)
- Yacàwotçã (118900)
- Balabinrm (117536)
- John Robert McPherson (116140)
- CdnMCG (115411)
- Daderot (115370)
- Zairon (114934)
- GazothBot (114897)
- Luisalvaz (114506)
- SeichanGant (112499)
- LN9267 (111196)
- Dosseman (110580)
- Roland45 (110433)
- Gerd Eichmann (109590)
- Mike Peel (108160)
- Ramon FVelasquez (107173)
- Marcus Cyron (106450)
- ŠJů (104030)
- Matanya (103718)
- Faebot (103017)
- Alfvanbeem (102376)
- A. Wagner (102081)
- GeorgDerReisende (101814)
- Leaderbot (101511)
- Palickap (101030)
- Jeangagnon (100161)
- Pyb (99795)
- Smaxims (99616)
- 999real (96427)
- GFreihalter (95981)
- Stefan.lefnaer (92587)
- OSX II (92038)
- Wdwdbot (90761)
- Geo Swan (88747)
- Sebastian Wallroth (88705)
- YiFeiBot (88407)
- Thirunavukkarasye-Raveendran (87848)
- Rufus46 (87373)
- Thesupermat2 (87029)
- Tournasol7 (86256)
- 1Veertje (86059)
- Raboe001 (85942)
- Țetcu Mircea Rareș (85077)
- Luiz79 (85071)
- Jmabel (84741)
- Sintegrity (84434)
- AnRo0002 (83728)
- Paris 16 (82987)
- DcoetzeeBot (82954)
- Vanished Account Byeznhpyxeuztibuo (82952)
- BArchBot (82888)
- Psubhashish (82759)
- Kingofthedead (81843)
- Kenraiz (81594)
- Syrio (80868)
- Senapa (79504)
- V Bhavya (79074)
- RobotMichiel1972 (77986)
- LBelo (WMB) (77479)
- 19Tarrestnom65 (77222)
- Svetlov Artem (76520)
- MGA73bot2 (75584)
- Helmy oved (74779)
- P.poschadel (74684)
- RKBot (73977)
- OgreBot (73948)
- Kidfly182 (73728)
- Raymond (73082)
- Jeanhousen (72549)
- GO69 (71647)
- Copyfraud (71399)
- Engelberthumperdink (70990)
- PMRMaeyaert (69493)
- KOKUYO (69176)
- Rodrigo.Argenton (68713)
- Tokumeigakarinoaoshima (68461)
- Hassocks5489 (68267)
- FinnaUploadBot (67996)
- Ssgapu22 (67374)
- Doko (67135)
- DonabelSDSU.bot (66594)
- Gikü (66087)
- François GOGLINS (65985)
- PID-Bangladesh-UploadBot (65818)
- FrDr (65597)
- 円周率３パーセント (65349)
- Another Believer (65246)
- Juandev (65137)
- Olaf (64793)
- Petr1888 (64606)
- MasterRus21thCentury (64172)
- Sic19 (64115)
- Gangulybiswarup (63540)
- Ricardalovesmonuments (63319)
- Tschubby (63040)
- Kazimier Lachnovič (62715)
- Kaiketsu (62568)
- Holger.Ellgaard (62206)
- FotothekBot (61912)
- KRLS (61817)
- Norman.seibert (61524)
- Ultra7 (61467)
- Thesupermat (61380)
- Wilfredor (61240)
- Bybbisch94 (61149)
- Z thomas (60961)
- Meisam (60777)
- Soghomon Matevosyan (60484)
- Thomas Hummel (60203)
- Pere prlpz (60023)
- Titodutta (59847)
- Solomon203 (59828)
- Poudou99 (59521)
- N509FZ (59339)
- AndreasPraefcke (58995)
- Romaine (58589)
- Atamari (57893)
- SchiDD (57882)
- Chris Light (57191)
- MOs810 (57107)
- Pasztilla (57105)
- ETH-Bibliothek (56871)
- Ванилица (56853)
- Dguendel (56699)
- Materialscientist (56001)
- MidleadingBot (55948)
- WikiLucas00 (55855)
- Rama (55429)
- Ralf Roletschek (55384)
- Iridescent (54778)
- Puramyun31 (54741)
- Frettiebot (54554)
- Victuallers (54510)
- Txllxt TxllxT (54084)
- Чаховіч Уладзіслаў (54037)
- MBHbot (53848)
- Sakib Bot (53844)
- Pohled 111 (53713)
- Magnus Manske (53238)
- Hyppolyte de Saint-Rambert (53027)
- Brwz (52970)
- Benoît Prieur (52662)
- Renhour48 (52337)
- 12akd (51951)
- Christo (51429)
- Retired electrician (51034)
- MartinVeselka (50952)
- BhagyaMohan (50740)
- Huhu Uet (50389)
- Aagnverglaser (50388)
- Vis M (49845)
- Werner100359 (49763)
- Salicyna (49758)
- Poco a poco (49656)
- 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 (48458)
- YannBot (48430)
- 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 (46279)
- Aktron (45836)
- Hanooz (45764)
- Kwangmo (45559)
- MarcBot~commonswiki (45389)
- S. Bollmann (45279)
- Michael Barera (45188)
- INeverCry (45181)
- Chatsam (45095)
- Pigsonthewing (45019)
- KITbot (44966)
- Metilsteiner (44612)
- DerbethBot (44488)
- Joanbanjo (44434)
- Llywelyn2000 (44314)
- Smallbot (44031)
- Tdorante10 (43968)
- Manchesterunited1234 (43744)
- AnankeBot (43593)
- Streamline8988 (43376)
- Rasbak (43265)
- そらみみ (43050)
- Kotavusik (42930)
- FastilyClone (42795)
- Cephas (42692)
- Zafer (42552)
- Embedded Data Bot (42476)
- Red panda bot (42432)
- Phương Huy (42130)
- Azniv Stepanian (WMAM) (42089)
- Zala (42012)
- Alexkrakovsky (41580)
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 (341164)
- DPLA bot (302371)
- Summer ... hier! (294578)
- AskeBot (226559)
- Cewbot (173449)
- Doc James (145022)
- C.Suthorn (142445)
- Rotatebot (125431)
- Leaderbot (100472)
- Faebot (85750)
- OgreBot (73072)
- Jc86035 (54636)
- Sebastian Wallroth (47054)
- Embedded Data Bot (42444)
- Hbf878 (33310)
- FSII (32159)
- FlickreviewR 2 (30105)
- Jeuwre (27977)
- Beao (27567)
- FlickreviewR (27431)
- Ras67 (27077)
- Cropbot (26920)
- Thirunavukkarasye-Raveendran (26585)
- PantheraLeo1359531 (25363)
- Pelikana (24891)
- Slick-o-bot (24318)
- Materialscientist (23929)
- Eiabot (22875)
- YannBot (21722)
- Jochen Burghardt (21415)
- Fry1989 (20774)
- LanguageScreenshotBot (20503)
- NordNordWest (19934)
- Txllxt TxllxT (19395)
- Geograph Update Bot (18305)
- Putitonamap98 (16566)
- Hohum (15341)
- Poco a poco (15276)
- Tschubby (15003)
- Dosseman (14506)
- VortBot (14273)
- Michiel1972 (14267)
- Jacek Halicki (14253)
- BhagyaMohan (14085)
- Kazimier Lachnovič (14002)
- R8cocin8 (13018)
- Cmdrjameson (12961)
- MPF (12942)
- Kwamikagami (12934)
- Lomita (12873)
- Renamed user 995577823Xyn (12534)
- PawełMM (12466)
- Smasongarrison (12255)
- XRay (12181)
- NearEMPTiness (12161)
- XplusMapBot (12075)
- FMSky (11726)
- HWY Shield Bot (11705)
- UKBot (11150)
- Wdwdbot (11140)
- JonasBR (11118)
- Jmabel (10771)
- Krdbot (10331)
- TaurusEmerald (10304)
- WiebkeCBo (10215)
- Paris 16 (10135)
- ColaziviBot (10090)
- WikiPedant (10038)
- Meow (9865)
- Rauenstein (9854)
- Vysotsky (9747)
- Țetcu Mircea Rareș (9733)
- Salicyna (9549)
- Twofortnights (9494)
- Thomascampbell123 (9259)
- Michael Barera (9198)
- DonabelSDSU.bot (9055)
- 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 (7887)
- Minorax (7852)
- Impru20 (7697)
- ديفيد عادل وهبة خليل 2 (7528)
- Jahobr (7452)
- Ich (7271)
- MasterRus21thCentury (7029)
- BMacZeroBot (6999)
- Aquintero82 (6945)
- Finavon (6891)
- Plozessor (6811)
- Joalbertine (6692)
- Watchduck (6640)
- Jeangagnon (6604)
- Monaneko (6542)
- HermannSchachner (6512)
- Geagea (6332)
- Cobatfor (6323)
- Wilfredor (6247)
- Bzhqc (6240)
- Janwillemvanaalst (6197)
- Tbm (6162)
- Panoramio upload bot (6100)
- Adam Cuerden (6043)
- Yann (5987)
- Pataliputra! (5890)
- Chris06 (5888)
- Sailko (5810)
- Sporti (5788)
- Ducksoup (5734)
- Mediatus (5633)
- Illegitimate Barrister (5578)
- SpinnerLaserzthe2nd (5563)
- 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 (5126)
- ReneeWrites (5097)
- Roland zh (5090)
- Chabe01 (5040)
- Jarekt (4996)
- Ron Clausen (4980)
- มองโกเลีย๔๔ (4968)
- TUBS (4958)
- Edithsme (4924)
- LoKiLeCh (4901)
- Heralder (4901)
- Marcus Cyron (4872)
- Hansmuller (4864)
- Marcel coenders (4836)
- Sameboat (4747)
- Vincent Steenberg (4739)
- KAVEBEAR (4738)
- HerrAdams (4722)
- Shakko (4715)
- FunkMonk (4608)
- Ssgapu22 (4608)
- Vyacheslav Bukharov (4607)
- Jan Arkesteijn (4560)
- Fma12 (4524)
- Soerfm (4504)
- Hic et nunc (4490)
- Ebrahim (4446)
- Tomruen (4443)
- Ajpvalente (4398)
- Perhelion (4398)
- Cookie030307 (4395)
- US National Archives bot (4378)
- Kwlam259 (4323)
- Nux (4310)
- Common Good (4304)
- GerWsUpload (4272)
- Tm (4268)
- Pi.1415926535 (4266)
- JuTa (4243)
- Moumou82 (4243)
- Arbalete (4238)
- Noclador (4234)
- Jbarta (4219)
- Mike Peel (4216)
- Animalparty (4182)
- Fleets (4179)
- Titodutta (4124)
- Zinoviev (4121)
- IBryanDP (4059)
- Archaeodontosaurus (4026)
- Sangjinhwa (4018)
- Bjh21 (4006)
- Vzeebjtf (3998)
- Golbez (3963)
- Lojwe (3906)
- User-duck (3886)
- Togabi (3862)
- Furfur (3855)
- Neuchâtel Herbarium (3830)
- Shyamal (3809)
- Alonso de Mendoza (3799)
- LostplanetKD73 (3798)
- Skjoldbro (3791)
- Madboy74 (3747)
- 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 (10765915)
- GeographBot (8065554)
- Fæ (6772692)
- Gzen92Bot (6031784)
- PantheraLeo1359531 (5324332)
- Askeuhd (3053965)
- Panoramio upload bot (2410290)
- Mr.Nostalgic (2288442)
- Doc James (1625438)
- Ser Amantio di Nicolao (1610929)
- Wmr-bot (1606808)
- File Upload Bot (Magnus Manske) (1351289)
- OptimusPrimeBot (1291927)
- Judgefloro (1280036)
- Jeuwre (1184315)
- AskeBot (1083909)
- Tm (1077505)
- Polona Upload (1068518)
- Marcel coenders (859182)
- BotMultichillT (777089)
- PencakeBot (702224)
- EUResourcesBot (654343)
- Chabe01 (540780)
- CuratorBot (486603)
- DerHexer (472294)
- US National Archives bot (452136)
- SecretName101 (447455)
- Sailko (413219)
- 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 (305812)
- Hansmuller (294834)
- Jc86035 (282071)
- Nowakki (281721)
- Flickr upload bot (258986)
- Mindmatrix (227993)
- Maltaper (220144)
- Geagea (219339)
- MGeog2022 (211237)
- Jérémy-Günther-Heinz Jähnick (206931)
- Butko (203607)
- AliciaFagervingWMSE-bot (202618)
- Fabe56 (202111)
- Artix Kreiger 2 (193950)
- Svema (185876)
- Юрий Д.К. (182739)
- File Upload Bot (99of9) (182206)
- GPSLeo (180513)
- Oxyman (180317)
- Ooligan (173555)
- TaurusEmerald (171942)
- 6D (170669)
- Vitaly Zdanevich (169908)
- Sandro Halank (169669)
- Hiàn (alt) (167469)
- Infrogmation (167037)
- DALIBRI (165748)
- Jason.nlw (165150)
- Russavia (164238)
- Josve05a (158821)
- OceanAtoll (152606)
- Vinayaraj (148016)
- Ies (145878)
- Zarateman (145164)
- RandomUserGuy1738 (143170)
- DaxServer (142947)
- BMacZeroBot (142876)
- DarwIn (142110)
- ComputerHotline (140906)
- Sporti (137171)
- Donald Trung (134264)
- FSII (132485)
- Famartin (126743)
- Globetrotter19 (121825)
- Pikiwikisrael (121419)
- Christian Ferrer (118618)
- Yacàwotçã (118551)
- Balabinrm (117313)
- John Robert McPherson (115938)
- Daderot (115235)
- Zairon (114929)
- GazothBot (114897)
- Luisalvaz (114387)
- CdnMCG (113628)
- SeichanGant (112436)
- LN9267 (111099)
- JonasBR (110889)
- Roland45 (109912)
- Gerd Eichmann (109528)
- Ramon FVelasquez (107090)
- Mike Peel (103938)
- Matanya (103581)
- ŠJů (102596)
- Alfvanbeem (102311)
- GeorgDerReisende (101736)
- Marcus Cyron (101562)
- A. Wagner (100575)
- Palickap (100471)
- Smaxims (99251)
- Pyb (96565)
- Dosseman (96026)
- 999real (95797)
- GFreihalter (95589)
- Jeangagnon (93556)
- Stefan.lefnaer (92455)
- OSX II (91477)
- YiFeiBot (87590)
- Rufus46 (87279)
- Thesupermat2 (87028)
- Geo Swan (86444)
- Tournasol7 (85573)
- Raboe001 (85158)
- Luiz79 (85059)
- Sintegrity (84345)
- AnRo0002 (83401)
- BArchBot (82888)
- 1Veertje (82854)
- Vanished Account Byeznhpyxeuztibuo (82651)
- DcoetzeeBot (82090)
- Kenraiz (81485)
- Syrio (80634)
- Wdwdbot (79621)
- Psubhashish (79475)
- Kingofthedead (79245)
- Senapa (78684)
- RobotMichiel1972 (77967)
- V Bhavya (77611)
- LBelo (WMB) (77332)
- 19Tarrestnom65 (77205)
- Țetcu Mircea Rareș (75344)
- MGA73bot2 (75112)
- Svetlov Artem (74943)
- Helmy oved (74070)
- P.poschadel (73982)
- Jmabel (73842)
- RKBot (73830)
- Kidfly182 (73728)
- Paris 16 (72828)
- Jeanhousen (72458)
- GO69 (71420)
- Copyfraud (71399)
- Engelberthumperdink (70857)
- Raymond (70349)
- Rodrigo.Argenton (68371)
- Hassocks5489 (68108)
- KOKUYO (68047)
- Tokumeigakarinoaoshima (67611)
- Doko (66220)
- PMRMaeyaert (66018)
- François GOGLINS (65839)
- PID-Bangladesh-UploadBot (65818)
- Gikü (65785)
- FrDr (65595)
- 円周率３パーセント (65327)
- FinnaUploadBot (65249)
- Another Believer (65096)
- Juandev (65047)
- Petr1888 (64540)
- Sic19 (64100)
- Olaf (63599)
- Gangulybiswarup (63531)
- Ssgapu22 (62766)
- FotothekBot (61912)
- KRLS (61672)
- Kaiketsu (61514)
- Thirunavukkarasye-Raveendran (61263)
- Bybbisch94 (61114)
- Ultra7 (61045)
- Thesupermat (61036)
- Norman.seibert (60929)
- Z thomas (60856)
- Meisam (60713)
- Ricardalovesmonuments (60502)
- Pere prlpz (59923)
- Soghomon Matevosyan (59917)
- Thomas Hummel (59855)
- N509FZ (59087)
- Romaine (58459)
- Poudou99 (58433)
- Solomon203 (58302)
- DonabelSDSU.bot (57539)
- Atamari (57218)
- MOs810 (57099)
- Pasztilla (57064)
- MasterRus21thCentury (57033)
- AndreasPraefcke (56902)
- ETH-Bibliothek (56845)
- Ванилица (56809)
- Chris Light (56803)
- SchiDD (56082)
- MidleadingBot (55912)