Дольник:ReyBrujo/Dumps

С Сибирска Википеддя
< Дольник:ReyBrujo
Revision as of 19:54, 28 Светня 2007 by *>ReyBrujo (Fixes)
Айдать на коробушку Айдать на сыскальник
Dumps

April 20, 2007

External link dumps

Articles with more than 5 external links as of April 20, 2007. Only articles in the main space are considered.

External
links
Article ID Article
28 11819 Вьюрок: Грудень 2006
22 12965 Трубецки
19 12447 Вьюрок: Лютень 2007
17 1357 Дания
15 1765 Украинской говор
14 11 Википеддя:Пристанишше пустолаев
13 12968 The Flowers of Romance
10 12758 Ayerbe
9 12413 Вьюрок Конец 2006
8 12759 Россейска Википеддя
5 1364 Державна Хвалопесня Украины
5 12009 Яроврат
5 11376 Civilization
5 11384 BBMMORPG
5 12848 Едвар Григов
5 1562 Народознайсво
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

Sites linked more than 5 times as of April 20, 2007. Only articles in the main space are considered.

Link count Site
251 http://www.iana.org
63 http://ru-sib.wikipedia.org
23 http://meta.wikimedia.org
20 http://geo.web.ru
18 http://volgota.com
13 http://ru.wikipedia.org
11 http://users.livejournal.com
7 http://en.wikipedia.org
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:

  • 7414 articles that are in the main space and not redirects
  • 8249 articles and redirects in the main space
  • 9978 pages in all namespaces
  • 907 redirects in all namespaces
  • 1067 external links in every namespace
  • 662 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

Possible spambot pages

Possible pages created by spambots ending with /.

Article ID Article
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 archive

This is the archive of dump analysis.

aa:User:ReyBrujo/Dumps ab:User:ReyBrujo/Dumps af:User:ReyBrujo/Dumps ak:User:ReyBrujo/Dumps als:User:ReyBrujo/Dumps am:User:ReyBrujo/Dumps ang:User:ReyBrujo/Dumps an:User:ReyBrujo/Dumps arc:User:ReyBrujo/Dumps ar:User:ReyBrujo/Dumps ast:User:ReyBrujo/Dumps as:User:ReyBrujo/Dumps av:User:ReyBrujo/Dumps ay:User:ReyBrujo/Dumps az:User:ReyBrujo/Dumps bar:User:ReyBrujo/Dumps bat-smg:User:ReyBrujo/Dumps ba:User:ReyBrujo/Dumps be:User:ReyBrujo/Dumps bg:User:ReyBrujo/Dumps bh:User:ReyBrujo/Dumps bi:User:ReyBrujo/Dumps bm:User:ReyBrujo/Dumps bn:User:ReyBrujo/Dumps bo:User:ReyBrujo/Dumps bpy:User:ReyBrujo/Dumps br:User:ReyBrujo/Dumps bs:User:ReyBrujo/Dumps bug:User:ReyBrujo/Dumps bxr:User:ReyBrujo/Dumps ca:User:ReyBrujo/Dumps cbk-zam:User:ReyBrujo/Dumps cdo:User:ReyBrujo/Dumps ceb:User:ReyBrujo/Dumps ce:User:ReyBrujo/Dumps cho:User:ReyBrujo/Dumps chr:User:ReyBrujo/Dumps ch:User:ReyBrujo/Dumps chy:User:ReyBrujo/Dumps co:User:ReyBrujo/Dumps cr:User:ReyBrujo/Dumps csb:User:ReyBrujo/Dumps cs:User:ReyBrujo/Dumps cu:User:ReyBrujo/Dumps cv:User:ReyBrujo/Dumps cy:User:ReyBrujo/Dumps da:User:ReyBrujo/Dumps de:User:ReyBrujo/Dumps diq:User:ReyBrujo/Dumps dv:User:ReyBrujo/Dumps dz:User:ReyBrujo/Dumps ee:User:ReyBrujo/Dumps el:User:ReyBrujo/Dumps eml:User:ReyBrujo/Dumps en:User:ReyBrujo/Dumps eo:User:ReyBrujo/Dumps es:User:ReyBrujo/Dumps et:User:ReyBrujo/Dumps eu:User:ReyBrujo/Dumps fa:User:ReyBrujo/Dumps ff:User:ReyBrujo/Dumps fi:User:ReyBrujo/Dumps fiu-vro:User:ReyBrujo/Dumps fj:User:ReyBrujo/Dumps fo:User:ReyBrujo/Dumps frp:User:ReyBrujo/Dumps fr:User:ReyBrujo/Dumps fur:User:ReyBrujo/Dumps fy:User:ReyBrujo/Dumps ga:User:ReyBrujo/Dumps gd:User:ReyBrujo/Dumps glk:User:ReyBrujo/Dumps gl:User:ReyBrujo/Dumps gn:User:ReyBrujo/Dumps got:User:ReyBrujo/Dumps gu:User:ReyBrujo/Dumps gv:User:ReyBrujo/Dumps ha:User:ReyBrujo/Dumps haw:User:ReyBrujo/Dumps he:User:ReyBrujo/Dumps hi:User:ReyBrujo/Dumps ho:User:ReyBrujo/Dumps hr:User:ReyBrujo/Dumps hsb:User:ReyBrujo/Dumps ht:User:ReyBrujo/Dumps hu:User:ReyBrujo/Dumps hy:User:ReyBrujo/Dumps hz:User:ReyBrujo/Dumps ia:User:ReyBrujo/Dumps id:User:ReyBrujo/Dumps ie:User:ReyBrujo/Dumps ig:User:ReyBrujo/Dumps ii:User:ReyBrujo/Dumps ik:User:ReyBrujo/Dumps ilo:User:ReyBrujo/Dumps io:User:ReyBrujo/Dumps is:User:ReyBrujo/Dumps it:User:ReyBrujo/Dumps iu:User:ReyBrujo/Dumps ja:User:ReyBrujo/Dumps jbo:User:ReyBrujo/Dumps jv:User:ReyBrujo/Dumps ka:User:ReyBrujo/Dumps kg:User:ReyBrujo/Dumps ki:User:ReyBrujo/Dumps kj:User:ReyBrujo/Dumps kk:User:ReyBrujo/Dumps kl:User:ReyBrujo/Dumps km:User:ReyBrujo/Dumps kn:User:ReyBrujo/Dumps ko:User:ReyBrujo/Dumps kr:User:ReyBrujo/Dumps ksh:User:ReyBrujo/Dumps ks:User:ReyBrujo/Dumps ku:User:ReyBrujo/Dumps kv:User:ReyBrujo/Dumps kw:User:ReyBrujo/Dumps ky:User:ReyBrujo/Dumps lad:User:ReyBrujo/Dumps la:User:ReyBrujo/Dumps lbe:User:ReyBrujo/Dumps lb:User:ReyBrujo/Dumps lg:User:ReyBrujo/Dumps lij:User:ReyBrujo/Dumps li:User:ReyBrujo/Dumps lmo:User:ReyBrujo/Dumps ln:User:ReyBrujo/Dumps lo:User:ReyBrujo/Dumps lt:User:ReyBrujo/Dumps lv:User:ReyBrujo/Dumps map-bms:User:ReyBrujo/Dumps mg:User:ReyBrujo/Dumps mh:User:ReyBrujo/Dumps mi:User:ReyBrujo/Dumps mk:User:ReyBrujo/Dumps ml:User:ReyBrujo/Dumps mn:User:ReyBrujo/Dumps mr:User:ReyBrujo/Dumps ms:User:ReyBrujo/Dumps mt:User:ReyBrujo/Dumps mus:User:ReyBrujo/Dumps my:User:ReyBrujo/Dumps mzn:User:ReyBrujo/Dumps nah:User:ReyBrujo/Dumps nap:User:ReyBrujo/Dumps na:User:ReyBrujo/Dumps nds-nl:User:ReyBrujo/Dumps nds:User:ReyBrujo/Dumps ne:User:ReyBrujo/Dumps new:User:ReyBrujo/Dumps ng:User:ReyBrujo/Dumps nl:User:ReyBrujo/Dumps nn:User:ReyBrujo/Dumps no:User:ReyBrujo/Dumps nov:User:ReyBrujo/Dumps nrm:User:ReyBrujo/Dumps nv:User:ReyBrujo/Dumps ny:User:ReyBrujo/Dumps oc:User:ReyBrujo/Dumps om:User:ReyBrujo/Dumps or:User:ReyBrujo/Dumps os:User:ReyBrujo/Dumps pag:User:ReyBrujo/Dumps pam:User:ReyBrujo/Dumps pap:User:ReyBrujo/Dumps pa:User:ReyBrujo/Dumps pdc:User:ReyBrujo/Dumps pih:User:ReyBrujo/Dumps pi:User:ReyBrujo/Dumps pl:User:ReyBrujo/Dumps pms:User:ReyBrujo/Dumps ps:User:ReyBrujo/Dumps pt:User:ReyBrujo/Dumps qu:User:ReyBrujo/Dumps rm:User:ReyBrujo/Dumps rmy:User:ReyBrujo/Dumps rn:User:ReyBrujo/Dumps roa-rup:User:ReyBrujo/Dumps roa-tara:User:ReyBrujo/Dumps ro:User:ReyBrujo/Dumps ru:User:ReyBrujo/Dumps rw:User:ReyBrujo/Dumps sa:User:ReyBrujo/Dumps scn:User:ReyBrujo/Dumps sco:User:ReyBrujo/Dumps sc:User:ReyBrujo/Dumps sd:User:ReyBrujo/Dumps se:User:ReyBrujo/Dumps sg:User:ReyBrujo/Dumps sh:User:ReyBrujo/Dumps simple:User:ReyBrujo/Dumps si:User:ReyBrujo/Dumps sk:User:ReyBrujo/Dumps sl:User:ReyBrujo/Dumps sm:User:ReyBrujo/Dumps sn:User:ReyBrujo/Dumps so:User:ReyBrujo/Dumps sq:User:ReyBrujo/Dumps sr:User:ReyBrujo/Dumps ss:User:ReyBrujo/Dumps st:User:ReyBrujo/Dumps su:User:ReyBrujo/Dumps sv:User:ReyBrujo/Dumps sw:User:ReyBrujo/Dumps ta:User:ReyBrujo/Dumps tet:User:ReyBrujo/Dumps te:User:ReyBrujo/Dumps tg:User:ReyBrujo/Dumps th:User:ReyBrujo/Dumps ti:User:ReyBrujo/Dumps tk:User:ReyBrujo/Dumps tl:User:ReyBrujo/Dumps tn:User:ReyBrujo/Dumps to:User:ReyBrujo/Dumps tpi:User:ReyBrujo/Dumps tr:User:ReyBrujo/Dumps ts:User:ReyBrujo/Dumps tt:User:ReyBrujo/Dumps tum:User:ReyBrujo/Dumps tw:User:ReyBrujo/Dumps ty:User:ReyBrujo/Dumps udm:User:ReyBrujo/Dumps ug:User:ReyBrujo/Dumps uk:User:ReyBrujo/Dumps ur:User:ReyBrujo/Dumps uz:User:ReyBrujo/Dumps vec:User:ReyBrujo/Dumps ve:User:ReyBrujo/Dumps vi:User:ReyBrujo/Dumps vls:User:ReyBrujo/Dumps vo:User:ReyBrujo/Dumps war:User:ReyBrujo/Dumps wa:User:ReyBrujo/Dumps wo:User:ReyBrujo/Dumps wuu:User:ReyBrujo/Dumps xal:User:ReyBrujo/Dumps xh:User:ReyBrujo/Dumps yi:User:ReyBrujo/Dumps yo:User:ReyBrujo/Dumps za:User:ReyBrujo/Dumps zea:User:ReyBrujo/Dumps zh-classical:User:ReyBrujo/Dumps zh-min-nan:User:ReyBrujo/Dumps zh:User:ReyBrujo/Dumps zh-yue:User:ReyBrujo/Dumps zu:User:ReyBrujo/Dumps