Tewiki:User-wise Log stats

SQL

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

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

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

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

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

Checking query status...
