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 FROM revision,page
WHERE rev_actor = @actor
and page_id=rev_page
and page_namespace=0;
select @actor1,@all;
/*
select COUNT(*) into @talk_page_edits FROM revision 
WHERE rev_actor = @actor
and rev_namespace=1;

select COUNT(*) into @wikipedia_edits FROM revision 
WHERE rev_actor = @actor
and rev_namespace=4;

select COUNT(*) into @template_edits FROM revision 
WHERE rev_actor = @actor
and rev_namespace=10;

select COUNT(*) into @category_edits FROM revision 
WHERE rev_actor = @actor
and rev_namespace=14;

select COUNT(*) into @help_edits FROM revision 
WHERE rev_actor = @actor
and rev_namespace=12;

Select @all,@talk_page_edits,@wikipedia_edits,@template_edits,@category_edits,@help_edits;
SQL

Checking query status...
