Inactive non-blocked IP talkpages transcluding a template

SQL

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

Checking query status...
