Tewiki: User-wise edit count in a specific namespace

SQL

set @actor1="Chaduvari";
select actor_id into @actor from actor where actor_name=@actor1;
select COUNT(*) into @article_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=0;

select COUNT(*) into @talk_page_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=1;


select COUNT(*) into @user_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=2;

select COUNT(*) into @user_talk_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=3;

select COUNT(*) into @wikipedia_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=4;

select COUNT(*) into @wikipedia_talk_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=5;


select COUNT(*) into @mediawiki_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=8;

select COUNT(*) into @mediawiki_talk_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=9;



select COUNT(*) into @template_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=10;

select COUNT(*) into @template_talk_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=11;


select COUNT(*) into @category_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=14;

select COUNT(*) into @category_talk_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=15;


select COUNT(*) into @help_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=12;

select COUNT(*) into @help_talk_edits FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=13;

set @all=@article_edits+Page History@talk_page_edits+Page History@user_edits+Page History@user_talk_edits+Page History@wikipedia_edits+Page History@wikipedia_talk_edits+Page History@mediawiki_edits+Page History@mediawiki_talk_edits+Page History@template_edits+Page History@template_talk_edits+Page History@category_edits+Page History@category_talk_edits+Page History@help_edits+Page History@help_talk_edits;
Select @user1,@article_edits,@talk_page_edits,@user_edits,@user_talk_edits,@wikipedia_edits,@wikipedia_talk_edits,@mediawiki_edits,@mediawiki_talk_edits,@template_edits,@template_talk_edits,@category_edits,@category_talk_edits,@help_edits,@help_talk_edits;
SQL

Checking query status...
