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
WikiBayer
.
Toggle Highlighting
SQL
SELECT log.log_type, log.log_action, log.log_timestamp, log.log_title, log.log_id, log_count.total_count FROM ( SELECT log_type, log_action, MAX(log_id) AS max_log_id FROM logging JOIN actor ON logging.log_actor = actor.actor_id WHERE log_type NOT IN ('newusers', 'thank', 'upload', 'create', 'review', 'move', 'spamblacklist', 'pagetranslation', 'translationreview') AND actor.actor_name = 'DerHexer' AND log_action NOT IN ('autopromote', 'move_prot') GROUP BY log_type, log_action ) AS latest_logs JOIN logging AS log ON log.log_type = latest_logs.log_type AND log.log_action = latest_logs.log_action AND log.log_id = latest_logs.max_log_id JOIN ( SELECT log_type, log_action, COUNT(*) AS total_count FROM logging JOIN actor ON logging.log_actor = actor.actor_id WHERE actor.actor_name = 'DerHexer' GROUP BY log_type, log_action ) AS log_count ON log.log_type = log_count.log_type AND log.log_action = log_count.log_action ORDER BY log.log_type, log.log_action, log.log_timestamp 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...