set @actor1:="Chaduvari";

select actor_id into @actorid from actor where actor_name=@actor1;

select count(log_actor) into @all from logging

where log_actor=@actorid;

-- and log_action="delete";

​

select count(log_actor) into @deletes from logging

where log_actor=@actorid

and log_action="delete";

​

select count(log_actor) into @restores from logging

where log_actor=@actorid

and log_action="restore";

​

select count(log_actor) into @moves from logging

where log_actor=@actorid

and log_action="move";

​

select count(log_actor) into @merges from logging

where log_actor=@actorid

and log_action="merge";

​

select count(log_actor) into @blocks from logging

where log_actor=@actorid

and log_action="block";

​

select count(log_actor) into @patrols from logging

where log_actor=@actorid

and log_action="patrol";

​

select count(log_actor) into @reverts from logging

where log_actor=@actorid

and log_action="revert";

​

select count(log_actor) into @thanks from logging

where log_actor=@actorid

and log_action="thank";

​

select count(log_actor) into @protects from logging

where log_actor=@actorid

and log_action="protect";

​

select count(log_actor) into @unprotects from logging

where log_actor=@actorid

and log_action="unprotect";

​

select count(log_actor) into @move_redirs from logging

where log_actor=@actorid

and log_action="move_redir";

​

select count(log_actor) into @delete_redirs from logging

where log_actor=@actorid

and log_action="delete_redir";

​

​

select @all,@actor1,@deletes,@restores,@moves,@merges,@blocks,@patrols,@reverts,@thanks,@protects,@unprotects,@move_redirs,@delete_redirs;