Jump to content

User:Topbanana/Reports/An acronym link is suggested

From Wikipedia, the free encyclopedia

Overview

[edit]

The list below shows articles to which acronym pages could perhaps link. It was generated on 9th August 2004 from the 2nd August 2004 database dump.


Preamble

[edit]

Acronym pages provide disambiguating links to relevant articles. The list below shows articles which have names that might be abbreviated as a given acronym, but which are not (yet) linked to from the acronym page. Check and add any appropriate articles to the acronym page.


Regenerating this report

[edit]

This report is generated from a Link Analysis Database using the SQL:

select concat( '*[[', abbr.art_title, ']] → ', group_concat( concat( '[[', poss.art_title, ']]' ) ), ' ?'  )
into outfile 'c:\out.txt'
from art abbr, art poss LEFT OUTER JOIN good_links ON from_id = abbr.art_id AND to_id = poss.art_id
where Length( abbr.art_title ) = 3
and mid( abbr.art_title, 1, 1 ) between 'A' and 'Z'
and mid( abbr.art_title, 2, 1 ) between 'A' and 'Z'
and mid( abbr.art_title, 3, 1 ) between 'A' and 'Z'
and abbr.art_is_disambig = 1
and poss.art_is_redirect = 0
and poss.art_is_disambig = 0
and poss.art_title LIKE concat( mid( abbr.art_title, 1, 1 ), '%\_', mid( abbr.art_title, 2, 1 ), '%\_', mid( abbr.art_title, 3, 1 ), '_%' )
and length( poss.art_title) - length( replace( poss.art_title, '_', '' )) = 2
GROUP BY abbr.art_title;

This statement only checks three-letter acronyms. If two or four-letter acronyms are required, adjust accordingly.

Suggested improvements

[edit]
  • Eliminate towns/cities as they are rarely referred to using a TLA. Perhaps, ignoring articles with commas in the title might do the trick? RedWolf 22:11, Aug 9, 2004 (UTC)
    • Perhaps just ignore parts of name after commas; towns and cities with a three word name might well be referred to by a TLA. Warofdreams 12:11, 19 Aug 2004 (UTC)
  • Suppress suggestions for articles with colons in their title - the link analysis database is very bad at matching these. - TB 09:47, Aug 10, 2004 (UTC)
  • Suppress items where the first word is "The" -- Picapica 13:39, 19 Aug 2004 (UTC)
  • Are you also checking absent (red) acronym page for possible content enabling us to start them?

List

[edit]

List removed, hideously out of date. - TB 18:00, 31 December 2005 (UTC)