Tewiki:Deletion stats of page creators and editors -ns0 & all-ns

SQL

USE tewiki_p;
SELECT actor_name, count(actor_name) as all_ns_new_pages_deleted
FROM archive_userindex JOIN actor_archive ON actor_id = ar_actor
WHERE ar_parent_id = 0
group by actor_name
order by count(actor_name) desc
limit 150;

SELECT actor_name, count(actor_name) as ns0_new_pages_deleted
FROM archive_userindex JOIN actor_archive ON actor_id = ar_actor
WHERE 
	ar_parent_id = 0
	and ar_namespace = 0
group by actor_name
order by count(actor_name) desc;
-- limit 150;

SELECT actor_name, count(actor_name) as all_ns_deleted_edits
FROM archive_userindex JOIN actor_archive ON actor_id = ar_actor
group by actor_name
order by count(actor_name) desc
limit 50;

SELECT actor_name, count(actor_name) as ns0_deleted_edits
FROM archive_userindex JOIN actor_archive ON actor_id = ar_actor
WHERE 
 ar_namespace = 0
group by actor_name
order by count(actor_name) desc
limit 50;
SQL

Checking query status...
