User:ReyBrujo/Dumps

Dumps

April 28, 2007

External link dumps

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

External links	Article ID	Article
60	19990	Sah/Күннээҕи ойуу
60	20826	Шаблон:Potd/2007-04
38	18666	Pilipinas
35	21420	Wp/kok/kd/ಕೊಂಕ್ಣಿ ಭಾಸ್
35	19887	Wp/kok/dn/कोंकणी भास
30	2	Main Page

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

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

Link count	Site
537	http://incubator.wikimedia.org
65	http://www.imyura.net
52	http://en.wikipedia.org
38	http://www.sil.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 information

Some more information about this dump:

• 7104 articles that are in the main space and not redirects
• 8069 articles and redirects in the main space
• 12765 pages in all namespaces
• 1191 redirects in all namespaces
• 4898 external links in every namespace
• 2433 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
20636	W/w/index.php
21462	Wp/sah/forum/w/index.php
21063	Wp/sah/w/index.php
22086	Talk:W/w/w/index.php?title=W/w/w/index.php

Possible spambot pages

Possible pages created by spambots ending with /.

Article ID	Article
17852	Kullanıcı mesaj:Tarih/
20075	Test-wp/
16224	Test-wp/ban/
15661	Test-wp/chu-nom/
1161	Test-wp/enm/
17169	Test-wp/hak/
18400	Test-wp/jpn-classical/三國演義/
20131	Test-wp/krj/
6928	Test-wp/mur/
9496	Test-wp/non/
15114	Test-wp/nov/
6920	Test-wp/pqm/
16172	Test-wp/vi-nom/
6930	Test-wp/wawa/
6932	Test-wp/zb/
2041	Test-wp/zea/
6911	Wn/fi/
16536	Wn/hu/
15882	Wp/arc/
6901	Wp/be/
19886	Wp/ext/
15050	Wp/gan/
18900	Wp/gsc-es/
16533	Wp/hu/
16131	Wp/ikodobo/
19012	Wp/kaa/
16758	Wp/kab/
19883	Wp/kok/
1235	Wp/lld/
9194	Wp/non/
19879	Wp/rif/
18723	Wp/sah/
15095	Wp/sla/
2496	Wp/stq/Poatermutse (Aconitum)/
6923	Wp/twd/
2145	Talk:Test-WP/hsb/
6927	Talk:Test-wp/and/
2117	Talk:Test-wp/bdf/
2135	Talk:Test-wp/enm/
2141	Talk:Test-wp/fiu-vro/
2143	Talk:Test-wp/gem-zws/
17170	Talk:Test-wp/hak/
2146	Talk:Test-wp/ilo/
2147	Talk:Test-wp/lad/
6929	Talk:Test-wp/mur/
9378	Talk:Test-wp/new/
2191	Talk:Test-wp/sco/
6922	Talk:Test-wp/smg/
2200	Talk:Test-wp/ven/
6931	Talk:Test-wp/wawa/
2206	Talk:Test-wp/wen/
6933	Talk:Test-wp/zb/
14456	Talk:Test-wp/zh-hak/
20916	Talk:Wp/gan/
15109	Talk:Wp/sla/
9990	Talk:Wp/stq/
6742	User:Dbmag9/
18784	User:Purodha/
20686	User talk:Alessandro/
17405	User talk:Tarih/

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 17, 2007
• April 05, 2007

ak:User:ReyBrujo/Dumps ru-sib:User:ReyBrujo/Dumps