Wikipedia:Elenchi generati offline/Voci en senza interlink it: differenze tra le versioni

Versione delle 13:48, 28 nov 2014

Versione attuale delle 18:26, 25 mar 2023

Riga 10:

== Query ==

<sourcesyntaxhighlight lang="mysql">

SELECT CONCAT( '*[[:en:', page title, ']] - ', COUNT(*), ' {{Subst:#ifexist:', page title, '| - [[', page title, ']]|}}' )

FROM langlinks JOIN page ON ll from = page id

Riga 19:

ORDER BY count(*) DESC, page title

LIMIT 1 , 1000;

</syntaxhighlight>

</source>

== Elenco ==