Usuario:ReyBrujo/Dumps

edit
Dumps

November 26, 2008[editar]
External link dumps[editar]

Dump tableHits

Articles with more than 50 external links
775

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 tableHits

Sites linked more than 50 times
1448

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:
421229 articles that are in the main space and not redirects
790588 articles and redirects in the main space
1368981 pages in all namespaces
383839 redirects in all namespaces
2610066 external links in every namespace
1083675 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 IDArticle

1563264Wikipedia:Autorizaciones/free-logistics.com/index.php/es

562362Wikipedia:Autorizaciones/www.adezaragoza.org/diabetes/index.php?id=26

1875001Wikipedia:Autorización:http://www.adezaragoza.org/diabetes/index.php?id=26
Possible spambot pages[editar]
Possible pages created by spambots ending with /.

Article IDArticle

1322747/

1042025Javier Torres maldonado/

1497822Ley de Godwin/

547302~/

1598812Talk:DelChoco.Com/

1609426Talk:Http://en.wikipedia.org/wiki/Lincoln Partido

1389127User:333/

243137User:Ciencia Al Poder/

2055903User:Covi/Userboxes/

509284User:Cratón/País de la semana/

666544User:Darz Mol/prueba1/

2049891User:Der Kreole/

725890User:Diegogrez/UserboxMaker/

551419User:Faelomx/ctr/

1993159User:Iat-CTI/Prueba/

1135082User:InfoBot/

1935513User:Jorgeeduardomarin/

811638User:Kzman/Datos/Cuadernos/

778529User:Liquid-aim-bot/

1425185User:Luca Turilli/

1460239User:MisterWiki/Descargar Wikipedia (traduciendo de http://en.wikipedia.org/wiki/Wikipedia:Database download)

1601687User:Muro de Aguas/

1995474User:Ornitododo/q/w/e/r/t/y/u/i/o/p/a/s/d/f/g/h/j/k/l/z/x/c/v/b/n/m

1988298User:Pla y Grande Covián/aragonés/

1774307User:Pla y Grande Covián/enlaces/

826486User:Roblespepe/Archivo/

562322User:Titogonzalez23/proyectos/

1517482User:Tonchizerodos/Userboxes/Ubicación (ar-barrio)/

1226701User:Usrwp/trash:/

1460270User talk:MisterWiki/Descargar Wikipedia (traduciendo de http://en.wikipedia.org/wiki/Wikipedia:Database download)

562326User talk:Titogonzalez23/proyectos/

1272853Wikipedia:Autorizaciones/

236293Wikipedia:Autorizaciones/Autorización de reproducción de las imágenes de la página web http://www.centroeu.com/uboote/

949465Wikipedia:Autorizaciones/bigbangblues.blogspot.com/

643191Wikipedia:Autorizaciones/http://coda.pe.tripod.com/eugeniocourret/

389454Wikipedia:Autorizaciones/http://www.agenciacatolica.com.mx/

898154Wikipedia:Autorizaciones/http://www.arbil.org/

1128500Wikipedia:Autorizaciones/http://www.atelierpdf.com/paulhan.sljp/

903837Wikipedia:Autorizaciones/jorgevillaverde.com.ar/

2002799Wikipedia:Candidatas a imágenes destacadas/

867466Template:Agenciacatolica.com.mx/

1848652Portal:Escultismo/Foto seleccionada archivo/

914190Portal:Espiritualidad/

751099Portal:Veracruz de Ignacio de la Llave/Imagen/Archivo/

2084297Unknown:Simuladores de vuelo/Plantillas/
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 '%/';

edit
Archive


Dump analysis archive[editar]
This is the archive of dump analysis.
April 23, 2007
April 09, 2007
March 29, 2007
February 9, 2007
December 24, 2006

ak:User:ReyBrujo/Dumps