User:ReyBrujo/Dumps
Mei he Wikipedia
Dumps
Contents |
[fatuʻi vahe] April 30, 2007
[fatuʻi vahe] External link dumps
Articles with more than 3 external links as of April 30, 2007. Only articles in the main space are considered.
| External links |
Article ID | Article |
|---|---|---|
| 3 | 3019 | Home Island |
| 3 | 3065 | Kahomovailahi |
| 3 | 3154 | Late |
| 3 | 2281 | ʻAhoʻeitu ʻUnuakiʻotonga Tukuʻaho |
| 3 | 4028 | ʻAi |
| 3 | 2479 | Siosāteki Tonga Veikune |
| 3 | 4109 | Limutahi |
| 3 | 2285 | Solomone Ula |
| 3 | 3932 | Pele |
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;
[fatuʻi vahe] External link ranking
Sites linked more than 3 times as of April 30, 2007. Only articles in the main space are considered.
| Link count | Site |
|---|---|
| 467 | http://to.wikipedia.org |
| 44 | http://www.planet-tonga.com |
| 39 | http://teneia.com |
| 15 | http://www.matangitonga.to |
| 14 | http://parliament.gov.to |
| 14 | http://www.worldstatesmen.org |
| 13 | http://www.uq.net.au |
| 13 | http://freepages.genealogy.rootsweb.com |
| 12 | http://www.volcano.si.edu |
| 9 | http://www.pmo.gov.to |
| 7 | http://epress.anu.edu.au |
| 5 | http://www.familysearch.org |
| 4 | http://www.fiat.to |
| 4 | http://www.hear.org |
| 4 | http://www.findarticles.com |
| 3 | http://www.tongatapu.net.to |
| 3 | http://www1.tonga-now.to |
| 3 | http://palaceoffice.gov.to |
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;
[fatuʻi vahe] Additional information
Some more information about this dump:
- 1048 articles that are in the main space and not redirects
- 1076 articles and redirects in the main space
- 2912 pages in all namespaces
- 36 redirects in all namespaces
- 2274 external links in every namespace
- 703 external links in the main space
[fatuʻi vahe] 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 |
|---|
[fatuʻi vahe] Possible spambot pages
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 '%/';
Archive
commons:User:ReyBrujo/Dumpsru-sib:User:ReyBrujo/Dumpstest:User:ReyBrujo/Dumps
