User:Topbanana/Reports/A disambiguation link is suggested

Overview
The list below shows pairs of pages with similar names that are not redirects and which are not linked. It was generated on 4th August 2004 from the 24th July 2004 database dump.

Preamble
Where a number of subjects go by the same or similar names, disambiguation links can help users find the information they are looking for. The list below may highlight cases where and disambiguation link would be useful. If so, add one.

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

SELECT concat( '*', B.art_title, ' &rarr; ', A.art_title, '' ) INTO outfile 'c:\out.txt' FROM art A, art B LEFT OUTER JOIN good_links ON B.art_id = from_id AND A.art_id = to_id WHERE locate( ',_', A.art_title ) > 0 AND B.art_title = left( A.art_title, locate( ',_', A.art_title ) -1 ) AND A.art_is_redirect = 0 AND B.art_is_redirect = 0 AND from_id IS NULL

Suggested improvements
The query needs to take into account the case where a separate disambiguation page has been setup for an article with the main article used by the most common definition. For example, Jasper refers to the mineral but there is also a Jasper (disambiguation) page. There are many examples of this disambiguation method. RedWolf 22:28, Aug 4, 2004 (UTC)

I concur. Here's my take on the logic to do it (sorry I don't know the SQL syntax):
 * For ARTICLE NAME X
 * Does ARTICLE NAME X (disambiguation) exist?
 * If no, end
 * If yes:
 * is ARTICLE NAME Y linked from ARTICLE NAME X (disambiguation)?
 * if no, then add to list of links
 * if yes, end

More or less. It should be do-able. Kevyn 11:43, 19 Aug 2004 (UTC)
 * Thanks for the feedback guys. I agree with the suggestions above and hope to generate 'version 2' of this report in the next week or so. - TB 11:53, Aug 19, 2004 (UTC)

Underscores & spaces
TB, can you fix the script to generate spaces instead of underscores on the final output? Currently, if a page title has a space in it (For example: Addington, Ontario), the script generates the link with underscores instead of spaces (For examle: Addington,_Ontario). WikiMedia automatially translates the underscores in the links to spaces when you click on then them, but the presence of the underscores makes it hard to do a text find on the page in many web browsers. A minor nit, but it would make this page more user-friendly. Kevyn 00:59, 22 Aug 2004 (UTC)

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