ca galfi la'e lu pilno:ReyBrujo/Dumps/20070227 li'u

{{User:ReyBrujo/Styles/Header|pg=User:ReyBrujo/Dumps/20070227|title=Dumps}}

==February 27, 2007==
===External link dumps===
Articles with more than 2 external links as of February 27, 2007. Only articles in the main space are considered.

{| class="wikitable"
|-
! External<br />links !! Article ID !! Article
|-
| 5 || 1 || [[ralju ckupau]]
|-
| 4 || 1834 || [[klutiksi'o pe le sezga'o]]
|-
| 4 || 3117 || [[marna mentikxu'i]]
|-
| 4 || 2002 || [[vulfygan.amadeus.motsart]]
|-
| 3 || 1225 || [[Cmima le'i bangu]]
|-
| 3 || 75 || [[cmima le'i bangu]]
|-
| 2 || 94 || [[kampidjip.]]
|-
| 2 || 1953 || [[bangrklingo]]
|-
| 2 || 2327 || [[konstantinupol]]
|-
| 2 || 1174 || [[musyjda]]
|-
| 2 || 2621 || [[ponbau]]
|-
| 2 || 3003 || [[uesnot]]
|-
| 2 || 3287 || [[la nicte cadzu]]
|-
| 2 || 2418 || [[deivid.pekinpas]]
|-
| 2 || 120 || [[varadinum]]
|-
| 2 || 124 || [[esperant]]
|}

<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 2 times as of February 27, 2007. Only articles in the main space are considered.

{| class="wikitable"
|-
! Link count !! Site
|-
| 407 || <nowiki>http://jbo.wikipedia.org</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:
* 514 articles that are in the main space and not redirects
* 911 articles and redirects in the main space
* 1761 pages in all namespaces
* 542 redirects in all namespaces
* 611 external links in every namespace
* 430 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
|-
| 2966 || [[MediaWiki talk:Ipb expiry invalid/w/index.php]]
|}

===Possible spambot pages===
Possible pages created by spambots ending with /.

{|class="wikitable"
! Article ID !! Article
|}

<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}}