Brúkari:ReyBrujo/Dumps/20070327
Frá Wikipedia, hin frælsa alfrøðin
Dumps
| Innihaldsyvirlit | 
[rætta] March 27, 2007
[rætta] External link dumps
Articles with more than 10 external links as of March 27, 2007. Only articles in the main space are considered.
| External links | Article ID | Article | 
|---|---|---|
| 34 | 5063 | Listi í stavrað | 
| 34 | 1555 | Alfabetiskur listi | 
| 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;
[rætta] External link ranking
Sites linked more than 10 times as of March 27, 2007. Only articles in the main space are considered.
| Link count | Site | 
|---|---|
| 1247 | http://fo.wikipedia.org | 
| 153 | http://www.islandgames.net | 
| 66 | http://www.stamps.fo | 
| 26 | http://www.faroestamps.fo | 
| 22 | http://www.cwgc.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;
[rætta] Additional information
Some more information about this dump:
- 2280 articles that are in the main space and not redirects
- 2644 articles and redirects in the main space
- 5077 pages in all namespaces
- 423 redirects in all namespaces
- 4857 external links in every namespace
- 2282 external links in the main space
[rætta] 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 | 
|---|---|
| 4808 | W//w/index.php | 
[rætta] Possible spambot pages
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 '%/';

