Untitled query #78396

SQL

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-modify","block-reblock","block-unblock","delete-delete","delete-event","delete-restore","delete-revision","import-interwiki","protect-modify","protect-move_prot","protect-protect","protect-unprotect","renameuser-renameuser","rights-rights")
group by log_action, log_actor
ORDER BY log_type,log_action,log_actor
SQL

Checking query status...
