User:Topbanana/Reports

Howdy.

I've written a number of SQL scripts that generate reports on unusual articles when run against my local copy of the wikipedia database (get your own local copy from [1]). The lists below are infrequently updated, and I'm still fiddling abouty with some of the scripts. Please leave a message on my discussion page if you're interested in running the reports yourself, or would like to suggest a new report or improvement to an existing one.

---

• Database inconsistencies
  • Articles with duplicate titles

• Article text analysis
  • Article lengths
    • Articles which have nothing in them (See also: Wikipedia:List_of_blank_pages)
    • Shortest pages (See also: Wikipedia:Shortpages)
    • Longest pages (See also: Wikipedia:Longpages)
  • Article classification
    • Very short pages that are not marked as stubs
    • Substantial articles that are marked as stubs
    • Disambiguation pages that only contain one link
    • Pages which contain the text of a common MediaWiki message rather than a link to it
      • Pages which contain the text of msg:disambig
      • Pages which contain the text of msg:stub (See also: Wikipedia:List_of_stubs_without_msg)

• Outgoing wikilinks
  • Total wikilink count
    • Pages with no wikilinks (See also: Wikipedia:Deadend_pages)
    • Pages with a very large number of wikilinks
    • Pages on which more than half the wikilinks are broken
  • Working wikilinks
    • Pages with multiple wikilinks to the same article
    • Pages with more than 10 links, none of which are broken
    • Redirect pages that point to other redirect pages
  • Broken wikilinks
    • 100 pages with greatest number of broken links
    • Redirect pages that point to non-existant articles
  • Wikilink text coverage
    • percentage of page text that is an internal link > 50

• Incoming wikilinks
  • Number of internal links to page = 0 (See also: Wikipedia:Orphaned_Articles)
  • Number of internal links to page = 1 and not marked as a stub
  • Articles with greatest number of incoming links (See also: Wikipedia:Most_Referenced_Articles)
  • Stubs with greatest number of incoming links (See also: Wikipedia:Most_wanted_stubs)
  • Disambiguation pages with greatest number of incoming links (See also Wikipedia:Disambiguation pages with links)
  • Redirect pages with greatest number of incoming links
  • Stubs with only one incoming link

• Missing articles
  • Pages that contain the only link to a topic that doesn't exist yet
  • Missing pages with the most incoming links (See also: Wikipedia:Most_wanted_articles)

---