User:ReyBrujo/Dumps/20070409

Dumps

April 09, 2007

edit
edit
Dump table Hits
Articles with more than 50 external links 216
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;
edit
Dump table Hits
Sites linked more than 50 times 141
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

edit

Some more information about this dump:

  • 10178 articles that are in the main space and not redirects
  • 13402 articles and redirects in the main space
  • 51385 pages in all namespaces
  • 6507 redirects in all namespaces
  • 157961 external links in every namespace
  • 78878 external links in the main space

Very probable spambot pages

edit

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
5269 Eliminating index.php from the url
54596 Eliminating index.php from the url/Sy's mod rewrite rules
41098 Emerecu.ukma.kiev.ua/wiki/index.php/ECourseContest2006
43842 Historical Wikipedia pages/w/index.php
62945 Removing index.php from the URL
66527 W/index.php
29728 Talk:Eliminating index.php from the url
52643 Talk:Eliminating index.php from the url/Sy's mod rewrite rules
66483 Talk:W/index.php

Possible spambot pages

edit

Possible pages created by spambots ending with /.

Article ID Article
38836 Ca/emaf/
54660 Election candidates 2006/
18806 Garybrimley/Bezoekers via artikel de Standaard/
37340 [stad infobox]
34067 Share watchlists/2005 Dec 03 irc log/
52494 Test-wp/nov/
21318 Translation requests/WQ/3/En/
49790 Translations/lang/en/
76424 Talk:Documentation:Security/
75431 Talk:Translation requests/PR-1mil/wiki/Talk:Translation requests/PR-1mil/Ru:/
24927 User:AmoVictor/test/
24443 User:Gangleri/tests/4x4 type square/
24444 User:Gangleri/tests/4x4 type square/bug/
24503 User:Gangleri/tests/4x4 type square/methodcolors/
17322 User:Kristaga/
8027 Wikipedia:Broken/
41591 Wikipedia:WikiProject on open proxies/Blacklist/
24457 Template:4x4 type square/
25079 Template:4x4 type square/T/
25077 Template:4x4 type square/T/A/
25013 Template:4x4 type square/T/B/
25021 Template:4x4 type square/T/C/
24809 Template:4x4 type square/T/all/show/
25029 Template:4x4 type square/T/overwrite A/
25032 Template:4x4 type square/T/overwrite B/
25081 Template:4x4 type square/T/overwrite C/
24455 Template:4x4 type square/T/table/
25067 Template:4x4 type square/T/trace/
25039 Template:4x4 type square/table/
38030 Template:GENERICNAMESPACE/
46040 Template:Ifdef/
59764 Template:Lts/
24505 Template:Oldid/
25071 Template:Purge/anchor/
24448 Template:Revid/
25080 Template talk:4x4 type square/T/
25078 Template talk:4x4 type square/T/A/
25014 Template talk:4x4 type square/T/B/
25022 Template talk:4x4 type square/T/C/
25256 Template talk:4x4 type square/T/all/show/
25058 Template talk:4x4 type square/T/overwrite A/
25057 Template talk:4x4 type square/T/overwrite B/
25082 Template talk:4x4 type square/T/overwrite C/
25044 Template talk:4x4 type square/T/table/
25068 Template talk:4x4 type square/T/trace/
46041 Template talk:Ifdef/
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 '%/';