Wikipedysta:ReyBrujo/Dumps
April 30, 2007[edytuj | edytuj kod]
External link dumps[edytuj | edytuj kod]
| Dump table | Hits |
|---|---|
| Articles with more than 50 external links | 78 |
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[edytuj | edytuj kod]
| Dump table | Hits |
|---|---|
| Sites linked more than 50 times | 252 |
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[edytuj | edytuj kod]
Some more information about this dump:
- 375565 articles that are in the main space and not redirects
- 472142 articles and redirects in the main space
- 622967 pages in all namespaces
- 100976 redirects in all namespaces
- 877490 external links in every namespace
- 685585 external links in the main space
Very probable spambot pages[edytuj | edytuj kod]
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 |
|---|
Possible spambot pages[edytuj | edytuj kod]
Possible pages created by spambots ending with /.
| Article ID | Article |
|---|---|
| 638278 | / |
| 379900 | KOT/ |
| 303124 | Z/ |
| 276349 | User:Beno02/Brudnopis/ |
| 904147 | User:Brohacz/Userboxy/ |
| 91825 | User:Dax/ |
| 732413 | User:Dragonslayer/ |
| 849174 | User:Eteru/ |
| 565342 | User:Holek/userboksy/ |
| 498593 | User:Kotek1986/brudnopis/ |
| 451685 | User:Kpjas/ |
| 759140 | User:Matyt/English/FA/ |
| 680445 | User:Mfloryan/userboxy/ |
| 678398 | User:Nowis/brudnopis/ |
| 631486 | User talk:Kpjas/ |
| 498433 | Wikipedia:Grafika na medal - Biurowiec/ |
| 413958 | Wikipedia:Warsztat graficzny/ |
| 839286 | Wikipedia:Wieża Specjalności/Głosowania/ |
| 684987 | Wikipedia:Wikipedystów portret własny/ |
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 '%/';
Dump analysis archive[edytuj | edytuj kod]
This is the archive of dump analysis.