User:Krinkle/Queries/nlwiki ntharticles
Appearance
< User:Krinkle | Queries
nl.wikipedia.org : Nth articles
Last update: 2010-08-13 13:47 (UTC)
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
- Andre_Agassi (2)
- Abel_Tasman (14)
- België (135)
- Pontius_Pilatus (1364)
- National_Medal_of_Arts (18329)
- Alfândega_da_Fé (278088)
- Brünn/Thür (719187)
- Last_Night_on_Earth (1486177)