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
NightWolf1223
.
Stolen from https://wikitech.wikimedia.org/wiki/Help:MySQL_queries/Example_queries#Indefinitely_fully-protected_articles
Toggle Highlighting
SQL
SELECT page_is_redirect, page_title, user_name, logs.log_timestamp, logs.log_comment FROM page JOIN page_restrictions ON page_id = pr_page AND page_namespace = 0 AND pr_type = 'edit' AND pr_level = 'sysop' AND pr_expiry = 'infinity' LEFT JOIN logging AS logs ON logs.log_title = page_title AND logs.log_namespace = 0 AND logs.log_type = 'protect' LEFT JOIN `user` ON logs.log_user = user_id WHERE CASE WHEN (NOT ISNULL(log_timestamp)) THEN log_timestamp = (SELECT MAX(last.log_timestamp) FROM logging AS last WHERE log_title = page_title AND log_namespace = 0 AND log_type = 'protect') ELSE 1 END;
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...