Commons:Database reports/Upload log stats
Jump to navigation
Jump to search
Contents
All upload logs[edit]
Top 300 users with the most upload log entries. Data as of 06:28, 8 September 2018 (UTC). See also mw:Manual:Log actions
| sql used |
|---|
SELECT user.user_name AS username,
COUNT(logging.log_user) AS count
FROM user
INNER JOIN logging
ON logging.log_user = user.user_id
WHERE logging.log_type = "upload"
GROUP BY logging.log_user
ORDER BY COUNT(logging.log_user) DESC
LIMIT 300;
|
- Fæ (4693043)
- Panoramio upload bot (2416390)
- GeographBot (1687970)
- File Upload Bot (Magnus Manske) (1359581)
- File Upload Bot (99of9) (1077236)
- Judgefloro (891708)
- BotMultichillT (670351)
- Marcel coenders (457507)
- Tm (445612)
- Ser Amantio di Nicolao (403103)
- Mr.Nostalgic (371124)
- Pharos (366833)
- Slick-o-bot (338044)
- GerWsUpload (320385)
- Hansmuller (291110)
- Tyler ser Noche (267453)
- Flickr upload bot (262442)
- Sailko (229686)
- US National Archives bot (198836)
- Artix Kreiger 2 (193951)
- SteinsplitterBot (183140)
- AliciaFagervingWMSE-bot (181274)
- Hiàn (alt) (167447)
- Russavia (165836)
- FSII (164644)
- Rudolphous (163247)
- Tilman2007 (158683)
- OceanAtoll (152606)
- Butko (140416)
- SecretName101 (139085)
- Josve05a (135695)
- Rotatebot (125437)
- Ies (120038)
- Ramon FVelasquez (107173)
- Jc86035 (101664)
- GazothBot (98822)
- Sporti (95527)
- OSX II (92038)
- YiFeiBot (88407)
- A. Wagner (87476)
- Alfvanbeem (87118)
- BotMultichill (86132)
- Jérémy-Günther-Heinz Jähnick (83387)
- DcoetzeeBot (82954)
- BArchBot (82888)
- Jasonanaggie (82251)
- Sturm (81260)
- ŠJů (79807)
- Daderot (79619)
- RobotMichiel1972 (77986)
- Zarateman (75857)
- Balabinrm (73835)
- Jeangagnon (69824)
- MGA73bot2 (69197)
- Chabe01 (68611)
- OgreBot (67957)
- Matanya (67079)
- DonabelSDSU.bot (66594)
- Wdwdbot (66379)
- RKBot (66085)
- AnRo0002 (65406)
- Paris 16 (64966)
- P.poschadel (64769)
- Geagea (64405)
- ComputerHotline (61939)
- FotothekBot (61912)
- Worldenc (61553)
- Ultra7 (61467)
- MB298 (60620)
- Raboe001 (59927)
- Helmy oved (59534)
- AndreasPraefcke (58945)
- Gangulybiswarup (57864)
- DerHexer (56183)
- Ralf Roletschek (54440)
- Jeuwre (53629)
- Pyb (53495)
- Infrogmation (52828)
- Jmabel (52538)
- Atamari (52344)
- Senapa (52312)
- Țetcu Mircea Rareș (52110)
- Meisam (51903)
- ETH-Bibliothek (51827)
- Mindmatrix (51626)
- DALIBRI (48254)
- Nevit (47889)
- Thesupermat2 (47612)
- LSHuploadBot (47553)
- The Photographer (47318)
- Thesupermat (47113)
- Michiel1972 (47071)
- GFreihalter (46781)
- Zairon (46676)
- Neuchâtel Herbarium (46305)
- Nicolas Rück (WMDE) (46155)
- Materialscientist (46111)
- Kwangmo (45558)
- MarcBot~commonswiki (45389)
- INeverCry (45179)
- KITbot (44966)
- MidleadingBot (44694)
- DerbethBot (44488)
- Jeanhousen (44251)
- Metilsteiner (44076)
- Smallbot (44031)
- DarwIn (43273)
- JonasBR (42930)
- François GOGLINS (42825)
- FastilyClone (42795)
- KOKUYO (42772)
- Holger.Ellgaard (41179)
- Famartin (40728)
- Rufus46 (40418)
- David Stang (40401)
- Huhu Uet (40282)
- Puramyun31 (39657)
- Amada44 (39611)
- Pikiwikisrael (39138)
- Petr1888 (38975)
- Kobac (38809)
- Globetrotter19 (38075)
- Faebot (37960)
- Rama (37615)
- Nasjonalbiblioteket-bot (37030)
- Спасимир (36693)
- そらみみ (36424)
- SieBot (36330)
- Rodrigo.Argenton (36314)
- Geo Swan (36243)
- Deror avi (36032)
- Lionel Allorge (35929)
- Joanbanjo (35833)
- Open Access Media Importer Bot (35784)
- Vinayaraj (35324)
- Joergens.mi (35109)
- Soghomon Matevosyan (35040)
- Discasto (34764)
- Doko (34762)
- Palickap (34747)
- AkBot (34470)
- Embedded Data Bot (33994)
- File Upload Bot (Kaldari) (33848)
- Tschubby (33765)
- YarluFileBot (33417)
- Cropbot (32787)
- Ras67 (32772)
- Kaiketsu (32766)
- TUBS (32582)
- File Upload Bot (AntWeb) (32489)
- FlickreviewR (32152)
- Marcus Cyron (32136)
- Shakko (31966)
- Mike Peel (31965)
- Immanuel Giel (31562)
- PMRMaeyaert (31287)
- Bin im Garten (31103)
- Wmilbot (31092)
- GO69 (31047)
- Unauthorized Bot (31007)
- Brück & Sohn Kunstverlag Meißen (30285)
- Dcoetzee (30234)
- Kazimier Lachnovič (30173)
- Jason.nlw (30115)
- Cherubino (29864)
- MOs810 (29674)
- KTC (29543)
- Juandev (29293)
- Havang(nl) (29191)
- Dr. Bernd Gross (29163)
- Sreejithk2000 (29150)
- Elisfkc (28884)
- Noaabot (28820)
- Chatsam (28649)
- Père Igor (28398)
- Aktron (28346)
- Cobatfor (28102)
- Bjoertvedt (27986)
- Roland zh (27879)
- Poco a poco (27796)
- Karl Gruber (27660)
- AlejandroLinaresGarcia (27622)
- Pere prlpz (27509)
- Raso mk (27352)
- Fry1989 (27104)
- Zblagojevic (26945)
- Garitan (26915)
- Mti (26819)
- Werner100359 (26666)
- MiguelHermoso (26637)
- Slowking4 (26568)
- Ebastia1 (26524)
- Raymond (26511)
- SchiDD (26419)
- BMacZeroBot (26340)
- Discanto (26336)
- 663highland (26227)
- Mattinbgn (26185)
- Victorgrigas (25983)
- GifTagger (25882)
- WeatherBot~commonswiki (25485)
- Ralph Hammann (25378)
- Tokfo (25339)
- Fastily (25069)
- G.dallorto (25066)
- Piotrus (24873)
- Tokumeigakarinoaoshima (24856)
- Svema (24671)
- Ebyabe (24572)
- We hope (24189)
- Enfo (24184)
- Fundación Joaquín Díaz (24140)
- Xenophon (24135)
- Benoît Prieur (24127)
- Ben Skála (23905)
- BasBot (23899)
- Ji-Elle (23831)
- FSVI (23679)
- 9xl (23549)
- FlickreviewR 2 (23393)
- Zhangzhugang (23146)
- BrokenSphere (23000)
- William Ellison (22988)
- Donald Trung (22943)
- Rasbak (22901)
- SLQbot (22839)
- Davey2010 (22808)
- 1Veertje (22771)
- FA2010 (22719)
- Ebrahim (22471)
- Rept0n1x (22469)
- Poudou99 (22203)
- Davidgrosclaude (22136)
- Freddy2001 (21990)
- LoKiLeCh (21806)
- Pohled 111 (21738)
- Jacek Halicki (21588)
- Kenraiz (21553)
- Olaf Kosinsky (21522)
- Jacopo Werther (21510)
- Nyttend (21502)
- Tomruen (21379)
- Oltau (21268)
- OrdnanceSurveyBot (21264)
- Pit1233 (21183)
- Ванилица (21046)
- Hagar66 (21005)
- Vmenkov (20980)
- Hiku2 (20915)
- Paulis (20911)
- DoxTxob (20893)
- Massimilianogalardi (20764)
- Mjrmtg (20535)
- Quahadi (20506)
- LanguageScreenshotBot (20493)
- Johann Jaritz (20371)
- Bruno-ban (20355)
- Sebastian Wallroth (20311)
- 19Tarrestnom65 (20265)
- Benzoyl (20206)
- OSX (20148)
- Reinhardhauke (20007)
- Howcheng (19938)
- Txllxt TxllxT (19932)
- Marianne Casamance (19827)
- BetacommandBot (19808)
- G.Lanting (19763)
- Gryffindor (19580)
- Adam63 (19558)
- NordNordWest (19475)
- Ankry (19438)
- Solomon203 (19436)
- Dezidor (19340)
- Ineuw (19275)
- McZusatz (19232)
- Bubel (19036)
- XRay (18986)
- Andrebot (18984)
- Michael Barera (18901)
- JarektUploadBot (18901)
- Red Rooster (18725)
- Federico Leva (BEIC) (18713)
- Ragnar1904 (18595)
- Chris Light (18555)
- Another Believer (18552)
- Kleon3 (18518)
- Boing-boing (18444)
- MechQuester (18351)
- Maliepa (18262)
- ЯдвигаВереск (18124)
- Tournasol7 (18056)
- JoJan (18046)
- Mattes (18046)
- Ewaldgabardi (17996)
- Ammodramus (17989)
- Dguendel (17939)
- Stunteltje (17931)
- Bull-Doser (17895)
- Z thomas (17860)
- Tæ (17805)
Overwriting[edit]
Top 200 users with the most "overwrite" entries.
| sql used |
|---|
SELECT user.user_name AS username,
COUNT(logging.log_user) AS count
FROM user
INNER JOIN logging
ON logging.log_user = user.user_id
WHERE logging.log_type = "upload"
AND log_action = "overwrite"
GROUP BY logging.log_user
ORDER BY COUNT(logging.log_user) DESC
LIMIT 200;
|
- File Upload Bot (99of9) (897363)
- Fæ (241776)
- SteinsplitterBot (183140)
- Rotatebot (125431)
- OgreBot (67288)
- Embedded Data Bot (33968)
- FSII (32159)
- FlickreviewR (27431)
- Cropbot (26920)
- Slick-o-bot (24318)
- Ras67 (23473)
- FlickreviewR 2 (23393)
- Faebot (22303)
- Jc86035 (19793)
- Materialscientist (19207)
- LanguageScreenshotBot (17586)
- Fry1989 (15044)
- Worldenc (14838)
- VortBot (14273)
- Michiel1972 (14267)
- Cmdrjameson (12961)
- We hope (12533)
- NordNordWest (12139)
- Lomita (11783)
- Geograph Update Bot (10286)
- Hagar66 (10214)
- Wdwdbot (9761)
- Țetcu Mircea Rareș (9689)
- Hohum (9280)
- Tschubby (9205)
- DonabelSDSU.bot (9055)
- Jacek Halicki (9040)
- McZusatz (8761)
- File Upload Bot (Magnus Manske) (8291)
- Poco a poco (7866)
- Krdbot (7475)
- Kazimier Lachnovič (7114)
- Shadowxfox (7034)
- Twofortnights (6855)
- XRay (6685)
- Sebastian Wallroth (6461)
- Panoramio upload bot (6100)
- Finavon (6078)
- ديفيد عادل وهبة خليل 2 (6003)
- Ducksoup (5734)
- Paris 16 (5723)
- Jeangagnon (5710)
- AnonMoos (5395)
- Fredddie (5326)
- OSX (5311)
- Mediatus (5250)
- Quibik (5229)
- Monaneko (5177)
- Swiss Federal Archives (5131)
- Bruno-ban (5103)
- HWY Shield Bot (5061)
- LoKiLeCh (4887)
- TUBS (4855)
- Holger.Ellgaard (4842)
- Hansmuller (4754)
- Janwillemvanaalst (4567)
- Jan Arkesteijn (4541)
- Marcel coenders (4496)
- Acabashi (4495)
- Hic et nunc (4490)
- Ebrahim (4402)
- Cobatfor (4391)
- Sameboat (4346)
- Kwlam259 (4323)
- Common Good (4304)
- KAVEBEAR (4276)
- GerWsUpload (4272)
- Perhelion (4258)
- Soerfm (4245)
- Jbarta (4219)
- MPF (4206)
- Shakko (4124)
- FSIV (4124)
- Meow (4039)
- HerrAdams (4010)
- Heralder (3859)
- Tomruen (3834)
- Neuchâtel Herbarium (3830)
- Geagea (3728)
- Marcus Cyron (3702)
- Impru20 (3701)
- Supportstorm (3694)
- Salicyna (3611)
- Madboy74 (3596)
- Rauenstein (3580)
- Andy king50 (3544)
- Vzeebjtf (3492)
- Flickr upload bot (3456)
- Yann (3387)
- Alonso de Mendoza (3315)
- UKBot (3283)
- Sporti (3258)
- Illegitimate Barrister (3251)
- Keith Edkins (3248)
- FunkMonk (3244)
- PawełMM (3208)
- Trzęsacz (3192)
- Martin H. (3177)
- Tm (3135)
- DieBucheBot (3093)
- Gustavo neto (3026)
- Denniss (3004)
- Citypeek (2968)
- Jmabel (2943)
- Archaeodontosaurus (2939)
- Jarekt (2935)
- Golbez (2922)
- 663highland (2906)
- Ineuw (2904)
- Jorgeroyan (2882)
- Aquintero82 (2873)
- Rolf H. (2858)
- Elisfkc (2856)
- Cyclonebiskit (2852)
- Edithsme (2824)
- Tamba52 (2821)
- そらみみ (2809)
- Zotteteen1 (2775)
- Chumwa (2768)
- Michielverbeek (2755)
- JonasBR (2661)
- Selenium user (2656)
- Centpacrr (2653)
- Sarang (2644)
- DanmicholoBot (2625)
- Oltau (2595)
- Roland zh (2569)
- Tuvalkin (2546)
- INeverCry (2534)
- Furfur (2527)
- AlexanderRahm (2526)
- Mti (2512)
- Sailko (2506)
- Marku1988 (2485)
- Vincent Steenberg (2482)
- Arch (2478)
- Medium69 (2467)
- Delphi234 (2458)
- Dornicke (2433)
- Discasto (2430)
- JuTa (2430)
- Szczebrzeszynski (2427)
- 1Veertje (2415)
- Botaurus (2400)
- Corkythehornetfan (2388)
- Bogomolov.PL (2345)
- M 93 (2329)
- Fleinn (2326)
- Beao (2301)
- Halavar (2291)
- Asybaris01 (2278)
- Noclador (2273)
- Sodacan (2253)
- Ubcule (2240)
- François de Dijon (2236)
- Monaneko Up (2228)
- Vizu (2220)
- Hyacinth (2220)
- Gryffindor (2184)
- Túrelio (2147)
- Nightflyer (2107)
- 1970gemini (2106)
- Llez (2094)
- AndreasPraefcke (2084)
- Moumou82 (2079)
- Vunz (2075)
- Fleets (2068)
- Shyamal (2064)
- Wereldburger758 (2052)
- File Upload Bot (Vonvikken) (2049)
- YLSS (2043)
- Beyond My Ken (2032)
- Pharos (2023)
- Edgar181 (2001)
- Steinsplitter (1990)
- Phe (1988)
- Enslin (1980)
- TonyTheTiger (1979)
- Bin im Garten (1974)
- Antonsusi (1970)
- Htonl (1969)
- Watchduck (1964)
- Hans G. Oberlack (1963)
- Zscout370 (1959)
- Maphobbyist (1955)
- Rcbutcher (1942)
- SanchoPanzaXXI~commonswiki (1931)
- DarwIn (1931)
- Revent (1919)
- MaxxL (1906)
- MB298 (1904)
- Aavindraa (1871)
- DIREKTOR (1869)
- Olafbot (1864)
- Typhoon2013 (1863)
Upload[edit]
Top 200 users with the most "uploads" entries.
| sql used |
|---|
SELECT user.user_name AS username,
COUNT(logging.log_user) AS count
FROM user
INNER JOIN logging
ON logging.log_user = user.user_id
WHERE logging.log_type = "upload"
AND log_action = "upload"
GROUP BY logging.log_user
ORDER BY COUNT(logging.log_user) DESC
LIMIT 200;
|
- Fæ (4451267)
- Panoramio upload bot (2410290)
- GeographBot (1687970)
- File Upload Bot (Magnus Manske) (1351289)
- Judgefloro (891480)
- BotMultichillT (670110)
- Marcel coenders (453011)
- Tm (442477)
- Ser Amantio di Nicolao (403066)
- Mr.Nostalgic (370855)
- Pharos (364810)
- GerWsUpload (316113)
- Slick-o-bot (313726)
- Hansmuller (286356)
- Tyler ser Noche (267450)
- Flickr upload bot (258986)
- Sailko (227180)
- US National Archives bot (197126)
- Artix Kreiger 2 (193950)
- AliciaFagervingWMSE-bot (181258)
- File Upload Bot (99of9) (179873)
- Hiàn (alt) (167447)
- Russavia (164237)
- Rudolphous (163224)
- Tilman2007 (156897)
- OceanAtoll (152606)
- Butko (138699)
- SecretName101 (137853)
- Josve05a (135295)
- FSII (132485)
- Ies (119499)
- Ramon FVelasquez (107090)
- GazothBot (98822)
- Sporti (92269)
- OSX II (91477)
- YiFeiBot (87590)
- Alfvanbeem (87064)
- A. Wagner (86475)
- BotMultichill (86046)
- Jérémy-Günther-Heinz Jähnick (83239)
- BArchBot (82888)
- DcoetzeeBot (82090)
- Jasonanaggie (82089)
- Jc86035 (81871)
- Sturm (81252)
- Daderot (79537)
- ŠJů (78452)
- RobotMichiel1972 (77967)
- Zarateman (75731)
- Balabinrm (73623)
- MGA73bot2 (68731)
- Chabe01 (68252)
- Matanya (66946)
- RKBot (65938)
- AnRo0002 (65095)
- P.poschadel (64126)
- Jeangagnon (64114)
- FotothekBot (61912)
- ComputerHotline (61790)
- Ultra7 (61045)
- Geagea (60677)
- Raboe001 (59332)
- Paris 16 (59243)
- Helmy oved (59024)
- MB298 (58716)
- Gangulybiswarup (57855)
- DonabelSDSU.bot (57539)
- AndreasPraefcke (56861)
- Wdwdbot (56618)
- DerHexer (55830)
- Jeuwre (53131)
- Ralf Roletschek (52601)
- Pyb (52543)
- Infrogmation (52348)
- Meisam (51841)
- ETH-Bibliothek (51824)
- Atamari (51807)
- Senapa (51714)
- Mindmatrix (51563)
- Jmabel (49595)
- DALIBRI (48223)
- Thesupermat2 (47611)
- Thesupermat (46793)
- Worldenc (46715)
- Nevit (46692)
- Zairon (46672)
- GFreihalter (46600)
- LSHuploadBot (46251)
- Nicolas Rück (WMDE) (46031)
- The Photographer (45814)
- Kwangmo (45536)
- MarcBot~commonswiki (45177)
- KITbot (44961)
- MidleadingBot (44678)
- Jeanhousen (44199)
- DerbethBot (44054)
- Smallbot (43924)
- Metilsteiner (43812)
- FastilyClone (42778)
- François GOGLINS (42696)
- INeverCry (42645)
- Neuchâtel Herbarium (42475)
- Țetcu Mircea Rareș (42421)
- KOKUYO (41819)
- DarwIn (41342)
- David Stang (40394)
- Rufus46 (40338)
- JonasBR (40269)
- Huhu Uet (39669)
- Puramyun31 (39379)
- Famartin (39353)
- Pikiwikisrael (39002)
- Petr1888 (38952)
- Kobac (38550)
- Amada44 (38358)
- Nasjonalbiblioteket-bot (37028)
- Спасимир (36627)
- Globetrotter19 (36528)
- Holger.Ellgaard (36337)
- Rodrigo.Argenton (36109)
- Rama (36017)
- SieBot (35979)
- Lionel Allorge (35870)
- Joanbanjo (35783)
- Deror avi (35769)
- Open Access Media Importer Bot (35766)
- Geo Swan (34879)
- Vinayaraj (34713)
- Soghomon Matevosyan (34473)
- Palickap (34470)
- AkBot (34469)
- Joergens.mi (34463)
- Doko (34024)
- File Upload Bot (Kaldari) (33693)
- そらみみ (33615)
- YarluFileBot (33416)
- Michiel1972 (32804)
- Discasto (32334)
- File Upload Bot (AntWeb) (32144)
- Kaiketsu (31904)
- Mike Peel (31774)
- Immanuel Giel (31526)
- PMRMaeyaert (31179)
- Wmilbot (31091)
- GO69 (31028)
- Unauthorized Bot (31006)
- Brück & Sohn Kunstverlag Meißen (30283)
- MOs810 (29667)
- KTC (29476)
- Jason.nlw (29420)
- Juandev (29220)
- Cherubino (29166)
- Bin im Garten (29129)
- Dcoetzee (29015)
- Havang(nl) (28992)
- Dr. Bernd Gross (28915)
- Sreejithk2000 (28785)
- Noaabot (28528)
- Marcus Cyron (28434)
- Père Igor (28367)
- Aktron (28105)
- Bjoertvedt (27983)
- Shakko (27842)
- TUBS (27727)
- Chatsam (27692)
- AlejandroLinaresGarcia (27542)
- Pere prlpz (27461)
- Karl Gruber (27374)
- Raso mk (27113)
- Zblagojevic (26945)
- Materialscientist (26904)
- Garitan (26655)
- Werner100359 (26653)
- MiguelHermoso (26632)
- Ebastia1 (26524)
- Slowking4 (26329)
- BMacZeroBot (26317)
- Discanto (26176)
- Mattinbgn (26088)
- Elisfkc (26028)
- Victorgrigas (25943)
- GifTagger (25863)
- WeatherBot~commonswiki (25485)
- SchiDD (25374)
- Roland zh (25310)
- Raymond (25220)
- Fastily (24859)
- Piotrus (24844)
- Svema (24590)
- Tschubby (24560)
- Tokfo (24496)
- G.dallorto (24401)
- Mti (24307)
- Ebyabe (24300)
- Enfo (24171)
- Fundación Joaquín Díaz (24139)
- Tokumeigakarinoaoshima (24071)
- Xenophon (24034)
- Ralph Hammann (23929)
- Ben Skála (23872)
