Tewiki:Admin actions count -DONT MODIFY

SQL

set @userr="Chaduvari";
SELECT log_type, log_action, count(log_action)
FROM logging,actor
WHERE 
-- log_type = 'delete'
-- 	AND log_action = 'revision'
    actor_id=log_actor and
    actor_name=@userr and
    concat(log_type,"-",log_action) in ("abusefilter-modify","block-block","block-reblock","block-unblock","delete-delete","delete-delete_redir","delete-event","delete-restore","delete-revision","import-interwiki","protect-modify","protect-move_prot","protect-protect","protect-unprotect","renameuser-renameuser","rights-rights")
--    log_type in ("abusefilter","block","delete","import","protect","renameuser","rights") and
--    log_action in ("modify","block","reblock","unblock","delete","delete_redir","event","restore","revision","interwiki","move_prot","protect","unprotect","renameuser","rights")
group by log_action
ORDER BY log_type,log_action
SQL

Checking query status...
