Benutzer:ReyBrujo/Dumps/20070402

aus Wikipedia, der freien Enzyklopädie
Zur Navigation springen Zur Suche springen
Dumps
[Bearbeiten | Quelltext bearbeiten]
Dump table Hits
Articles with more than 50 external links 183
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;
[Bearbeiten | Quelltext bearbeiten]
Dump table Hits
Sites linked more than 100 times 516
Sites linked between 50 and 99 times 640
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:

  • 575976 articles that are in the main space and not redirects
  • 977199 articles and redirects in the main space
  • 1525049 pages in all namespaces
  • 407113 redirects in all namespaces
  • 2011241 external links in every namespace
  • 929733 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 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

[Bearbeiten | Quelltext bearbeiten]

Possible pages created by spambots ending with /.

Article ID Article
1073924 /
1789797 Franklin-Expedition/
1322223 RSS/
1911344 Zeb/
1073932 /
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/
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/
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/
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/neueArtikel/
2352616 Wikipedia talk:WikiProjekt Ostwestfalen-Lippe/Archiv/
2413242 Template:Football squad player/role/
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 '%/';