Wikipedia:WikiProject Interlanguage Links/reciprocal

Overview
Where an interlanguage link exists in one direction between 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.

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;

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.