Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Kasyap
.
Toggle Highlighting
SQL
SELECT actor_name, SUM(IF( (log_type = 'delete' AND log_action != 'restore'),1,0)) AS 'delete', SUM(IF( (log_type = 'delete' AND log_action = 'restore'),1,0)) AS 'restore', SUM(IF( (log_type = 'delete' AND log_action = 'event'),1,0)) AS 'event', SUM(IF( (log_type = 'delete' AND log_action = 'revision'),1,0)) AS 'revision', SUM(IF( (log_type = 'block' AND log_action != 'unblock'),1,0)) AS 'block', SUM(IF( (log_type = 'block' AND log_action = 'unblock'),1,0)) AS 'unblock', SUM(IF( (log_type = 'block' AND log_action = 'reblock'),1,0)) AS 'reblock', SUM(IF( (log_type = 'protect' AND log_action != 'unprotect'),1,0)) AS 'protect', SUM(IF( (log_type = 'protect' AND log_action = 'unprotect'),1,0)) AS 'unprotect', SUM(IF( (log_type = 'protect' AND log_action = 'modify'),1,0)) AS 'modify', SUM(IF( log_type = 'rights',1,0)) AS 'rights', SUM(IF( log_type != '',1,0)) AS 'total' FROM logging INNER JOIN actor ON logging.log_actor = actor.actor_id WHERE log_type IS NOT NULL AND log_action IS NOT NULL AND actor_name IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'sysop') AND log_type IN ('block', 'delete', 'protect', 'rights') AND log_action NOT IN ('delete_redir', 'autopromote', 'move_prot') AND ucase (actor_name) not like ucase ("%BOT") collate utf8_general_ci AND actor_name NOT IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot') GROUP BY actor_name ORDER BY total DESC;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...