Tewiki:User-wise Log stats

SQL

set @actor:="Chaduvari";
select count(log_actor) into @deletes from logging,actor
where actor_id=log_actor
and actor_name=@actor
and log_action="delete";

select count(log_actor) into @drestores from logging,actor
where actor_id=log_actor
and actor_name=@actor
and log_action="restore";

select count(log_actor) into @moves from logging,actor
where actor_id=log_actor
and actor_name=@actor
and log_action="move";

select count(log_actor) into @merges from logging,actor
where actor_id=log_actor
and actor_name=@actor
and log_action="merge";

show @actor,@deletes,@restores,@moves,@merges
SQL

Checking query status...
