Pre-10/2009 move protections, main ns, !sysop edit prot

Currently move-protected pages that do not have any protection-related log entries after 7 October 2009, restricted to pages currently in the main namespace and not currently edit-protected sysop.

See parent query for comments on log accuracy.

See query 54424 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_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)
  AND page_namespace = 0
  AND COALESCE(pr2.pr_level, '') != 'sysop';

SQL

Checking query status...