Anthere wrote:
SELECT count(cur_title) from cur where cur_namespace=4
euh, no. This is the right namespace I think (334 ?)
4 is Wikipedia (the others you can find in Language??.php)
But, this is giving the number of articles. What I would like is the names of these pages. I think perhaps many of them are long lost.
Sorry I missed that. This should help you:
select cur_title from cur where cur_namespace=4 order by cur_title
Please, I also would like a query giving me the name of users, who have made at least n articles (say 200) and been there for at least m months (say 3).
That's usually not possible, because simple sysops don't have the right to read these values (user_touched), thats a matter of data security and privacy.
Which articles do you mean with "have made at least n articles"? New ones, edited ones?
Thank you very much for your help smurf (isnot that the translation of schtroumpf ?)
Whatever "schtroumpf " means *puzzle*. It's the english translation of the german word "Schlumpf" and here is an example picture:
http://www.weltderkobolde.de/PapaschlumpfmitBuch.html (Wikipedia compatible version of me ;)