Usuario:ReyBrujo/Dumps/20070329
< Usuario:ReyBrujo · Dumps
Dumps
Índice
March 29, 2007
editarExternal link dumps
editarDump table | Hits |
---|---|
Articles with more than 50 external links | 179 |
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
editarDump table | Hits |
---|---|
Sites linked more than 50 times | 391 |
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
editarSome more information about this dump:
- 219275 articles that are in the main space and not redirects
- 348851 articles and redirects in the main space
- 545080 pages in all namespaces
- 138272 redirects in all namespaces
- 497592 external links in every namespace
- 357965 external links in the main space
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 and protected if possible.
Article ID | Article |
---|---|
627243 | W/index.php |
562362 | Wikipedia:Autorización:http://www.adezaragoza.org/diabetes/index.php?id=26 |
Possible spambot pages
editarPossible pages created by spambots ending with /.
Article ID | Article |
---|---|
640207 | / |
764926 | José Manuel Orengo Pastor/ |
547302 | ~/ |
243137 | User:Ciencia Al Poder/ |
509284 | User:Cratón/País de la semana/ |
666544 | User:Darz Mol/prueba1/ |
725890 | User:Diegogrez/UserboxMaker/ |
551419 | User:Faelomx/ctr/ |
811638 | User:Kzman/Datos/Cuadernos/ |
778529 | User:Liquid-aim-bot/ |
826486 | User:Roblespepe/Archivo/ |
562322 | User:Titogonzalez23/proyectos/ |
562326 | User talk:Titogonzalez23/proyectos/ |
236293 | Wikipedia:Autorizaciones/Autorización de reproducción de las imágenes de la página web http://www.centroeu.com/uboote/ |
643191 | Wikipedia:Autorizaciones/http://coda.pe.tripod.com/eugeniocourret/ |
389454 | Wikipedia:Autorizaciones/http://www.agenciacatolica.com.mx/ |
389459 | Template:Agenciacatolica.com.mx/ |
751099 | Portal:Veracruz de Ignacio de la Llave/Imagen/Archivo/ |
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 '%/';