User:Topbanana/Reports/An abbreviation expansion is suggested

Overview
The list below shows articles whose titles contain commonly abbreviations or abbreviated terms. It was generated on 25th August 2004 from the 18th August 2004 database dump.

Preamble
Many words such as 'incorporated' are abbreviated (here, to 'inc.'). Where this is done it's often a good idea to use a redirect page to allow the other form of the word to be used to find the article as well. Consider moving the articles below or creating new redirect pages to them.

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

CREATE TABLE IF NOT EXISTS alt ( alt1 varchar(255) binary NOT NULL,  alt2 varchar(255) binary NOT NULL,  PRIMARY KEY (  alt1, alt2 ) ) ENGINE=MyISAM;

REPLACE INTO alt VALUES ( 'Co.', 'Company' ); REPLACE INTO alt VALUES ( 'Inc.', 'Incorporated' ); REPLACE INTO alt VALUES ( 'Corp.', 'Corporation' ); REPLACE INTO alt VALUES ( 'Ltd.', 'Limited' );

SELECT concat( '*', concat( left( a1.art_title, locate( alt.alt1, a1.art_title ) - 1 ), alt.alt2 ), ' &rarr ', a1.art_title, '' ) FROM art a1, alt LEFT OUTER JOIN art a2 ON a2.art_title = concat( left( a1.art_title, locate( alt.alt1, a1.art_title ) - 1 ), alt.alt2 ) WHERE locate( alt.alt1, a1.art_title ) > 0 AND a2.art_title IS NULL;

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

Suggested improvements

 * Report does not properly handle abbreviations in the middle of an article title.
 * Report doesn't handle multiple abbreviations on a single title.
 * Doesn't check if target is a redirect page
 * Doesn't handled commas before abbreviations in company titles well.

List
 For now this report only deals with the few abbreviations listed in the SQL statement above, and only delas with expansions of abbreviated article titles.

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