SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.