Wikipedia:WikiProject Interlanguage Links/induction

Overview
Most Wikipedia languages will end up with articles cover very similar ground. As a result, interlanguage links tend to form 'groups' which can be propagated between Wikipedia instaces. To give an example the articles en:red, fr:rouge, de:rot, ar:أحمربي and ja:赤 all link to each other. It is reasonable therefore to assume that an article which contains an interlanguage link to one of these should probably link to them all.

For want of a better description, I've decided to call the supposed missing interlanguage links induced links.

For each entry on the lists linked below, inspect the 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:

// Identify induced links. // Where S -> A -> T and S -> B -> T and not( S -> T ) and not ( T -> S ) then imply S -> T // NB; this deliberatly does not include reciprocal links // NB; takes a day to run when fully indexed! SELECT sa.from_lang, sa.from_title, at.to_lang, at.to_title FROM inter sa INNER JOIN inter at ON at.from_lang = sa.to_lang AND at.from_title = sa.from_title AND at.to_lang != sa.from_lang INNER JOIN inter sb ON sb.from_lang = sa.from_lang AND sb.from_title = sa.from_title AND sb.to_lang != sa.to_lang INNER JOIN inter bt ON bt.from_lang = sb.to_lang AND bt.from_title = sb.from_title AND bt.to_lang = at.to_lang AND bt.to_title = at.to_title LEFT OUTER JOIN inter st ON st.from_lang = sa.from_lang AND st.from_title = sa.from_title AND st.to_lang = at.to_lang LEFT OUTER JOIN inter ts ON ts.from_lang = at.to_lang AND ts.from_title = at.to_title AND ts.to_lang = sa.from_lang AND ts.to_title = sa.from_title WHERE st.from_title IS NULL AND  ts.from_title IS NULL AND  at.to_lang IN ( 'en','de','es','fr','it','nl','ja','pl','pt','sv' ) AND  sa.from_lang IN ( 'en','de','es','fr','it','nl','ja','pl','pt','sv' )

Results
The results below were generated in August 2007, from the most recently available database dump for each language.