Қатысушы:ReyBrujo/Dumps/20070213

Уикипедиядан

Dumps

Мазмұны

[өңдеу] February 13, 2007

[өңдеу] External link dumps

Articles with more than 5 external links as of February 13, 2007. Only articles in the main space are considered.

External
links
Article ID Article
80 2233 Футболдан әлем чемпионаты 2006
40 3612 Қазақ әліппесі
23 3320 Қазақстан жоғарғы оқу орын тізімі
20 3948 Рамазан
15 4522 Үшінші қалыпты түр
14 1030 Қазақстан
10 2774 Ел тізімі
7 2202 Ашық Тізімдеме Жобасы
6 2769 Мошовце
5 1035 Қырғызстан
5 1656 Атырау облысы
5 1721 Әзірбайжан
5 2590 Түркия
5 3380 Ел тізімі (жалпы қабылданған атаулар)
5 1036 Өзбекстан
5 1037 Түрікменстан
5 3746 Қазақ транслитерациясы
5 5334 Солтүстік Қыбыр
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 5 times as of February 13, 2007. Only articles in the main space are considered.

Link count Site
153 http://kk.wikipedia.org
66 http://fifaworldcup.yahoo.com
41 http://kvaleberg.com
33 http://www.dmoz.org
32 http://www.fileformat.info
12 http://
11 http://www.globalguide.org
5 http://news.bbc.co.uk
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:

  • 511 articles that are in the main space and not redirects
  • 759 articles and redirects in the main space
  • 3261 pages in all namespaces
  • 323 redirects in all namespaces
  • 2288 external links in every namespace
  • 506 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

[өңдеу] Possible spambot pages

Possible pages created by spambots ending with /.

Article ID Article
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 '%/';