Ongerscheide zwesche Versione vun dä Sigg „Metmaacher:ReyBrujo/Dumps/20070227“
Inhalt gelöscht Inhalt hinzugefügt
ReyBrujo (Klaaf · Beijdrähsch) Updating |
ReyBrujo (Klaaf · Beijdrähsch) Fixing report |
||
Reih 27:
| 13 || 10546 || [[De Simsens]]
|-
| 12 || 10295 || [[Pooz:Weßßeschaaf & Teschnigk]]
|-
| 12 || 10425 || [[Relativitätstheorie]]
|-
| 11 || 12704 || [[Düsseldorf-Vennhausen]]
|-
| 10 || 8510 || [[Rhingland-Pallz]]
|-
| 10 || 10484 || [[Houpsigk/Wikimedia4]]
|}
<pre>
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;
</pre>
===External link ranking===
Sites linked more than 10 times as of February 27, 2007. Only articles in the main space are considered.
{| class="wikitable"
|-
! Link count !! Site
|-
| 4391 || <nowiki>http://ksh.wikipedia.org</nowiki>
|-
| 152 || <nowiki>http://www.koelnerkarneval.de</nowiki>
|-
| 40 || <nowiki>http://www.iana.org</nowiki>
|-
| 30 || <nowiki>http://www.nba.com</nowiki>
|-
| 21 || <nowiki>http://dispatch.opac.ddb.de</nowiki>
|-
| 16 || <nowiki>http://de.wikipedia.org</nowiki>
|-
| 16 || <nowiki>http://www.nikuta.de</nowiki>
|-
| 12 || <nowiki>http://www.stadt-koeln.de</nowiki>
|}
<pre>
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;
</pre>
===Additional information===
Some more information about this dump:
* 6011 articles that are in the main space and not redirects
* 134765 articles and redirects in the main space
* 137747 pages in all namespaces
* 128953 redirects in all namespaces
* 26131 external links in every namespace
* 5316 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.
{| class="wikitable"
! Article ID !! Article
|}
===Possible spambot pages===
Possible pages created by spambots ending with /.
{|class="wikitable"
! Article ID !! Article
|-
| 6398 || [[Houpsigk/]]
|-
| 12251 || [[Pooz:Eßße & Drinke/]]
|-
| 12253 || [[Pooz:Kulltur/]]
|-
| 12252 || [[Pooz:Rhingland/]]
|-
| 11828 || [[Pooz:Weßßeschaaf & Teschnigk/]]
|-
| 13292 || [[Wenker Säz/]]
|-
| 13048 || [[User talk:Purodha/]]
|}
<pre>
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 '%/';
</pre>
{{User:ReyBrujo/Styles/Footer}}
| |||