--- Thomas Corell <T.Corell(a)t-online.de> wrote:
Anthere wrote:
On that topic, could someone give us a query to
list
"protected pages" ?
SELECT cur_title,cur_restrictions,cur_namespace from
cur where
cur_restrictions!=''
this is the right one yes.
So, we have protected
* 1 upload log page
* 5 deletion log pages (current and history)
* Aoineko user page
* most wanted page
* FAQ administration (a mistake I guess)
Could someone
also give me a tip how to know
precisely
the list of articles in one given space (meta
pages
more exactly ?)
SELECT count(cur_title) from cur where
cur_namespace=4
I hope I understood your questions the right way.
(e.g. meta -> Wikipedia:
- namespace).
euh, no. This is the right namespace I think (334 ?)
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.
------
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).
Thank you very much for your help smurf (isnot that
the translation of schtroumpf ?)
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com