Last modified on 7 May 2007, at 02:21

User:ReyBrujo/Dumps

Dumps

April 28, 2007Edit

External link dumpsEdit

Articles with more than 50 external links as of April 28, 2007. Only articles in the main space are considered.

External
links
Article ID Article
532 215382 Chinese stroke order:Progress2
504 214684 Chinese stroke order:Progress
359 1527205 Sources Heine Buch der Lieder 1827
275 11043 English pronunciation
106 10116 Italian pronunciation
72 256598 Wikimania 2005 Presentations
71 113200 Portuguese pronunciation
52 11083 Latin pronunciation
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 rankingEdit

Sites linked more than 50 times as of April 28, 2007. Only articles in the main space are considered.

Link count Site
1167 http://tools.wikimedia.de
1036 http://www.internationalscientific.org
707 http://commons.wikimedia.org
359 http://germa83.uni-trier.de
228 http://it.wikipedia.org
108 http://en.wikipedia.org
90 http://de.wikipedia.org
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 informationEdit

Some more information about this dump:

  • 59495 articles that are in the main space and not redirects
  • 85081 articles and redirects in the main space
  • 1775422 pages in all namespaces
  • 35441 redirects in all namespaces
  • 3212677 external links in every namespace
  • 4963 external links in the main space

Very probable spambot pagesEdit

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
1991162 Commons:Deletion requests/w/index.php

Possible spambot pagesEdit

Possible pages created by spambots ending with /.

Article ID Article
1762812 [[1]]
16070 User:Aka/Images/
1490509 User:Benjah-bmm27/Gallery/chemistry/
969638 User:Dermeister/
1720205 User:Desert sapper/Archive/
500267 User:Gobeirne/Images/
1466426 User:Hno3/MyGallery/
107284 User:Jredmond/
309660 User:Kyle Andrew Brown/
729925 User:Liquid 2003/
637146 User:MG/
934701 User:Moti-v Commons/
1046766 User:My name/Projekte/
1364314 User:Nevit/
1735771 User:PalaeoMal/
613648 User:Sam916/sandbox/
690715 User:Sl/wiki/gallery
1817445 User:Tackbert/Commons.wikimedia.org/wiki/Image:Kyotogarden.jpg
1720201 User talk:Desert sapper/Archive/
1908492 Commons:Alice Taglioni/
470679 Commons:Authorization to use material from http://www.cordoba.gov.co/monteria/
1654076 Commons:Deletion requests/
1954885 Commons:Deletion requests/Image:http://commons.wikimedia.org/wiki/Image:Autofellatio.ogg
1647944 Commons:Deletion requests/Image:http://commons.wikimedia.org/wiki/Image:Stojan1jpg.jpg
1271783 Commons:Featured picture candidates/
1761890 Commons:Featured picture candidates//wiki/Image:DSCF0197-1.JPG
1717398 Commons:Featured picture candidates/http://commons.wikimedia.org/wiki/Image:Fruitbowlwithmelons.jpg
1707173 Commons:Featured picture candidates/http://commons.wikimedia.org/wiki/Image:Maspalomas west coast.jpg
1819393 Commons:Featured picture candidates/http://en.wikipedia.org/wiki/Image:DirkvdM irazu 4.jpg
1549357 Commons:Featured picture candidates/http://en.wikipedia.org/wiki/Image:Islamic decorative plate.jpg
1494749 Commons:Featured picture candidates/removal/
1077517 Commons:Featured pictures candidates/Commons:Featured pictures candidates/http://commons.wikimedia.org/wiki/Image:Eastern Swallowtail.jpg
978828 Commons:Featured pictures candidates/Http://commons.wikimedia.org/wiki/Image:Poppies.jpg
989117 Commons:Featured pictures candidates/http://commons.wikimedia.org/wiki/Image:Twelve-bens.jpg
991101 Commons:Featured pictures candidates/http://commons.wikimedia.org/wiki/Image:Zamek w Lublinie.jpg
1492373 Commons:Tools/
1967760 Commons talk:Forum/Archiv/wiki/Commons:Forum/
1912509 MediaWiki:Upload-url/
224291 Template:4x4 type square/
134816 Template:ARTICLESPACE/
1077471 Template:Deletion requests/Archive/En/
1166055 Template:Lts/
223882 Template:Revid/
1491478 Template:Talk/
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 '%/';

ru-sib:User:ReyBrujo/Dumps