Jump to content

User:ReyBrujo/Dumps

From Wikimedia Incubator
Dumps

April 28, 2007

[edit | edit source]
[edit | edit source]

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

External
links
Article IDArticle
6019990Sah/Күннээҕи ойуу
6020826Шаблон:Potd/2007-04
3818666Pilipinas
3521420Wp/kok/kd/ಕೊಂಕ್ಣಿ ಭಾಸ್
3519887Wp/kok/dn/कोंकणी भास
302Main 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;
[edit | edit source]

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

Link countSite
537http://incubator.wikimedia.org
65http://www.imyura.net
52http://en.wikipedia.org
38http://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 | edit source]

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

[edit | edit source]

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 IDArticle
20636W/w/index.php
21462Wp/sah/forum/w/index.php
21063Wp/sah/w/index.php
22086Talk:W/w/w/index.php?title=W/w/w/index.php

Possible spambot pages

[edit | edit source]

Possible pages created by spambots ending with /.

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

[edit | edit source]

This is the archive of dump analysis.

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