Pages re-created after previous XfD deletion

SQL

SELECT DISTINCT CONCAT('https://en.wikipedia.org/wiki/', rc.rc_title) AS 'Page',
p.page_len AS 'Page length',
TIMESTAMP(rc.rc_timestamp) AS 'Re-created at',
TIMESTAMP(MAX(r.rev_timestamp)) AS 'Last AfD interaction'
FROM enwiki_p.recentchanges_userindex rc
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.comment_logging c ON c.comment_id = l.log_comment_id
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.page p2 ON p2.page_namespace = 4 AND p2.page_title LIKE CONCAT('Articles_for_deletion/', p.page_title, '%')
INNER JOIN enwiki_p.revision_userindex r ON p2.page_latest = r.rev_id
WHERE rc.rc_new = 1
AND rc.rc_namespace = 0
AND (c.comment_text LIKE '%XfD%' OR c.comment_text LIKE '%AfD%' OR c.comment_text LIKE '%Articles_for_deletion%' OR c.comment_text LIKE '%G4%')
AND p.page_id NOT IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to = 'Articles_for_deletion'
)
GROUP BY rc.rc_title, p.page_len, TIMESTAMP(rc.rc_timestamp)
ORDER BY TIMESTAMP(rc.rc_timestamp) DESC;
SQL

Checking query status...
