nlwiki Protected user pages without a user account

SQL

SELECT
	page_title,
    rd_namespace AS rdns, rd_title,
    GROUP_CONCAT(DISTINCT pr_type) AS pr_type,
    GROUP_CONCAT(DISTINCT pr_level) AS pr_level,
    GROUP_CONCAT(DISTINCT pr_cascade) AS pr_cascade,
    GROUP_CONCAT(DISTINCT pr_expiry) AS pr_expiry
FROM page RIGHT JOIN redirect ON (rd_from=page_id), page_restrictions
WHERE
	page_namespace=2 AND
    page_id=pr_page AND
    NOT IS_IPV4(REGEXP_SUBSTR(page_title, '^[^/]+')) AND
    NOT IS_IPV6(REGEXP_SUBSTR(page_title, '^[^/]+')) AND
    NOT EXISTS (SELECT * FROM `user` WHERE REPLACE(REGEXP_SUBSTR(page_title, '^[^/]+'), '_', ' ')=user_name)
GROUP BY page_title

SQL

Checking query status...