Usuario:ReyBrujo/Dumps/20070329
De Wikipedia, la enciclopedia libre
< Usuario:ReyBrujo · Dumps
Dumps
March 29, 2007[editar]
External link dumps[editar]
| Dump 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[editar]
| Dump 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[editar]
Some 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[editar]
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 |
|---|---|
| 627243 | W/index.php |
| 562362 | Wikipedia:Autorización:http://www.adezaragoza.org/diabetes/index.php?id=26 |
Possible spambot pages[editar]
Possible 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 '%/';