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
MBH
.
SELECT DISTINCT log_type FROM logging; abusefilter = modify/"" block = block unblock reblock contentmodel = change delete log_action!="delete" and log_action!="restore" and log_action!="revision" and log_action!="event" and log_action!="delete_redir" and log_action!="flow-restore-topic" and log_action!="flow-delete-topic" and log_action!="flow-restore-post" and log_action!="flow-delete-post" gblblock = d/whitelist managetags = create/delete/deactivate/activate massmessage = failure/send/skipbadns/skipnouser merge = merge move = move/move_redir protect = "protect" and log_action!="unprotect" and log_action!="modify" and log_action!="move_prot" renameuser = renameuser review rights = rights/autopromote stable = "config" and log_action!="reset" and log_action!="modify" and log_action!="move_stable" upload = "overwrite" and log_action!="upload" newusers = autocreate/byemail/create/create2/newusers
Toggle Highlighting
SQL
use ruwiki_p; SELECT * from logging where (log_type = "protect" and log_action!="failure" and log_action!="send" and log_action!="skipbadns" and log_action!="skipnouser");
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...