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

Revision as of 15:16, 20 August 2007

Latest revision as of 23:41, 31 October 2010

(5 intermediate revisions by the same user not shown)

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 - that is, interlanguage links that would appear red if the [[Mediawiki]] software on which wikipedia runs supported this.

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]], then 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>

Line 14 ⟶ 29:

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.

<!-- {{Template:WikiProject Interlanguage Links/Language grid|title=Interlanguage red links}} -->

{| class="wikitable"

|+Suggested reciprocal links

|-

! colspan="2" rowspan="2" | &nbsp;

! colspan="10" | from

|-

| en

| de

| es

| fr

| it

| nl

| ja

| pl

| pt

| sv

|-

! rowspan="10" | to

| en

| &nbsp;

| -

| -

| -

| -

| -

| -

| -

| -

| -

|-

| de

| [[/en/de|X]]

| &nbsp;

| -

| -

| -

| -

| -

| -

| -

| -

|-

| es

| [[/en/es|X]]

| -

| &nbsp;

| -

| -

| -

| -

| -

| -

| -

|-

| fr

| [[/en/fr|X]]

| -

| -

| &nbsp;

| -

| -

| -

| -

| -

| -

|-

| it

| [[/en/it|X]]

| -

| -

| -

| &nbsp;

| -

| -

| -

| -

| -

|-

| nl

| [[/en/nl|X]]

| -

| -

| -

| -

| &nbsp;

| -

| -

| -

| -

|-

| ja

| [[/en/ja|X]]

| -

| -

| -

| -

| -

| &nbsp;

| -

| -

| -

|-

| pl

| [[/en/pl|X]]

| -

| -

| -

| -

| -

| -

| &nbsp;

| -

| -

|-

| pt

| [[/en/pt|X]]

| -

| -

| -

| -

| -

| -

| -

| &nbsp;

| -

|-

| sv

| [[/en/sv|X]]

| -

| -

| -

| -

| -

| -

| -

| -

| &nbsp;

|}