Utent:ReyBrujo/Dumps
Da Wikipedia.
Dumps
Contnù |
[modìfica] April 30, 2007
[modìfica] External link dumps
Articles with more than 5 external links as of April 30, 2007. Only articles in the main space are considered.
| External links |
Article ID | Article |
|---|---|---|
| 33 | 1 | Intrada |
| 23 | 1633 | Bolé an piemontèis |
| 12 | 5541 | Wikipedia |
| 9 | 2365 | Parlé dla Galia |
| 9 | 4270 | Politécnich ëd Turin |
| 8 | 1744 | Pinus strobus |
| 8 | 3105 | Età dla pera |
| 5 | 3187 | Età dël bronz |
| 5 | 8670 | Trakai |
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;
[modìfica] External link ranking
Sites linked more than 5 times as of April 30, 2007. Only articles in the main space are considered.
| Link count | Site |
|---|---|
| 993 | http://www.sil.org |
| 237 | http://kvaleberg.com |
| 12 | http://www.fungoceva.it |
| 10 | http://www.agraria.org |
| 9 | http://forum.funghiitaliani.it |
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;
[modìfica] Additional information
Some more information about this dump:
- 6843 articles that are in the main space and not redirects
- 7195 articles and redirects in the main space
- 10346 pages in all namespaces
- 393 redirects in all namespaces
- 1856 external links in every namespace
- 1659 external links in the main space
[modìfica] 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 |
|---|---|
| 8754 | W/index.php |
| 9943 | W/w/index.php |
[modìfica] 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

