Brúkari:ReyBrujo/Dumps/20070417
Tools
Actions
General
Skriva út/útflyt
Aðrar verkætlanir
Appearance
Frá Wikipedia, hin frælsa alfrøðin
< Brúkari:ReyBrujo | Dumps
Dumps
April 17, 2007
[rætta | rætta wikitekst]External link dumps
[rætta | rætta wikitekst]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 ranking
[rætta | rætta wikitekst]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 information
[rætta | rætta wikitekst]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 pages
[rætta | rætta wikitekst]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 pages
[rætta | rætta wikitekst]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 '%/';