User:Krinkle/Queries/nlwikimedia slasharticles

nl.wikimedia.org : Articlestitles with slashes
Last update: 2011-01-16 16:18 (UTC)

# nlwikimedia slasharticles.sh
sql nlwikimedia_p < nlwikimedia_slasharticles.sql > nlwikimedia_slasharticles.txt

# nlwikimedia slasharticles.sql
SELECT

concat(
  '* [[:nl:chapter:'
, page_title
, '|'
, page_title
, ']]'
)

FROM  page
WHERE page_namespace=0
AND   page_title
LIKE  '%/%'

# nlwikimedia slasharticles.txt