Brúkari:ReyBrujo/Dumps/20070417

Dumps

April 17, 2007Rætta

External link dumpsRætta

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

External
links
Article ID Article
34 1555 Alfabetiskur listi
34 5063 Listi í stavrað
32 1013 Pólland
29 1319 Jólaskipið
18 5534 Oyggjaleikir 2003
17 5538 Oyggjaleikir 1999
17 5536 Oyggjaleikir 2001
16 5541 Oyggjaleikir 1997
16 5528 Oyggjaleikir 2005
15 5547 Oyggjaleikir 1991
15 5545 Oyggjaleikir 1993
15 5543 Oyggjaleikir 1995
13 5548 Oyggjaleikir 1989
13 5655 Montenegro
11 1556 Wikimedia
11 3131 Oyggjaleikir
10 5550 Oyggjaleikir 1987
10 3263 Indo-evropeisk mál
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 rankingRætta

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

Link count Site
1298 http://fo.wikipedia.org
153 http://www.islandgames.net
66 http://www.stamps.fo
26 http://www.faroestamps.fo
22 http://www.cwgc.org
10 http://da.wikipedia.org
10 http://www.rit.fo
10 http://www.heimskringla.no
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 informationRætta

Some more information about this dump:

  • 2356 articles that are in the main space and not redirects
  • 2787 articles and redirects in the main space
  • 5257 pages in all namespaces
  • 491 redirects in all namespaces
  • 4955 external links in every namespace
  • 2370 external links in the main space

Very probable spambot pagesRætta

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
4808 W//w/index.php

Possible spambot pagesRætta

Possible pages created by spambots ending with /.

Article ID Article
953 User:Ævar Arnfjörð Bjarmason/
952 User talk:Ævar Arnfjörð Bjarmason/
796 Wikipedia:Broken/
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 '%/';