Wikipedia:Elenchi generati offline/Proposte interlink en: differenze tra le versioni

Versione delle 14:05, 6 nov 2019

Versione attuale delle 11:59, 13 feb 2025

(8 versioni intermedie di 7 utenti non mostrate)

Riga 18:

===Generazione della tabella di appoggio===

Creare la tabella

<sourcesyntaxhighlight lang="mysql">

CREATE TABLE entitles(

title varchar(255) collate latin1_bin

);

</syntaxhighlight>

</source>

La tabella va riempita eseguendo la query

<sourcesyntaxhighlight lang="mysql">

INSERT INTO entitles(

SELECT page_title

Riga 32:

SELECT * FROM categorylinks WHERE cl_from=page_id AND cl_to = 'All_disambiguation_pages' )

);

</syntaxhighlight>

</source>

===Generazione dell'elenco===

<sourcesyntaxhighlight lang="mysql">

SELECT CONCAT('#[[', page_title, ']] - [[:en:', title, ']]')

FROM entitles JOIN page ON title=page_title

Riga 41:

AND NOT EXISTS( SELECT * FROM templatelinks WHERE tl_from = page_id AND tl_namespace=10 AND tl_title IN ('Disambigua', 'Sigla2', 'Sigla3') )

ORDER BY page_title;

</syntaxhighlight>

</source>

==Elenco==

Riga 199:

#[[Alberto_Chividini]] - [[:en:Alberto_Chividini]]

#[[Alberto_Conti]] - [[:en:Alberto_Conti]]

#[[Alberto_CostaAlberto Costa]] - [[:en:Alberto_Costa]]

#[[Alberto_Fernández_Fernández]] - [[:en:Alberto_Fernández_Fernández]]

#[[Alberto_Mantelli]] - [[:en:Alberto_Mantelli]]

Riga 1 064:

#[[Can't_Give_You_More]] - [[:en:Can't_Give_You_More]]

#[[Canada's_Wonderland]] - [[:en:Canada's_Wonderland]]

#[[Canadian_Albums_ChartBillboard_Canadian_Albums]] - [[:en:Canadian_Albums_Chart]]

#[[Canadian_Eskimo_Dog]] - [[:en:Canadian_Eskimo_Dog]]

#[[Canadian_Hockey_League]] - [[:en:Canadian_Hockey_League]]

Riga 1 967:

#<s>[[Epigonus]] - [[:en:Epigonus]]</s>

#<s>[[Epipactis_purpurata]] - [[:en:Epipactis_purpurata]]</s>

#<s>[[Episode_II_(EP)]] - [[:en:Episode_II_(EP)]]</s>

#<s>[[Epsilon_Lyrae]] - [[:en:Epsilon_Lyrae]]</s>

#<s>[[Equipe_84]] - [[:en:Equipe_84]]</s>

Line 2 154 ⟶ 2 153:

#[[Fiat_501]] - [[:en:Fiat_501]]

#[[Fiat_G.5]] - [[:en:Fiat_G.5]]

#[[Fida (diritto)]] - [[:en:Fida]]

#[[Fight_for_Your_Life]] - [[:en:Fight_for_Your_Life]]

#[[Fighting_Back]] - [[:en:Fighting_Back]]

Line 2 908 ⟶ 2 907:

#[[I_Do_Not_Want_What_I_Haven't_Got]] - [[:en:I_Do_Not_Want_What_I_Haven't_Got]]

#[[I_Don't_Know_What_I'm_Doing]] - [[:en:I_Don't_Know_What_I'm_Doing]]

#[[I_Don't_Know_What_You_Want_But_I_Can't_Give_It_Any_More]] - [[:en:I_Don't_Know_What_You_Want_But_I_Can't_Give_It_Any_More]]

#[[I_Don't_Need_No_Doctor]] - [[:en:I_Don't_Need_No_Doctor]]

#[[I_Got_That]] - [[:en:I_Got_That]]

Line 3 041 ⟶ 3 039:

#[[It's_a_Small_World]] - [[:en:It's_a_Small_World]]

#[[It's_in_the_Rain]] - [[:en:It's_in_the_Rain]]

#[[It_Hurts]] - [[:en:It_Hurts]]

#[[It_Might_as_Well_Be_Swing]] - [[:en:It_Might_as_Well_Be_Swing]]

#[[Ital]] - [[:en:Ital]]

Line 3 097 ⟶ 3 094:

#<s>[[James_Baker]] - [[:en:James_Baker]]</s>

#<s>[[James_Bolton]] - [[:en:James_Bolton]]</s>

#<s>[[James_Danielli]] - [[:en:James_Danielli]]</s>

#<s>[[James_Haldenston]] - [[:en:James_Haldenston]]</s>

#<s>[[James_Haven]] - [[:en:James_Haven]]</s>

#[[James_Martinez]] - [[:en:James_Martinez]]&nbsp;^{non presente su en}

#<s>[[James_Maslow]] - [[:en:James_Maslow]]</s>

Line 3 416 ⟶ 3 413:

#<s>[[Krzysztof_Grzegorek]] - [[:en:Krzysztof_Grzegorek]] </s> (differente)

#<s>[[Ku-ring-gai_Council]] - [[:en:Ku-ring-gai_Council]] </s>

#<s>[[Kuchizuke (Buck-Tick)|Kuchizuke]] - [[:en:Kuchizuke]] </s> (differente)

#<s>[[Kuhsar]] - [[:en:Kuhsar]] </s> (differente)

#[[Kuklen]] - [[:en:Kuklen]] (Caso dubbio! V. interlink non inglesi)