আতাকুরা:ReyBrujo/Dumps/20070207
মুক্ত বিশ্বকোষ উইকিপিডিয়াত্ত
Dumps
মেথেল |
[পতিক] February 07, 2007
[পতিক] External link dumps
Articles with more than 6 external links as of February 07, 2007. Only articles in the main space are considered.
| External links |
Article ID | Article |
|---|---|---|
| 251 | 19087 | উইকিপিডিয়ার তালিকাহান নিবন্ধর মাতুঙে |
| 31 | 56 | বিজ্ঞান |
| 18 | 4707 | গ্রেগরিয়ান পাঞ্জী |
| 17 | 1598 | মার্লোন ব্র্যান্ডো |
| 17 | 9 | গনিত |
| 12 | 8 | কলা |
| 11 | 20437 | ওসলো |
| 9 | 1619 | বিষ্ণুপ্রিয়া মণিপুরী |
| 8 | 9294 | কমলগঞ্জ |
| 7 | 19101 | Bpm |
| 7 | 1642 | পয়লা পাতা |
| 6 | 20069 | আলাবামা |
| 6 | 2324 | রায়গঞ্জ |
| 6 | 20309 | আন্দামান বারো নিকোবর দ্বীপমালা |
| 6 | 17267 | হাৱাই কাউন্টি, হাৱাই |
| 6 | 20104 | নিউ ইয়র্ক |
| 6 | 20284 | তামিল নাড়ু |
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 6 times as of February 07, 2007. Only articles in the main space are considered.
| Link count | Site |
|---|---|
| 12238 | http://bpy.wikipedia.org |
| 8212 | http://tools.wikimedia.de |
| 6407 | http://www.census.gov |
| 5048 | http://web.archive.org |
| 2455 | http://www.fallingrain.com |
| 883 | http://www.ssb.no |
| 542 | http://www.bangladeshgov.org |
| 74 | http://www.cbs.gov.np |
| 51 | http://erg.usgs.gov |
| 20 | http://www.censusindia.net |
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:
- 12300 articles that are in the main space and not redirects
- 12318 articles and redirects in the main space
- 19392 pages in all namespaces
- 25 redirects in all namespaces
- 38599 external links in every namespace
- 36847 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 '%/';

