User:Topbanana/Reports/An interwiki link is suggested

Overview
The list below shows suggested interwiki links. It was generated on the 3rd August 2004 from the 26th July 2004 database dump.

Preamble
Interwiki links connect articles covering more or less the same topic in different languages. This is one of the most unique features of Wikipedia, as many interwiki links as possible should exist.

Suggested improvements

 * Need to check that the 'en' article actually exists and move entries for which it doesn't to a separate list. - TB 10:13, Jun 9, 2004 (UTC)
 * Doesn't handle the escaping of HTML characters in external links properly. This can lead to the foreign language link ending up on a non-existant article page.  - TB 10:13, Jun 9, 2004 (UTC)
 * Need to work out a way of sensibly generating this for all language combinations, and to place lists of suggestions where other-langauge wikipedians will find them. - TB 10:20, Jun 9, 2004 (UTC)
 * Problems with links to article sections - see "Coffeeshop#Cannabis_coffee_shops &#8594; de:Coffee_Shop (http://de.wikipedia.org/wiki/Coffee_Shop)"
 * Could perhaps try to group suggestions for links from each en artcile to many languages to save on editing time. - TB 07:43, Jun 15, 2004 (UTC)
 * Should filter out interwiki links to redirect pages, where the final target contains the link back. andy 19:00, 16 Jun 2004 (UTC)
 * Should also find pages with exactly same title but no interwiki on either side yet, this would mostly cover names. andy 18:02, 17 Jun 2004 (UTC)
 * This will be a separate report - "interwiki deductions". - TB 09:00, Aug 6, 2004 (UTC)

Link inductions
A:X &rarr; B:X &rarr; C:X, suggest A:X &rarr; C:X where no link to C exists from A:X

SELECT concat( '*', A.from_lang, ':', A.from_title, ' &rarr; ', B.to_lang, ':', B.to_title, ' ?' ) INTO OUTFILE 'out.txt' FROM link2 A INNER JOIN link2 B ON A.to_lang = B.from_lang AND A.to_title = B.from_title AND B.to_lang <> A.from_lang LEFT OUTER JOIN link2 C ON C.from_lang = A.from_lang AND C.from_title = A.from_title AND C.to_lang = B.to_lang WHERE C.from_lang IS NULL

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