List of IP talkpages

SQL

select CONCAT('[[User talk:', page_title, ']]') as 'IP talkpages' -- format as wikilink
from page
join actor on actor_user is null and actor_name = page_title -- IP with User talk page
where page_namespace = 3 -- filter User talk namespace
and page_title regexp '^(\\d{1,3}(\\.\\d{1,3}){3}|[\\dA-F]{1,4}(:[\\dA-F]{0,4}){1,7})$' -- IPv4 and IPv6 regex
order by page_title asc -- arrange in ascending order
limit 1000000;

AخA
 
select CONCAT('[[User talk:', page_title, ']]') as 'IP talkpages' -- format as wikilinkfrom pagejoin actor on actor_user is null and actor_name = page_title -- IP with User talk pagewhere page_namespace = 3 -- filter User talk namespaceand page_title regexp '^(\\d{1,3}(\\.\\d{1,3}){3}|[\\dA-F]{1,4}(:[\\dA-F]{0,4}){1,7})$' -- IPv4 and IPv6 regexorder by page_title asc -- arrange in ascending orderlimit 1000000;

SQL

Checking query status...