Wikibooks:Elenchi generati offline/Discussioni sole: differenze tra le versioni

Contenuto cancellato Contenuto aggiunto
BimBot (discussione | contributi)
m Aggiorno elenco
Pietrodn (discussione | contributi)
ottimizzo
Riga 4:
|query =
<source lang="sql">
SELECT CONCAT("# [[{{subst:#if:{{subst:ns:", page_namespace, "}}|{{subst:ns:", page_namespace, "}}:}}", page_title, "]]") FROM page AS P1
WHERE page_namespace IN (1, 5, 7, 11, 13, 15, 101)
AND page_title NOT INEXISTS (SELECT page_title* FROM page WHERE page_namespacepage_title=P1.page_title INAND (0, 4, 6, 10, 12,page_namespace=P1.page_namespace 14,- 100)1)
ORDER BY page_namespace, page_title;
</source>