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,
       pr1.pr_expiry AS 'Move expiry',
       pr2.pr_level AS 'Edit protection',
       page_is_redirect,
       log_timestamp,
       log_action,
       actor_name,
       comment_text
FROM page
JOIN page_restrictions AS pr1 ON pr1.pr_page = page_id
LEFT JOIN page_restrictions AS pr2 ON pr2.pr_page = page_id AND pr2.pr_type = 'edit'
LEFT JOIN logging_logindex AS l1 ON log_namespace = page_namespace AND log_title = page_title AND log_type = 'protect' AND log_action != 'unprotect'
LEFT JOIN actor_logging ON actor_id = log_actor
LEFT JOIN comment_logging ON comment_id = log_comment_id
WHERE pr1.pr_type = 'move'
  AND pr1.pr_level = 'sysop'
  -- exclude pages where there's a match on log_page
  AND NOT EXISTS (SELECT 1
                  FROM logging_logindex
                  WHERE log_page = page_id
                    AND log_type = 'protect'
                    AND log_action != 'unprotect')
  -- only show most recent log
  AND NOT EXISTS (SELECT 1
                  FROM logging_logindex
                  WHERE log_namespace = page_namespace
                    AND log_title = page_title
                    AND log_type = 'protect'
                    AND log_action != 'unprotect'
                    AND log_id > l1.log_id);

SQL

Checking query status...