Utent:ReyBrujo/Dumps/20070420
< Utent:ReyBrujo | Dumps
Dumps
Werrej
April 20, 2007
immodifikaExternal link dumps
immodifikaArticles with more than 10 external links as of April 20, 2007. Only articles in the main space are considered.
External links |
Article ID | Article |
---|---|---|
42 | 2031 | Astronomija |
20 | 1 | Paġna prinċipali |
19 | 5569 | Maja |
18 | 2938 | Galileo Galilei |
18 | 3122 | Psikoloġija |
18 | 5363 | Opossum ta' denbu qasir |
16 | 2323 | Pjaneta |
16 | 3590 | Mammiferi |
15 | 994 | Blogg |
15 | 3082 | AIDS |
14 | 1052 | Polonja |
14 | 1424 | Medja Maltija |
13 | 2067 | Storja ta' Malta |
11 | 5365 | Opossum irqiq |
11 | 3455 | Serbja |
10 | 3692 | Kompjuter |
10 | 1442 | Lingwa Awżiljari Internazzjonali |
10 | 1604 | Toni Sant |
10 | 2691 | Eklissi |
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
immodifikaDump table | Hits |
---|---|
Sites linked more than 10 times | 23 |
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
immodifikaSome more information about this dump:
- 1503 articles that are in the main space and not redirects
- 1952 articles and redirects in the main space
- 4474 pages in all namespaces
- 503 redirects in all namespaces
- 3218 external links in every namespace
- 2670 external links in the main space
Very probable spambot pages
immodifikaIf 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 |
---|---|
5921 | W/w/index.php |
5880 | MediaWiki talk:Ipb already blocked/w/index.php |
Possible spambot pages
immodifikaPossible pages created by spambots ending with /.
Article ID | Article |
---|---|
2292 | Template:PaġnaPrinċipali/Kont taf/ |
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 '%/';