Wikipedia:WikiProject Interlanguage Links/reciprocal

From Wikipedia, the free encyclopedia

[edit] Overview

Where an interlanguage link exists in one direction betwen two wikipedia articles, it is reasonable to assume that it should exist in the other direction. For want of a better term, I've decided to call this a reciprocal link.

Of course, it's not always the case that a reciprocal link should exist; perhaps separate articles exist in one wikipedia about, say, differing types of teapot. Another wikipedia may have just one article covering all the same material. In this case, it might make sense for each of the articles in the first wikipedia to contain an interlanguage link to that in the second, but it makes no sense for the single article in the second wikipedia to link to any one of the articles in the first. A better solution might be for it to link back to a more general page on the subject.

For each entry on the lists linked below, inspect both articles. If appropriate, add the suggested reciprocal interlanguage link.

[edit] Regenerating this report

Follow the general project script, then use the SQL statement below to identify links to articles that don't exist:

// suggested reciprocal links
// a:x -> b:x and b:x exists and no link from b:? to a:x exists => b:x -> a:x
// As shown this generates reciprocal links from en back to another language, adjust as appropriate
INSERT INTO suggestions
SELECT a.to_lang, a.to_title, a.from_lang, a.from_title
FROM inter a
INNER JOIN en.page p
    ON p.page_title = a.to_title
    AND p.page_namespace = 0
    AND p.page_is_redirect = 0
LEFT JOIN inter b
    ON   b.from_lang = a.to_lang
    AND  b.from_title = a.to_title     
    AND  b.to_lang = a.from_lang
WHERE a.from_lang IN ('de','es','fr','it','nl','ja','pl','pt','sv' )
AND   a.to_lang = 'en'
AND   b.from_lang IS NULL;

[edit] Results

The results below were generated in August 2007, from the most recently available database dump for each language. Until the worst of the rough edges of this process have been smoothed off, I'm only considering links from the english wikipedia to the next 9 largest in size.

Suggested reciprocal links

		from
		en	de	es	fr	it	nl	ja	pl	pt	sv
to	en		X	X	X	X	X	X	X	X	X
	de	X		X	X	X	X	X	X	X	X
	es	X	X		X	X	X	X	X	X	X
	fr	X	X	X		X	X	X	X	X	X
	it	X	X	X	X		X	X	X	X	X
	nl	X	X	X	X	X		X	X	X	X
	ja	X	X	X	X	X	X		X	X	X
	pl	X	X	X	X	X	X	X		X	X
	pt	X	X	X	X	X	X	X	X		X
	sv	X	X	X	X	X	X	X	X	X