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_id = page_id
WHERE pr_type = 'move'
  AND pr_level = 'sysop'
  AND NOT EXISTS (SELECT 1
                  FROM logging
                  JOIN page_restrictions ON pr_id = log_page
                  WHERE pr_type = 'move'
                    AND pr_level = 'sysop'
                    AND log_type = 'protect'
                    AND log_action != 'unprotect');

SQL

Checking query status...