On Mon, May 26, 2008 at 7:14 PM, masti <mst(a)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.