Commons:Database reports/Upload log stats
All upload logs
Top 300 users with the most upload log entries. Data as of 19:30, 18 June 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 (11306423)
- GeographBot (8087727)
- Fæ (7243689)
- Gzen92Bot (6099693)
- PantheraLeo1359531 (5617913)
- Askeuhd (3054141)
- Mr.Nostalgic (2718570)
- Panoramio upload bot (2416390)
- Doc James (1817807)
- Ser Amantio di Nicolao (1611033)
- Wmr-bot (1607708)
- File Upload Bot (Magnus Manske) (1359581)
- OptimusPrimeBot (1316917)
- AskeBot (1310468)
- Judgefloro (1280506)
- File Upload Bot (99of9) (1234071)
- Jeuwre (1227812)
- Tm (1084281)
- Polona Upload (1068519)
- Marcel coenders (867801)
- BotMultichillT (777393)
- PencakeBot (702224)
- EUResourcesBot (654343)
- Chabe01 (549852)
- CuratorBot (493396)
- DerHexer (472754)
- US National Archives bot (456514)
- SecretName101 (449987)
- Sailko (422288)
- Bot for Freedom (398987)
- BotMultichill (375958)
- Pharos (369366)
- Rudolphous (363668)
- Matlin (352048)
- SteinsplitterBot (342570)
- Slick-o-bot (338044)
- Jc86035 (336758)
- Tyler ser Noche (328067)
- GerWsUpload (320385)
- Tilman2007 (316976)
- Orizan (315566)
- Sturm (313005)
- A1Cafel (307631)
- Hansmuller (299703)
- Summer ... hier! (296683)
- Nowakki (281723)
- Flickr upload bot (262442)
- Mindmatrix (228140)
- Geagea (225869)
- Maltaper (223292)
- MGeog2022 (223140)
- Jérémy-Günther-Heinz Jähnick (208701)
- Butko (205831)
- AliciaFagervingWMSE-bot (202834)
- Fabe56 (202132)
- Artix Kreiger 2 (193951)
- 6D (191841)
- Svema (189280)
- C.Suthorn (186152)
- Юрий Д.К. (185127)
- GPSLeo (183432)
- Oxyman (183287)
- TaurusEmerald (182654)
- Cewbot (181792)
- Ooligan (176194)
- Sandro Halank (171186)
- Infrogmation (170489)
- Vitaly Zdanevich (170040)
- Hiàn (alt) (167472)
- Jason.nlw (166386)
- Russavia (165837)
- DALIBRI (165801)
- FSII (164644)
- Josve05a (159406)
- Vinayaraj (153473)
- OceanAtoll (152606)
- BMacZeroBot (149927)
- Ies (146440)
- Zarateman (146189)
- DarwIn (144897)
- RandomUserGuy1738 (144717)
- Sporti (143018)
- DaxServer (142967)
- ComputerHotline (141673)
- Donald Trung (135005)
- Famartin (129452)
- Rotatebot (125437)
- Globetrotter19 (124178)
- JonasBR (123590)
- Christian Ferrer (122988)
- Pikiwikisrael (122015)
- Yacàwotçã (118993)
- Balabinrm (117536)
- John Robert McPherson (116582)
- Daderot (115883)
- CdnMCG (115411)
- LN9267 (115248)
- Luisalvaz (115134)
- Zairon (114934)
- GazothBot (114897)
- SeichanGant (112499)
- Dosseman (112427)
- Gerd Eichmann (111518)
- Roland45 (110433)
- Mike Peel (108205)
- Ramon FVelasquez (107173)
- Marcus Cyron (106453)
- Leaderbot (105613)
- ŠJů (104032)
- Matanya (103718)
- GeorgDerReisende (103050)
- Faebot (103017)
- Alfvanbeem (102671)
- A. Wagner (102095)
- Palickap (102000)
- Jeangagnon (101314)
- Smaxims (100993)
- Pyb (99796)
- 999real (96632)
- GFreihalter (96569)
- Stefan.lefnaer (92587)
- OSX II (92038)
- Wdwdbot (90761)
- Sebastian Wallroth (89053)
- Geo Swan (88774)
- YiFeiBot (88407)
- Rufus46 (88018)
- Thirunavukkarasye-Raveendran (87993)
- 1Veertje (87728)
- Thesupermat2 (87029)
- Tournasol7 (86589)
- Raboe001 (86560)
- Țetcu Mircea Rareș (85359)
- Luiz79 (85107)
- Jmabel (84850)
- Sintegrity (84567)
- AnRo0002 (83852)
- Paris 16 (82987)
- DcoetzeeBot (82954)
- Vanished Account Byeznhpyxeuztibuo (82952)
- BArchBot (82888)
- Psubhashish (82764)
- Kenraiz (82036)
- Syrio (82017)
- Kingofthedead (82007)
- Senapa (79504)
- V Bhavya (79074)
- Svetlov Artem (78746)
- RobotMichiel1972 (77986)
- 19Tarrestnom65 (77895)
- LBelo (WMB) (77479)
- MGA73bot2 (75584)
- Helmy oved (74779)
- P.poschadel (74684)
- RKBot (73977)
- OgreBot (73956)
- Kidfly182 (73797)
- Raymond (73483)
- Jeanhousen (72549)
- GO69 (71647)
- Copyfraud (71399)
- Engelberthumperdink (70990)
- PMRMaeyaert (69691)
- KOKUYO (69176)
- Rodrigo.Argenton (68714)
- Hassocks5489 (68603)
- Tokumeigakarinoaoshima (68562)
- FinnaUploadBot (68299)
- Gikü (67893)
- MasterRus21thCentury (67777)
- Ssgapu22 (67374)
- Doko (67296)
- DonabelSDSU.bot (66594)
- PID-Bangladesh-UploadBot (66333)
- François GOGLINS (65985)
- 円周率３パーセント (65827)
- FrDr (65826)
- Another Believer (65346)
- Juandev (65139)
- Olaf (64793)
- Petr1888 (64608)
- Sic19 (64115)
- Ricardalovesmonuments (63555)
- Gangulybiswarup (63540)
- Tschubby (63125)
- Kazimier Lachnovič (62715)
- Kaiketsu (62568)
- Holger.Ellgaard (62206)
- FotothekBot (61912)
- KRLS (61817)
- Bybbisch94 (61592)
- Norman.seibert (61524)
- Ultra7 (61467)
- Thesupermat (61380)
- Wilfredor (61276)
- Z thomas (61270)
- Pere prlpz (60972)
- Meisam (60777)
- Thomas Hummel (60640)
- Soghomon Matevosyan (60484)
- Solomon203 (60143)
- Titodutta (59847)
- N509FZ (59679)
- Poudou99 (59623)
- AndreasPraefcke (58995)
- Romaine (58617)
- SchiDD (58382)
- Atamari (57893)
- Pasztilla (57406)
- Ванилица (57375)
- Chris Light (57272)
- MOs810 (57214)
- ETH-Bibliothek (56881)
- Dguendel (56755)
- Materialscientist (56005)
- MidleadingBot (55948)
- WikiLucas00 (55855)
- Rama (55429)
- Ralf Roletschek (55385)
- Victuallers (54788)
- Iridescent (54778)
- Puramyun31 (54741)
- Pohled 111 (54578)
- Frettiebot (54554)
- EN-Jungwon (54194)
- Чаховіч Уладзіслаў (54087)
- Txllxt TxllxT (54084)
- Sakib Bot (54073)
- MBHbot (53848)
- Magnus Manske (53240)
- Hyppolyte de Saint-Rambert (53027)
- Brwz (52970)
- YannBot (52947)
- Benoît Prieur (52662)
- Retired electrician (52554)
- Renhour48 (52337)
- 12akd (51966)
- Poco a poco (51548)
- Christo (51429)
- MartinVeselka (50969)
- BhagyaMohan (50740)
- Aagnverglaser (50458)
- Huhu Uet (50389)
- Vis M (49847)
- Werner100359 (49846)
- Salicyna (49758)
- Gone Postal (49588)
- Lepticed7 (49544)
- Swiss National Library (49460)
- Killarnee (49290)
- Wmilbot (49092)
- Ekirahardian (48916)
- Damian B Oh (48886)
- Bruno-ban (48754)
- Enric (48742)
- MCastro (WMB) (48632)
- HWY Shield Bot (48204)
- Rakoon (48193)
- Ebrahim (48081)
- Discasto (48034)
- Giftzwerg 88 (47892)
- Nevit (47892)
- LSHuploadBot (47553)
- Stepro (47235)
- Michiel1972 (47076)
- Indonesiagood (46784)
- Minerva97 (46415)
- Manchesterunited1234 (46314)
- Neuchâtel Herbarium (46305)
- Nicolas Rück (WMDE) (46289)
- Aktron (45894)
- Hanooz (45868)
- Michael Barera (45580)
- Kwangmo (45559)
- MarcBot~commonswiki (45389)
- S. Bollmann (45279)
- INeverCry (45181)
- Chatsam (45137)
- Pigsonthewing (45051)
- KITbot (44966)
- Metilsteiner (44612)
- DerbethBot (44488)
- Joanbanjo (44479)
- Llywelyn2000 (44320)
- Smallbot (44031)
- Tdorante10 (43968)
- AnankeBot (43593)
- Streamline8988 (43376)
- Rasbak (43287)
- そらみみ (43050)
- Kotavusik (42930)
- Cephas (42895)
- FastilyClone (42795)
- Red panda bot (42661)
- Zafer (42593)
- Embedded Data Bot (42476)
- Acabashi (42396)
- Phương Huy (42130)
- Azniv Stepanian (WMAM) (42089)
- Zala (42012)
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æ (417135)
- SteinsplitterBot (342570)
- DPLA bot (318587)
- Summer ... hier! (294578)
- AskeBot (226559)
- Cewbot (175467)
- Doc James (173304)
- C.Suthorn (142445)
- Rotatebot (125431)
- Leaderbot (104573)
- Faebot (85750)
- OgreBot (73079)
- Jc86035 (54636)
- Sebastian Wallroth (47344)
- Embedded Data Bot (42444)
- Hbf878 (33310)
- FSII (32159)
- FlickreviewR 2 (30117)
- Jeuwre (28050)
- Beao (28049)
- FlickreviewR (27431)
- Ras67 (27087)
- Cropbot (26920)
- Thirunavukkarasye-Raveendran (26585)
- YannBot (26239)
- PantheraLeo1359531 (25798)
- Pelikana (25218)
- Slick-o-bot (24318)
- Materialscientist (23929)
- Eiabot (22875)
- Jochen Burghardt (21415)
- Fry1989 (20802)
- LanguageScreenshotBot (20503)
- NordNordWest (19937)
- Txllxt TxllxT (19395)
- Geograph Update Bot (18305)
- Putitonamap98 (16598)
- Hohum (15371)
- Poco a poco (15354)
- Tschubby (15068)
- Dosseman (14513)
- Jacek Halicki (14331)
- VortBot (14273)
- Michiel1972 (14267)
- Dexbot (14225)
- BhagyaMohan (14085)
- Kazimier Lachnovič (14002)
- MPF (13040)
- R8cocin8 (13033)
- Cmdrjameson (12961)
- Kwamikagami (12959)
- Lomita (12873)
- XRay (12568)
- Renamed user 995577823Xyn (12534)
- PawełMM (12466)
- NearEMPTiness (12274)
- Smasongarrison (12255)
- XplusMapBot (12075)
- FMSky (11726)
- HWY Shield Bot (11705)
- JonasBR (11479)
- UKBot (11266)
- Wdwdbot (11140)
- Jmabel (10821)
- Krdbot (10343)
- TaurusEmerald (10335)
- WiebkeCBo (10215)
- Paris 16 (10135)
- ColaziviBot (10090)
- WikiPedant (10049)
- Meow (9882)
- Rauenstein (9854)
- Vysotsky (9764)
- Țetcu Mircea Rareș (9733)
- Thomascampbell123 (9599)
- Salicyna (9549)
- Twofortnights (9494)
- Michael Barera (9373)
- DonabelSDSU.bot (9055)
- McZusatz (8761)
- Remitamine (8748)
- CoronaBot (8658)
- Fredddie (8636)
- Wvdp (8611)
- Irypixel (8505)
- Ekirahardian (8334)
- File Upload Bot (Magnus Manske) (8291)
- Milenioscuro (8165)
- Holger.Ellgaard (8069)
- Supportstorm (7918)
- Bruno-ban (7902)
- Minorax (7889)
- MasterRus21thCentury (7843)
- Impru20 (7728)
- ديفيد عادل وهبة خليل 2 (7528)
- Ich (7523)
- Jahobr (7452)
- BMacZeroBot (6999)
- Aquintero82 (6976)
- Finavon (6891)
- Plozessor (6816)
- Joalbertine (6743)
- Watchduck (6641)
- Jeangagnon (6604)
- Monaneko (6542)
- HermannSchachner (6512)
- Geagea (6345)
- Cobatfor (6327)
- Wilfredor (6266)
- Bzhqc (6242)
- Janwillemvanaalst (6197)
- Tbm (6162)
- Panoramio upload bot (6100)
- Adam Cuerden (6043)
- Yann (5990)
- Pataliputra! (5976)
- Chris06 (5934)
- Sailko (5813)
- Sporti (5788)
- Ducksoup (5734)
- Mediatus (5633)
- Illegitimate Barrister (5608)
- SpinnerLaserzthe2nd (5574)
- AnonMoos (5463)
- M2545 (5382)
- Acabashi (5380)
- Enyavar (5335)
- Subbass1 (5327)
- OSX (5311)
- 1970gemini (5273)
- Quibik (5254)
- Tilman2007 (5237)
- Hans G. Oberlack (5203)
- Roland zh (5192)
- Trzęsacz (5149)
- Swiss Federal Archives (5131)
- ReneeWrites (5097)
- Chabe01 (5053)
- Jarekt (5023)
- มองโกเลีย๔๔ (4990)
- Ron Clausen (4983)
- TUBS (4958)
- Edithsme (4924)
- LoKiLeCh (4901)
- Heralder (4901)
- Marcus Cyron (4875)
- Hansmuller (4864)
- Marcel coenders (4836)
- Shakko (4766)
- Vincent Steenberg (4760)
- Sameboat (4748)
- KAVEBEAR (4738)
- HerrAdams (4722)
- FunkMonk (4612)
- Vyacheslav Bukharov (4609)
- Ssgapu22 (4608)
- Jan Arkesteijn (4560)
- Fma12 (4543)
- Soerfm (4504)
- Hic et nunc (4490)
- Ebrahim (4446)
- Tomruen (4443)
- Ajpvalente (4425)
- Perhelion (4398)
- Cookie030307 (4395)
- US National Archives bot (4378)
- Kwlam259 (4323)
- Nux (4312)
- Common Good (4304)
- GerWsUpload (4272)
- Pi.1415926535 (4272)
- Tm (4268)
- Noclador (4259)
- Mike Peel (4251)
- Moumou82 (4247)
- JuTa (4243)
- Arbalete (4238)
- Jbarta (4219)
- Animalparty (4219)
- Fleets (4182)
- Titodutta (4124)
- Zinoviev (4121)
- IBryanDP (4065)
- Archaeodontosaurus (4027)
- Sangjinhwa (4018)
- Bjh21 (4006)
- Vzeebjtf (3998)
- Lojwe (3993)
- Golbez (3963)
- User-duck (3886)
- Togabi (3862)
- Furfur (3857)
- Neuchâtel Herbarium (3830)
- Shyamal (3818)
- LostplanetKD73 (3811)
- Alonso de Mendoza (3799)
- Skjoldbro (3799)
- Manchesterunited1234 (3787)
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 (10987836)
- GeographBot (8084702)
- Fæ (6826466)
- Gzen92Bot (6099689)
- PantheraLeo1359531 (5591847)
- Askeuhd (3053965)
- Panoramio upload bot (2410290)
- Mr.Nostalgic (2288442)
- Doc James (1644490)
- Ser Amantio di Nicolao (1610929)
- Wmr-bot (1606808)
- File Upload Bot (Magnus Manske) (1351289)
- OptimusPrimeBot (1313739)
- Judgefloro (1280036)
- Jeuwre (1199724)
- AskeBot (1083909)
- Tm (1078056)
- Polona Upload (1068518)
- Marcel coenders (862963)
- BotMultichillT (777089)
- PencakeBot (702224)
- EUResourcesBot (654343)
- Chabe01 (544751)
- CuratorBot (493396)
- DerHexer (472294)
- US National Archives bot (452136)
- SecretName101 (447459)
- Sailko (416427)
- Bot for Freedom (398975)
- BotMultichill (375660)
- Pharos (367336)
- Rudolphous (363633)
- Matlin (351605)
- Tyler ser Noche (328064)
- GerWsUpload (316113)
- Orizan (315566)
- Slick-o-bot (313726)
- Sturm (312969)
- Tilman2007 (311737)
- A1Cafel (306102)
- Hansmuller (294834)
- Jc86035 (282071)
- Nowakki (281721)
- Flickr upload bot (258986)
- Mindmatrix (227994)
- MGeog2022 (223125)
- Maltaper (221347)
- Geagea (219389)
- Jérémy-Günther-Heinz Jähnick (206934)
- Butko (203634)
- AliciaFagervingWMSE-bot (202618)
- Fabe56 (202119)
- Artix Kreiger 2 (193950)
- 6D (191764)
- Svema (189173)
- Юрий Д.К. (183817)
- Oxyman (183269)
- GPSLeo (183060)
- File Upload Bot (99of9) (182206)
- Ooligan (175274)
- TaurusEmerald (172288)
- Sandro Halank (170726)
- Vitaly Zdanevich (169911)
- Infrogmation (168602)
- Hiàn (alt) (167469)
- DALIBRI (165748)
- Jason.nlw (165150)
- Russavia (164238)
- Josve05a (158821)
- Vinayaraj (152860)
- OceanAtoll (152606)
- Ies (145878)
- Zarateman (145819)
- RandomUserGuy1738 (143863)
- DaxServer (142951)
- BMacZeroBot (142928)
- DarwIn (142241)
- ComputerHotline (141472)
- Sporti (137215)
- Donald Trung (134264)
- FSII (132485)
- Famartin (127220)
- Globetrotter19 (122409)
- Pikiwikisrael (121852)
- Christian Ferrer (119212)
- Yacàwotçã (118643)
- Balabinrm (117313)
- John Robert McPherson (116380)
- Daderot (115748)
- LN9267 (115141)
- Luisalvaz (115015)
- Zairon (114929)
- GazothBot (114897)
- CdnMCG (113628)
- SeichanGant (112436)
- Gerd Eichmann (111456)
- JonasBR (111294)
- Roland45 (109912)
- Ramon FVelasquez (107090)
- Mike Peel (103948)
- Matanya (103581)
- GeorgDerReisende (102972)
- Alfvanbeem (102606)
- ŠJů (102598)
- Marcus Cyron (101562)
- Palickap (101435)
- A. Wagner (100576)
- Smaxims (100570)
- Dosseman (97866)
- Pyb (96566)
- GFreihalter (96177)
- 999real (95981)
- Jeangagnon (94709)
- Stefan.lefnaer (92455)
- OSX II (91477)
- Rufus46 (87924)
- YiFeiBot (87590)
- Thesupermat2 (87028)
- Geo Swan (86470)
- Tournasol7 (85901)
- Raboe001 (85776)
- Luiz79 (85095)
- 1Veertje (84508)
- Sintegrity (84478)
- AnRo0002 (83525)
- BArchBot (82888)
- Vanished Account Byeznhpyxeuztibuo (82651)
- DcoetzeeBot (82090)
- Kenraiz (81927)
- Syrio (81775)
- Wdwdbot (79621)
- Psubhashish (79479)
- Kingofthedead (79408)
- Senapa (78684)
- RobotMichiel1972 (77967)
- 19Tarrestnom65 (77878)
- V Bhavya (77611)
- LBelo (WMB) (77332)
- Svetlov Artem (77127)
- Țetcu Mircea Rareș (75626)
- MGA73bot2 (75112)
- Helmy oved (74070)
- P.poschadel (73982)
- Jmabel (73899)
- RKBot (73830)
- Kidfly182 (73797)
- Paris 16 (72828)
- Jeanhousen (72458)
- GO69 (71420)
- Copyfraud (71399)
- Engelberthumperdink (70857)
- Raymond (70748)
- Hassocks5489 (68444)
- Rodrigo.Argenton (68372)
- KOKUYO (68047)
- Tokumeigakarinoaoshima (67712)
- Gikü (67591)
- Doko (66381)
- PID-Bangladesh-UploadBot (66333)
- PMRMaeyaert (66216)
- François GOGLINS (65839)
- FrDr (65824)
- 円周率３パーセント (65805)
- FinnaUploadBot (65552)
- Another Believer (65195)
- Juandev (65049)
- Petr1888 (64541)
- Sic19 (64100)
- Olaf (63599)
- Gangulybiswarup (63531)
- Ssgapu22 (62766)
- FotothekBot (61912)
- KRLS (61672)
- Bybbisch94 (61557)
- Kaiketsu (61514)
- Thirunavukkarasye-Raveendran (61408)
- Z thomas (61165)
- Ultra7 (61045)
- Thesupermat (61036)
- Norman.seibert (60929)
- Pere prlpz (60872)
- Ricardalovesmonuments (60737)
- Meisam (60713)
- Thomas Hummel (60290)
- Soghomon Matevosyan (59917)
- MasterRus21thCentury (59821)
- N509FZ (59427)
- Solomon203 (58571)
- Poudou99 (58535)
- Romaine (58487)
- DonabelSDSU.bot (57539)
- Pasztilla (57365)
- Ванилица (57329)
- Atamari (57218)
- MOs810 (57206)
- AndreasPraefcke (56902)
- Chris Light (56884)
- ETH-Bibliothek (56855)
- SchiDD (56581)
- MidleadingBot (55912)