Pages re-created after previous creation by now-blocked user

SQL

WITH sock_template AS (
  SELECT tl.tl_from FROM
  enwiki_p.templatelinks tl
  WHERE tl.tl_target_id IN (32197, 277052, 282063, 115252, 1968835)
)

SELECT DISTINCT CONCAT('https://en.wikipedia.org/wiki/', CASE rc.rc_namespace
WHEN   -2 THEN 'Media:'             WHEN   -1 THEN 'Special:'
WHEN    0 THEN ''                   WHEN    1 THEN 'Talk:'
WHEN    2 THEN 'User:'              WHEN    3 THEN 'User talk:'
WHEN    4 THEN 'Wikipedia:'         WHEN    5 THEN 'Wikipedia talk:'
WHEN    6 THEN ':File:'             WHEN    7 THEN 'File talk:'
WHEN    8 THEN 'MediaWiki:'         WHEN    9 THEN 'MediaWiki talk:'
WHEN   10 THEN 'Template:'          WHEN   11 THEN 'Template talk:'
WHEN   12 THEN 'Help:'              WHEN   13 THEN 'Help talk:'
WHEN   14 THEN ':Category:'         WHEN   15 THEN 'Category talk:'
WHEN  100 THEN 'Portal:'            WHEN  101 THEN 'Portal talk:'
WHEN  108 THEN 'Book:'              WHEN  109 THEN 'Book talk:'
WHEN  118 THEN 'Draft:'             WHEN  119 THEN 'Draft talk:'
WHEN  446 THEN 'Education Program:' WHEN  447 THEN 'Education Program talk:'
WHEN  710 THEN 'TimedText:'         WHEN  711 THEN 'TimedText talk:'
WHEN  828 THEN 'Module:'            WHEN  829 THEN 'Module talk:'
WHEN 2300 THEN 'Gadget:'            WHEN 2301 THEN 'Gadget talk:'
WHEN 2302 THEN 'Gadget definition:' WHEN 2303 THEN 'Gadget definition talk:'
END, p.page_title) AS 'Page',
TIMESTAMP(rc.rc_timestamp) AS 'Re-created at'
FROM enwiki_p.recentchanges_userindex rc
INNER JOIN enwiki_p.page p ON rc.rc_cur_id = p.page_id AND rc.rc_namespace = p.page_namespace AND NOT p.page_is_redirect
INNER JOIN enwiki_p.logging_logindex l ON l.log_type = 'delete' AND l.log_action = 'delete' AND rc.rc_title = l.log_title AND rc.rc_namespace = l.log_namespace
INNER JOIN enwiki_p.logging_logindex l2 ON l2.log_type = 'create' AND l2.log_action = 'create' AND rc.rc_title = l2.log_title AND rc.rc_namespace = l2.log_namespace AND p.page_id != l2.log_page
INNER JOIN enwiki_p.actor_user a ON l2.log_actor = a.actor_id
INNER JOIN enwiki_p.user u ON a.actor_user = u.user_id
INNER JOIN enwiki_p.ipblocks ipb ON u.user_id = ipb.ipb_user
WHERE rc.rc_new = 1
-- AND rc.rc_namespace IN (0, 2, 4, 6, 10, 14, 118)
AND rc.rc_namespace IN (0, 118)
AND rc.rc_timestamp > DATE_SUB(NOW(), INTERVAL 1 MONTH)
AND rc.rc_cur_id NOT IN (SELECT st.tl_from FROM sock_template st)
ORDER BY rc.rc_timestamp DESC
SQL

Checking query status...
