Úsáideoir:ReyBrujo/Dumps/20070224
Ón Vicipéid, an chiclipéid shaor.
Dumps
Clár ábhair |
[athraigh] February 24, 2007
[athraigh] External link dumps
Articles with more than 10 external links as of February 24, 2007. Only articles in the main space are considered.
| External links |
Article ID | Article |
|---|---|---|
| 40 | 2448 | Drámaíocht Éireannach |
| 35 | 2630 | Sroicheann an Wikipedia/Vicipéid Miliún Alt |
| 27 | 2775 | Ailtireacht |
| 25 | 4729 | An Pholainn |
| 15 | 7324 | Ceiltigh Ghlaschú |
| 15 | 2311 | Ceimic |
| 12 | 12020 | Oideachas trí mheán an Bhéarla |
| 12 | 12304 | Baile na gCailleach |
| 12 | 3968 | An Bodach |
| 11 | 5715 | George Orwell |
| 11 | 2661 | Gaeilge na hAlban |
| 11 | 2773 | Teanga (cumarsáid) |
| 11 | 2760 | An Nollaig |
| 10 | 5849 | An Saighdeoir |
| 10 | 8539 | Cadhc |
| 10 | 8551 | Cumann Lúthchleas Gael |
| 10 | 11643 | Bunscoil an Iúir |
| 10 | 3314 | Albain |
| 10 | 3163 | Craolachán |
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;
[athraigh] External link ranking
Sites linked more than 10 times as of February 24, 2007. Only articles in the main space are considered.
| Link count | Site |
|---|---|
| 2251 | http://ga.wikipedia.org |
| 300 | http://kvaleberg.com |
| 210 | http://getamap.ordnancesurvey.co.uk |
| 89 | http://www.coldwater.k12.mi.us |
| 88 | http://homepage.ntlworld.com |
| 88 | http://www.astronomical.org |
| 88 | http://www.dibonsmith.com |
| 88 | http://www.ianridpath.com |
| 87 | http://www.alcyone.de |
| 67 | http://www.allthesky.com |
| 42 | http://www.sil.org |
| 18 | http://www.imdb.com |
| 18 | http://www.gaa.ie |
| 17 | http://www.hoganstand.com |
| 16 | http://europa.eu.int |
| 15 | http://www.rte.ie |
| 15 | http://en.wikipedia.org |
| 11 | http://whitewolf.newcastle.edu.au |
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;
[athraigh] Additional information
Some more information about this dump:
- 4664 articles that are in the main space and not redirects
- 5859 articles and redirects in the main space
- 9294 pages in all namespaces
- 1419 redirects in all namespaces
- 7938 external links in every namespace
- 4678 external links in the main space
[athraigh] 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 |
|---|
[athraigh] Possible spambot pages
Possible pages created by spambots ending with /.
| Article ID | Article |
|---|---|
| 2410 | Íomhá:Broken/ |
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 '%/';

