--- Thomas Corell T.Corell@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