April 26, 2007Bıvurne

External link dumpsBıvurne

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

Article ID Article
108 144 Hz Nuh
16 351 Zazaki
11 31 Baba Qef
8 20 Arşiv
6 3987 Adam Smith
6 246 Philip Kotler
6 383 Galatasaray
5 4153 Meral Dalaman
5 4009 Sezen Aksu
5 4225 Friedrich Nietzsche
5 380 Faruk İremet
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

External link rankingBıvurne

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

Link count Site
655 http://diq.wikipedia.org
107 http://www.submission.info
20 http://zazapress.tripod.com
9 http://www21.brinkster.com
9 http://www.zazaki.de
7 http://en.wikipedia.org
7 http://sv.wikipedia.org
7 http://www.zazapress.info.se
5 http://www.cia.gov
5 http://f51.parsimony.net
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

Additional informationBıvurne

Some more information about this dump:

  • 1384 articles that are in the main space and not redirects
  • 1512 articles and redirects in the main space
  • 2194 pages in all namespaces
  • 153 redirects in all namespaces
  • 1175 external links in every namespace
  • 1067 external links in the main space

Very probable spambot pagesBıvurne

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 pagesBıvurne

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

Dump analysis archiveBıvurne

This is the archive of dump analysis.