On Mon, May 26, 2008 at 7:14 PM, masti mst@warszawa.pl.eu.org wrote:
does anyone have an idea on how to get the right article count on any particular wiki? I mean getting which article is number xxx (especialy for desired numbers like x000, and so on). Also getting the author of such article could be nice,
SELECT page_namespace, page_title FROM page WHERE page_id=12345;
Once you have the namespace (note that it will be a number, not a namespace name) and title, you can look at the history as usual.
If you want the 12345th page in the main namespace (namespace 0), something like this would work:
SELECT page_namespace, page_title FROM page WHERE page_namespace=0 LIMIT 12344, 1;
(note 12344 = 12345-1, not 12345 there)
Neither of these is guaranteed foolproof, for various reasons: deleted pages, rolled-back transactions, etc.
What is your policy on finding such articles? Or you don't care?
It seems someone digs them up when the article count exceeds some magic number that gets everyone excited so we can have a press release or something.