User:ReyBrujo/Dumps/20070405

From Wikimedia Incubator
Jump to navigation Jump to search
Dumps

April 05, 2007[edit]

External link dumps[edit]

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

External
links
Article ID Article
60 20826 Шаблон:Potd/2007-04
60 19990 Sah/Күннээҕи ойуу
38 18666 Pilipinas
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[edit]

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

Link count Site
452 http://incubator.wikimedia.org
65 http://www.imyura.net
52 http://en.wikipedia.org
33 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[edit]

Some more information about this dump:

  • 6195 articles that are in the main space and not redirects
  • 7095 articles and redirects in the main space
  • 11439 pages in all namespaces
  • 1125 redirects in all namespaces
  • 4550 external links in every namespace
  • 2153 external links in the main space

Very probable spambot pages[edit]

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
16025 W/index.php
20636 W/w/index.php
17705 Talk:Wp/kab/w/index.php?title=Wp/kab/w/index.php

Possible spambot pages[edit]

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/
16087 Template talk:N en/wiki/Template talk:N en/list/
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 '%/';