Tewiki:User wise deleted pages count all NS

SQL

select @pages:= count(actor_name) from archive,actor 
where actor_id=ar_actor
-- and ar_namespace=0
 and ar_parent_id=0  #to find all the edits that are deleted, comment out this clause with --
group by actor_id;

select @edits:= count(actor_name) from archive,actor
where actor_id=ar_actor
-- and ar_namespace=0
group by actor_id;

select actor_name User_name, @pages,@edits from archive,actor
where actor_id=ar_actor
-- and ar_namespace=0
 and ar_parent_id=0  #to find all the edits that are deleted, comment out this clause with --
order by @pages,@edits desc;

SQL

Checking query status...