[Wikipedia-l] Re: Admins: Revert and query tips ?

[Thomas Corell]

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!=''


> 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).
-- 
Smurf

smurf at AdamAnt.mud.de
-------------------------  Anthill inside! ---------------------------