משתמש:ReyBrujo/Dumps/20070211

מתוך ויקיפדיה, האנציקלופדיה החופשית
קפיצה לניווט קפיצה לחיפוש
Dumps

February 11, 2007[עריכת קוד מקור | עריכה]

External link dumps[עריכת קוד מקור | עריכה]

Dump table Hits
Articles with more than 50 external links 16
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[עריכת קוד מקור | עריכה]

Dump table Hits
Sites linked more than 50 times 105
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[עריכת קוד מקור | עריכה]

Some more information about this dump:

  • 53381 articles that are in the main space and not redirects
  • 91771 articles and redirects in the main space
  • 182388 pages in all namespaces
  • 42681 redirects in all namespaces
  • 119075 external links in every namespace
  • 77372 external links in the main space

Very probable spambot pages[עריכת קוד מקור | עריכה]

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
302613 W/index.php
275221 W/w/index.php
244394 Talk:W/w/index.php

Possible spambot pages[עריכת קוד מקור | עריכה]

Possible pages created by spambots ending with /.

Article ID Article
274221 משתמש:ReyBrujo/Dumps/20070211/
172680 Gangleri/bugzilla/ report / 04045 א ב / a b / / Gangleri/bugzilla/ report / 04045 א ב / a b /
10151 User:Effib/ארגז החול/
32585 User:Effib/תבניות/
7863 User:Neudorf/ארגז החול/
9640 User:Ravell/ארגז החול/
211437 User:דניאל/ארגז חול/
5509 User:מאיר מ/ארגז החול/
11008 User:עדן קוגן/ארגז חול/
9740 User talk:Ravell/ארגז החול/
88020 Template:4x4 type square/
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 '%/';