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 @all_edits FROM revision,page
WHERE rev_actor = @actor;

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_alt=@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;
Select @user1,@all_edits,@all_alt,@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...
