English Wikipedia Potiental CSD U2 Violations

Fork of English Wikipedia Potiental CSD U2 Violations by Bradv

This query is marked as a draft This query has been published by Bradv.

SQL

SELECT
  page_namespace,
  CONCAT('[[User talk:', page_title, ']]') AS user_talk_page,
  CONCAT('[[Special:Contributions/', page_title, ']]') as user_contribs,
  page_len
FROM page
LEFT JOIN `user`
ON user_name = REPLACE(page_title, '_', ' ')
WHERE page_namespace = 3
AND page_is_redirect = 0
AND page_title NOT LIKE "%/%"
AND page_title NOT RLIKE "(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)"
AND user_name IS NULL;

SQL

Checking query status...