Uporabnik:ReyBrujo/Dumps

Iz Wikipedije, proste enciklopedije
Dumps

April 23, 2007[uredi | uredi kodo]

External link dumps[uredi | uredi kodo]

Dump table Hits
Articles with more than 25 external links 51
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[uredi | uredi kodo]

Dump table Hits
Sites linked more than 25 times 76
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[uredi | uredi kodo]

Some more information about this dump:

  • 46956 articles that are in the main space and not redirects
  • 63797 articles and redirects in the main space
  • 116232 pages in all namespaces
  • 19020 redirects in all namespaces
  • 59336 external links in every namespace
  • 36680 external links in the main space

Very probable spambot pages[uredi | uredi kodo]

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[uredi | uredi kodo]

Possible pages created by spambots ending with /.

Article ID Article
113750 Template:Football squad player/role/
87498 Template:Lts/
98210 Template:Phh:Bralec/
87499 Template talk:Lts/
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[uredi | uredi kodo]

This is the archive of dump analysis.

ak:User:ReyBrujo/Dumps
https://sl.wikipedia.org/wiki/Uporabnik:ReyBrujo/Dumps
sl.wikipedia.org
CC-MAIN-2024-22
116820
application/http; msgtype=response
sha1:A2CDJJYQT7SKKTJTSA4ILQRNNYUEQM7Y
<urn:uuid:3be604cc-914e-4bfd-a05d-38397dd8eca9>
2024-05-18T07:56:28Z
208.80.154.224
text/html
sha1:VGK3RPTMNNHFARJ7AQ2RNYN7ICDQOU2Q
<urn:uuid:0ad9181d-002a-412f-a5f5-a1bf5c6d1865>
https://sl.wikipedia.org/wiki/Uporabnik:ReyBrujo/Dumps
response
<urn:uuid:d3111784-4c56-424f-bde3-3be1777677b8>
isPartOf: CC-MAIN-2024-22
publisher: Common Crawl
description: Wide crawl of the web for May 2024
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-29
software: Apache Nutch 1.19 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.5-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: https://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/