Tewiki: User-wise edit count in a specific namespace

SQL

set @actor="Chaduvari"
select COUNT(*) into @all FROM revision 
WHERE rev_actor = @actor
and rev_namespace=0;

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...