php-deluxe.net - description Topbanana Reports An interwiki link is suggested

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 .

= Preamble =

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. - 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. - 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. - 10:20, Jun 9, 2004 (UTC)

Problems with links to article sections - see Coffeeshop#Cannabis_coffee_shops → 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. - 07:43, Jun 15, 2004 (UTC)

Should filter out interwiki links to redirect pages, where the final target contains the link back. 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. 18:02, 17 Jun 2004 (UTC)

This will be a separate report - interwiki deductions . - 09:00, Aug 6, 2004 (UTC)

= List =

== Link inductions ==

A:X → B:X → C:X, suggest A:X → C:X where no link to C exists from A:X

SELECT concat( * ) 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

=== en → de ===

(relates specially to Quebec)

(relates specially to France)

German article is about both the language and the ethnic group

=== en → fr ===

*[http://en.wikipedia.org/wiki/Scripts Scripts] →