Benutzer:ReyBrujo/Dumps

edit
Dumps

April 27, 2007[Bearbeiten | Quelltext bearbeiten]
External link dumps[Bearbeiten | Quelltext bearbeiten]

Dump tableHits

Articles with more than 50 external links
194
SELECT COUNT(el_from) AS total, el_from, page_title
FROM externallinks, page
WHERE externallinks.el_from = page_id AND page_is_redirect = 0 AND page_namespace = 0
GROUP BY el_from
ORDER BY total DESC;
External link ranking[Bearbeiten | Quelltext bearbeiten]

Dump tableHits

Sites linked more than 100 times
537

Sites linked between 50 and 99 times
654
SELECT COUNT(el_to) AS total, SUBSTRING_INDEX(el_to, '/', 3) AS search
FROM externallinks, page
WHERE page_id = el_from AND page_namespace = 0
GROUP BY search
ORDER BY total DESC;
Additional information[Bearbeiten | Quelltext bearbeiten]
Some more information about this dump:
587126 articles that are in the main space and not redirects
997224 articles and redirects in the main space
1558657 pages in all namespaces
416302 redirects in all namespaces
2045694 external links in every namespace
958989 external links in the main space
Very probable spambot pages[Bearbeiten | Quelltext bearbeiten]
If index.php is found in a page title, it is very likely the article talk page has been created by a spambot. These pages should be deleted and protected if possible.

Article IDArticle

792874User:Jonaslange/de/index.php

792875User:Jonaslange/en/index.php

798830User talk:Jonaslange/de/index.php

798831User talk:Jonaslange/en/index.php
Possible spambot pages[Bearbeiten | Quelltext bearbeiten]
Possible pages created by spambots ending with /.

Article IDArticle

1073924/

1789797Franklin-Expedition/

1322223RSS/

1911344Zeb/

1073932/

2442675Talk:Angemeldeter Benutzer/

251058Talk:Freiwirtschaft/Archiv01/

256193Talk:Jan Udo Holey/Archiv/

2250640Talk:Jerusalem/Archiv/

1952421Talk:Zeb/

896308User:3247/Test/Redirects/

1840406User:3ecken1elfer/

2380052User:A.fiedler/Test/

2409620User:A.fiedler/Test1/

2409626User:A.fiedler/Test2/

1317673User:ChickenBrain/

1317677User:ChickenBrain/vorlagen/babel/

1727336User:DarkAngelOfDeath/Babel/

1339946User:Der Franke/Schule/Mathe/

1962097User:Doc Sigi/Spielwiese/Fußball/

2397323User:Dogcow/

1148429User:Equistat/west-versand/

742000User:Gangleri/tests/extensions/

742245User:Gangleri/tests/extensions/CATEGORIES/

742242User:Gangleri/tests/extensions/LINKS/

742244User:Gangleri/tests/extensions/SEEALSO/

742243User:Gangleri/tests/extensions/SOURCES/

807344User:Ged/

990746User:Geo-Loge/Entwürfe/

1453095User:Gestumblindi/Fakemuseum/

1247973User:Gregor Dschung/

80480User:Grrrubber/Links/

2420003User:Hendrike/Vorlage/

543065User:Hunding/Test/

1115273User:Jacob Köhler/Vorlagen/

1929780User:Jan B/Filme nach Originaltitel/

1725749User:Jano85/Vorlagen/

1725678User:Jano85/Vorlagen/Babel/

1494229User:Jazzman/Archiv/

2473548User:Jot/Test/Test2/

473403User:KMJ/Bilder/Wp-Treffen/

2127354User:Kauter/

1170041User:Keno/Baustelle/

1501279User:Limbonic/Vorlagen/

1678341User:LivingShadow/Vorlagen/

864297User:Lobservateur/sicher/

2073749User:Markobr/

270453User:Mathias Schindler/

1767714User:Mike Krüger/

1187125User:Mundartpoet/Spielwiese/

402549User:Oisín/stubs/

1379872User:Permi/

1775744User:Philipp Lensing/Vertrauen/

1789398User:Primordial/Portal:Konstruierte Sprachen/

1414662User:Qlined/

2075775User:SUBTILE/Ablage/

1665402User:Sanoj/

1033176User:Scorpion2211/Ex/Aufgabe6/

1038473User:Scorpion2211/Übungen/Mathe/Blatt2/

1954120User:Simpsonsfan2/

979117User:Sjr/Vorlagenbau/

2349931User:Solaris2006/Bahnbilder/

2373150User:Solaris2006/Baustelle/

1789489User:Solaris2006/HD/

1789744User:Solaris2006/Radio/

2374583User:Solaris2006/Vorlage/Bahnfreund/

2374702User:Solaris2006/Vorlage/Com/

2053505User:Spacebirdy/

915702User:Spear/

630436User:St-fl/bilder/

630441User:St-fl/links/

640521User:St-fl/vorlagen/

633266User:St-fl/vorlagen/other wikis/

2215861User:Tobias.hofmann/Archiv/2006/

2216514User:Tobias.hofmann/Archiv/2006/IV/

2216544User:Tobias.hofmann/Archiv/2007/I/

1641265User:Warhog/

1680385User:WikipediaMaster/Archiv/

1411085User:Wolle1024/

1871167User:ZOiDberg/

1881332User talk:3ecken1elfer/

2436810User talk:AbcD/V/

2061001User talk:BMK/Archiv/

1798726User talk:ChickenBrain/

1798728User talk:ChickenBrain/vorlagen/babel/

2060385User talk:E@zy/Archiv/

1337515User talk:Gianni Facini/

2473552User talk:Jot/Test/Test2/

2245595User talk:Mthezeroth/Archiv/

2026937User talk:Nodutschke/Archiv/

1619815User talk:Plenz/

2229918User talk:Robak/

2072025User talk:Sargoth/Archiv/

2053508User talk:Spacebirdy/

2235247User talk:Stefan Selbach/Archiv/

1256144User talk:Stern/

861389User talk:TheK/

292437User talk:TorsTen/slashdotten/

608459User talk:Ulrich Leipold/

1199862User talk:Unterfurtner Herwig/

2279050User talk:WEssler/

1690149User talk:WikipediaMaster/Archiv/

1701941User talk:Zvbn/

2157985Wikipedia:Administratoren/Probleme/

1894595Wikipedia:Vermittlungsausschuss/

611749Wikipedia:WikiProjekt Oberbergisches Land/Organisation/1. Wikipediatreffen Oberberg 22.03.2005/

406107Wikipedia:WikiProjekt Oberbergisches Land/Organisation/Anfragen/

509267Wikipedia:WikiProjekt Oberbergisches Land/Organisation/Anregungen/

299614Wikipedia:WikiProjekt Oberbergisches Land/Organisation/Formales/

354499Wikipedia:WikiProjekt Oberbergisches Land/Organisation/Quellen/

496840Wikipedia:WikiProjekt Oberbergisches Land/Organisation/Termine/

299600Wikipedia:WikiProjekt Oberbergisches Land/Organisation/ToDos/

406311Wikipedia:WikiProjekt Oberbergisches Land/Organisation/neue Artikel

2352616Wikipedia talk:WikiProjekt Ostwestfalen-Lippe/Archiv/

2415059Portal talk:Drogen/Archiv/
SELECT page_id, page_title, page_namespace
FROM page
WHERE page_title LIKE '%index.php%' OR page_title LIKE '%/wiki/%' OR page_title LIKE '%/w/%' OR page_title LIKE '%/';

edit
Archive


Dump analysis archive[Bearbeiten | Quelltext bearbeiten]
This is the archive of dump analysis.
April 2, 2007
February 6, 2007
January 24, 2007