Differenze tra le versioni di "Wikibooks:Elenchi generati offline/Discussioni sole"

ottimizzo
m (Aggiorno elenco)
(ottimizzo)
|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>