User:Krinkle/Queries/nlwiki slasharticles

nl.wikipedia.org : Articlestitles with slashes
Last update: 2010-07-22 22:51 (UTC)

# krinklequery2.sh
sql nlwiki_p < krinklequery2.sql > krinklequery2.txt

# krinklequery2.sql
SELECT

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

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

# krinklequery2.txt