Edit-protected IP talk pages

User talk pages of anonymous users that are currently protected from editing, and their (not just current) protection log comments.

For [[WP:VPT#Question about talk page blocks and protection]] circa 15 Aug 2023.

SQL

SELECT CONCAT('User talk:', page_title) AS title,
       pr_level,
       pr_cascade,
       pr_expiry,
       GROUP_CONCAT(comment_text SEPARATOR ' // ') AS `protection comments`
FROM page
JOIN page_restrictions ON page_id = pr_page
LEFT JOIN logging_logindex ON log_namespace = page_namespace AND log_title = page_title AND log_type = 'protect' AND log_action = 'protect'
LEFT JOIN comment_logging ON comment_id = log_comment_id
WHERE page_namespace = 3
  AND (IS_IPV4(page_title) OR IS_IPV6(page_title))
  AND pr_type = 'edit'
GROUP BY page_id;

SQL

Checking query status...