Pre-10/2009 move protections

Currently move-protected pages that do not have any protection-related log entries after 7 October 2009.

Extraction of the most recent log entry (hence timestamp, action, name, and comment) is in some cases dubious and in others apparently self-contradictory, as it relies on a namespace/title match.  For example, [[User talk:Zzuuzz]] was move protected on 25 December 2020, then moved to [[User talk:Zzuuzz/Archive 39]] on 22 March 2021.  It's included here because the page has no log entries of its own (the move protection log entry belongs to Archive 39) and is currently move-protected (having inherited protection from the moved-from page).  The log entry listed for it was made at the title [[User talk:Zzuuzz]] but remains the one actually made for the archive page.

See query 54384 for move protections after 7 October 2009.

For [[WP:RAQ#Indefinite move-protections placed long ago on articles]] circa 27 April 2021.

SQL

SELECT page_namespace, page_title
FROM page
JOIN page_restrictions ON pr_page = page_id
LEFT JOIN logging_logindex ON log_page = page_id AND log_type = 'protect' AND log_action != 'unprotect'
WHERE pr_type = 'move'
  AND pr_level = 'sysop'
  AND log_id IS NULL;

SQL

Checking query status...