Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Articles in mainspace salted with template editor protection
by
Novem Linguae
This query is marked as a draft
This query has been published
by
Trialpears
.
Toggle Highlighting
SQL
SELECT pt_title as pagename, pt_timestamp as timestamp, pt_expiry as expiry, user_name as protecting_user, comment_text as reason FROM protected_titles JOIN user ON pt_user = user_id JOIN comment ON pt_reason_id = comment_id WHERE pt_create_perm = 'templateeditor' AND pt_namespace = 0
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...