Inactive non-blocked IP talkpages transcluding a template

SQL

select CONCAT('[[User talk:', page_title, ']]') as user_talk
from page, ipblocks
where ipb_user = 0
and page_namespace = 3
and (select page_title as ip_user
    where page_title REGEXP '(^([0-9]{1,3}[.]){3}[0-9]{1,3}$|^([[:alnum:]]{1,4}[:]){7})')
and page_title not in (select page_title
                       from page, ipblocks
                       where ipb_user = 0
                       and page_namespace = 3
                       and page_title in ip_user
                       and ipb_address = page_title)
and ipb_address = page_title
and (SELECT CASE WHEN COUNT(*) = 0 then False else True end
     FROM revision, actor
     where rev_actor = actor_id
     and actor_name = ip_user
     AND rev_timestamp > '20170504000000') is False
and (SELECT CASE WHEN COUNT(*) = 0 then False else True end
     from revision
     join actor on actor_id = rev_actor
     join page on page_id = rev_page
     where page_title = ip_user
     and page_namespace = 3
     and rev_timestamp > '20170504000000'
     and actor_name not in ('MalnadachBot')) is False
order by user_talk asc
limit 3;
SQL

Checking query status...
