SELECT page_namespace, page_title, pr1.pr_expiry

FROM page

JOIN page_restrictions pr1 ON pr1.pr_page = page_id

LEFT JOIN logging_logindex ON log_page = page_id AND log_type = 'protect' AND log_action != 'unprotect'

LEFT JOIN page_restrictions pr2

       ON pr2.pr_page = page_id

      AND pr2.pr_type = 'edit'

      AND pr2.pr_level = 'sysop'

      AND (pr2.pr_expiry IS NULL OR pr2.pr_expiry = 'infinity')

WHERE pr1.pr_type = 'move'

  AND pr1.pr_level = 'sysop'

  AND log_id IS NULL

  AND pr2.pr_id IS NULL;

​