User:Topbanana/Reports/An acronym link is suggested

Overview
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
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
This report is generated from a Link Analysis Database using the SQL:

select concat( '*', abbr.art_title, ' &rarr; ', 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

 * 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
List removed, hideously out of date. - TB 18:00, 31 December 2005 (UTC)