User:Krinkle/Queries/nlwiki articlesenddot

nl.wikipedia.org : Articlestitles end with dot
Last update: 2010-07-22 23:17 (UTC)

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

# nlwiki_articlesenddot.sql
SELECT

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

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

# nlwiki_articlesenddot.txt