Draft titles that have ever been move-protected

This query is marked as a draft This query has been published by Cryptic.

Every title in the draft namespace that has ever been move-protected.

Includes redirects, as well as pages that were also edit-protected at the time.  Does not include pages that never had their protection changed while in their draft namespace, for example if move protection was applied to them immediately before they were draftified.

For [[WP:PP#Move protection of drafts]] circa 13 Sep 2023.

SQL

SELECT DISTINCT log_title
FROM logging_logindex
WHERE log_namespace = 118
  AND log_type = 'protect'
  AND log_params LIKE '%"move"%';

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.

SQL

Checking query status...