Open main menu
Dumps

April 22, 2007Edit

External link dumpsEdit

Dump table Hits
Articles with more than 50 external links 228
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 rankingEdit

Dump table Hits
Sites linked more than 50 times 145
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 informationEdit

Some more information about this dump:

  • 10265 articles that are in the main space and not redirects
  • 13534 articles and redirects in the main space
  • 51789 pages in all namespaces
  • 6550 redirects in all namespaces
  • 172576 external links in every namespace
  • 80447 external links in the main space

Very probable spambot pagesEdit

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
62945 Removing index.php from the URL
29728 Talk:Eliminating index.php from the url
52643 Talk:Eliminating index.php from the url/Sy's mod rewrite rules

Possible spambot pagesEdit

Possible pages created by spambots ending with /.

Article ID Article
38836 Ca/emaf/
18806 Garybrimley/Bezoekers via artikel de Standaard/
34067 Share watchlists/2005 Dec 03 irc log/
21318 Translation requests/WQ/3/En/
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 '%/';
Archive

Dump analysis archiveEdit

This is the archive of dump analysis.