Wikipedia:WikiProject Interlanguage Links/bad target

Overview

edit

Unlink normal wikipedia links, interlangage links always appear blue, even if the target page doesn't exist. The grid below contains lists of interlanguage links that refer to pages that don't exist - that is, interlanguage links that would appear red if the Mediawiki software on which wikipedia runs supported this.

Some links to missing pages may be appropriate - for example if the link is to a page that is expected to be created soon, or one that really should exist. In this case the link should be left as it is. However, normally, only interlanguage links should only exist to pages that exist. Try and find an appropriate target for the faulty link or, if you can;t find one, remove it.

Regenerating this report

edit

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

// Interlanguage links to pages that do not exist
// en -> fr only, modify as appropriate
INSERT INTO suggestions
SELECT a.from_lang, a.from_title, a.to_lang, a.to_title
FROM inter a
INNER JOIN en.page f
    ON f.page_title = a.from_title
    AND f.page_namespace = 0
    AND f.page_is_redirect = 0
LEFT JOIN fr.page t
    ON   t.page_title = a.to_title
        AND  t.page_namespace = 0
WHERE a.from_lang = 'en'
AND   a.to_lang = 'fr'
AND   t.page_title IS NULL

Results

edit

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.