Tewiki:User wise deleted pages count all NS

SQL

/* 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 deleted edits - not just pages - comment out this clause with --
group by actor_name
order by deletion_count desc */

select actor_name User_name, count(actor_name) deleted_pages, count(ac1.actor_name) deleted_edits, from archive,actor,archive a1,actor ac1
where actor_id=ar_actor
and a1.ar_actor=ar_actor
and ac1.actor_id=a1.ar_actor
-- and ac1.actor_id=actor_id
-- and ar_namespace=0
 and ar_parent_id=0  #to find all the deleted edits - not just pages - comment out this clause with --
group by actor_name
order by deleted_pages desc, deleted_edits desc
SQL

Checking query status...
