Benutzer:ReyBrujo/Dumps

Dumps

April 27, 2007

External link dumps

Dump table	Hits
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

Dump table	Hits
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

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

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 ID	Article
792874	User:Jonaslange/de/index.php
792875	User:Jonaslange/en/index.php
798830	User talk:Jonaslange/de/index.php
798831	User talk:Jonaslange/en/index.php

Possible spambot pages

Possible pages created by spambots ending with /.

Article ID	Article
1073924	/
1789797	Franklin-Expedition/
1322223	RSS/
1911344	Zeb/
1073932	/
2442675	Talk:Angemeldeter Benutzer/
251058	Talk:Freiwirtschaft/Archiv01/
256193	Talk:Jan Udo Holey/Archiv/
2250640	Talk:Jerusalem/Archiv/
1952421	Talk:Zeb/
896308	User:3247/Test/Redirects/
1840406	User:3ecken1elfer/
2380052	User:A.fiedler/Test/
2409620	User:A.fiedler/Test1/
2409626	User:A.fiedler/Test2/
1317673	User:ChickenBrain/
1317677	User:ChickenBrain/vorlagen/babel/
1727336	User:DarkAngelOfDeath/Babel/
1339946	User:Der Franke/Schule/Mathe/
1962097	User:Doc Sigi/Spielwiese/Fußball/
2397323	User:Dogcow/
1148429	User:Equistat/west-versand/
742000	User:Gangleri/tests/extensions/
742245	User:Gangleri/tests/extensions/CATEGORIES/
742242	User:Gangleri/tests/extensions/LINKS/
742244	User:Gangleri/tests/extensions/SEEALSO/
742243	User:Gangleri/tests/extensions/SOURCES/
807344	User:Ged/
990746	User:Geo-Loge/Entwürfe/
1453095	User:Gestumblindi/Fakemuseum/
1247973	User:Gregor Dschung/
80480	User:Grrrubber/Links/
2420003	User:Hendrike/Vorlage/
543065	User:Hunding/Test/
1115273	User:Jacob Köhler/Vorlagen/
1929780	User:Jan B/Filme nach Originaltitel/
1725749	User:Jano85/Vorlagen/
1725678	User:Jano85/Vorlagen/Babel/
1494229	User:Jazzman/Archiv/
2473548	User:Jot/Test/Test2/
473403	User:KMJ/Bilder/Wp-Treffen/
2127354	User:Kauter/
1170041	User:Keno/Baustelle/
1501279	User:Limbonic/Vorlagen/
1678341	User:LivingShadow/Vorlagen/
864297	User:Lobservateur/sicher/
2073749	User:Markobr/
270453	User:Mathias Schindler/
1767714	User:Mike Krüger/
1187125	User:Mundartpoet/Spielwiese/
402549	User:Oisín/stubs/
1379872	User:Permi/
1775744	User:Philipp Lensing/Vertrauen/
1789398	User:Primordial/Portal:Konstruierte Sprachen/
1414662	User:Qlined/
2075775	User:SUBTILE/Ablage/
1665402	User:Sanoj/
1033176	User:Scorpion2211/Ex/Aufgabe6/
1038473	User:Scorpion2211/Übungen/Mathe/Blatt2/
1954120	User:Simpsonsfan2/
979117	User:Sjr/Vorlagenbau/
2349931	User:Solaris2006/Bahnbilder/
2373150	User:Solaris2006/Baustelle/
1789489	User:Solaris2006/HD/
1789744	User:Solaris2006/Radio/
2374583	User:Solaris2006/Vorlage/Bahnfreund/
2374702	User:Solaris2006/Vorlage/Com/
2053505	User:Spacebirdy/
915702	User:Spear/
630436	User:St-fl/bilder/
630441	User:St-fl/links/
640521	User:St-fl/vorlagen/
633266	User:St-fl/vorlagen/other wikis/
2215861	User:Tobias.hofmann/Archiv/2006/
2216514	User:Tobias.hofmann/Archiv/2006/IV/
2216544	User:Tobias.hofmann/Archiv/2007/I/
1641265	User:Warhog/
1680385	User:WikipediaMaster/Archiv/
1411085	User:Wolle1024/
1871167	User:ZOiDberg/
1881332	User talk:3ecken1elfer/
2436810	User talk:AbcD/V/
2061001	User talk:BMK/Archiv/
1798726	User talk:ChickenBrain/
1798728	User talk:ChickenBrain/vorlagen/babel/
2060385	User talk:E@zy/Archiv/
1337515	User talk:Gianni Facini/
2473552	User talk:Jot/Test/Test2/
2245595	User talk:Mthezeroth/Archiv/
2026937	User talk:Nodutschke/Archiv/
1619815	User talk:Plenz/
2229918	User talk:Robak/
2072025	User talk:Sargoth/Archiv/
2053508	User talk:Spacebirdy/
2235247	User talk:Stefan Selbach/Archiv/
1256144	User talk:Stern/
861389	User talk:TheK/
292437	User talk:TorsTen/slashdotten/
608459	User talk:Ulrich Leipold/
1199862	User talk:Unterfurtner Herwig/
2279050	User talk:WEssler/
1690149	User talk:WikipediaMaster/Archiv/
1701941	User talk:Zvbn/
2157985	Wikipedia:Administratoren/Probleme/
1894595	Wikipedia:Vermittlungsausschuss/
611749	Wikipedia:WikiProjekt Oberbergisches Land/Organisation/1. Wikipediatreffen Oberberg 22.03.2005/
406107	Wikipedia:WikiProjekt Oberbergisches Land/Organisation/Anfragen/
509267	Wikipedia:WikiProjekt Oberbergisches Land/Organisation/Anregungen/
299614	Wikipedia:WikiProjekt Oberbergisches Land/Organisation/Formales/
354499	Wikipedia:WikiProjekt Oberbergisches Land/Organisation/Quellen/
496840	Wikipedia:WikiProjekt Oberbergisches Land/Organisation/Termine/
299600	Wikipedia:WikiProjekt Oberbergisches Land/Organisation/ToDos/
406311	Wikipedia:WikiProjekt Oberbergisches Land/Organisation/neue Artikel
2352616	Wikipedia talk:WikiProjekt Ostwestfalen-Lippe/Archiv/
2415059	Portal 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 '%/';

Archive

Dump analysis archive

This is the archive of dump analysis.

• April 2, 2007
• February 6, 2007
• January 24, 2007

ak:User:ReyBrujo/Dumps