Post-10/2009 move protections

Currently move-protected pages that have had a protection-related log entry since 7 October 2009.

There's no hard guarantee that the most recent protection log entry is related to the move protection, and it's hard to filter for that specifically.

See query 54383 for move protections before 7 October 2009.

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

SQL

SELECT log_namespace,
       log_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 logging
LEFT JOIN actor_logging ON actor_id = log_actor
LEFT JOIN comment_logging ON comment_id = log_comment_id
LEFT JOIN page_restrictions AS pr1 ON pr1.pr_page = log_page
LEFT JOIN page_restrictions AS pr2 ON pr2.pr_page = log_page AND pr2.pr_type = 'edit'
LEFT JOIN page ON page_id = log_page
WHERE log_id IN (SELECT MAX(log_id)
                 FROM page
                 JOIN page_restrictions AS pr3 ON pr3.pr_page = page_id
                 JOIN logging_logindex ON log_page = page_id AND log_type = 'protect' AND log_action != 'unprotect'
                 WHERE pr3.pr_type = 'move'
                   AND pr3.pr_level = 'sysop'
                 GROUP BY log_page)
  AND pr1.pr_type = 'move'
  AND pr1.pr_level = 'sysop';

SQL

Checking query status...