Wikipedia:WikiProject Interlanguage Links/bad target: Difference between revisions

Revision as of 15:16, 20 August 2007

Revision as of 16:04, 26 August 2007

Line 1:

==DefinitionOverview==

Unlink normal [[Wikipedia:link|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.

A 'link to a page which does not exist' is (within this project) defined by the logic:

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==

Follow the general project [[Wikipedia:WikiProject Interlanguage Links/Scripts|script]], the use the SQL statement below to identify links to articles that don't exist:

<pre>

where// A:XInterlanguage links to B:Ypages that do not exist

// en -> fr only, modify as appropriate

and A:X is an article in the main namespace

INSERT INTO suggestions

and B:Y does not exist in any namespace

SELECT a.from_lang, a.from_title, a.to_lang, a.to_title

then imply

FROM inter a

A:X should not link to A:X

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

</pre>