Tewiki:User wise deleted pages count all NS

SQL

set @pages= select count(actor_name) Deleted_pages 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;

set @edits= select count(actor_name) Deleted_pages 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 --
group by actor_id
order by Deleted_pages desc

SQL

Checking query status...