Tewiki:User wise deleted pages count all NS

SQL

insert into temppages select  actor_name User_name, count(actor_name) deletion_count 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;

insert into tempedits select actor_name User_name1, count(actor_name) deletion_count1 from archive,actor
where actor_id=ar_actor
-- and ar_namespace=0
group by actor_id;

select user_name, deletion_count, deletion_count1 from temppages,tempedits
where user_name=user_name1
order by deletion_count desc, deletion_count desc

/*
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 desc,@edits desc;
SQL

Checking query status...
