User:Krinkle/Queries/nlwiki ntharticles

nl.wikipedia.org : Nth articles
Last update: 2010-08-13 13:47 (UTC)

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

# nlwiki_ntharticles.sql
SELECT

concat(
  '<li value=$nth> [[:nl:'
, page_title
, '|]]'
, ' ('
, page_id
, ')</li>'
)
FROM  page
WHERE page_namespace=0
AND   page_is_redirect=0
ORDER BY page_id ASC
LIMIT $nth,1

/* Replace $nth with the number, ie. "LIMIT 999,1" for the 1000th 0=first article, 1=second article */


# nlwiki_ntharticles.txt