Usuário(a):ReyBrujo/Dumps/20070201
< Usuário(a):ReyBrujo | Dumps
Dumps
Índice
February 1, 2007
editarExternal links
editarDump table | Hits |
---|---|
Articles with more than 50 external links | 88 |
SELECT COUNT(el_from) AS total, el_from, page_title FROM externallinks, page WHERE el_from = page_id AND page_is_redirect = 0 AND page_namespace = 0 GROUP BY el_from ORDER BY total DESC; 179452 rows in set (1 min 20.26 sec)
External link ranking
editarDump table | Hits |
---|---|
Sites linked more than 50 times | 161 |
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; 58713 rows in set (1 min 48.80 sec)
Additional information
editarSome more information about January's dump:
- 242,168 articles that are in the main space and not redirects
- 451,773 articles and redirects in the main space
- 735,285 pages in all namespaces
- 215,844 redirects in all namespaces
- 509,975 external links in all namespaces
- 436,517 external links in the main namespace
Very probable spambot pages
editarIf 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.
Article ID | Article |
---|---|
658043 | Invision_Power_Board/w/index.php |
646510 | PCBoard/w/index.php |
658001 | PCBoard/w/w/index.php |
647078 | PhpBB/w/index.php |
175559 | W/index.php |
175875 | Discussão:W/index.php |
Possible spambot pages
editarPossible pages created by spambots ending with /.
Article ID | Article |
---|---|
651001 | \o/ |
815988 | Usuário:/guipastana/ |
126591 | Usuário:555/Caçada/ |
815993 | Usuário Discussão:/guipastana/ |
127781 | Usuário Discussão:555/Caçada/ |
227102 | Usuário Discussão:Predefinição teste/Info/Montanha/ |
345839 | Predefinição:=/ |
419190 | Categoria:Itens candidatos à eliminação/ |
SELECT page_id, page_title, page_namespace FROM page WHERE page_title LIKE '%index.php%' OR page_title LIKE '%/'; 14 rows in set (1.35 sec)