Inactive non-blocked IP talkpages transcluding a template

SQL

select CONCAT('[[User talk:', page_title, ']]') as user_talk
from page
where page_namespace = 3
and (select pg.page_title
     from page pg
     where pg.page_title regexp '(^([0-9]{1,3}[.]){3}[0-9]{1,3}$|^([[:alnum:]]{1,4}[:]){7})'
     and (select case when count(*) = 1 then true else false end
          from ipblocks
          where ipb_user = 0
          and ipb_address in pg.page_title) is false
     and (select case when count(*) = 0 then False else True end
          from revision, actor
          where rev_actor = actor_id
          and actor_name in pg.page_title
          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 p on p.page_id = rev_page
          where p.page_title in pg.page_title
          and p.page_namespace = 3
          and rev_timestamp > '20170504000000'
          and actor_name not in ('MalnadachBot')) is False)
order by user_talk asc
limit 100;
SQL

Checking query status...
