Non-blocked editors created by now-blocked editors

SQL

SELECT concat( "{{user3|", rc_user_text, "}}") as "Creating / Blocked user",
       concat( "{{user3|", rc_title, "}}" ) as "Created user", 
       concat( "<nowiki>", ipb_reason, "</nowiki>" ) as "Block Reason",
       rc_comment as "Editor Comment"
FROM   recentchanges 
       JOIN user 
         ON user_name = rc_title 
       JOIN ipblocks 
         ON ipb_user = rc_user 
WHERE  rc_log_action = "create2" 
       AND rc_user IN (SELECT ipb_user 
                       FROM   ipblocks 
                       WHERE  ipb_user = rc_user) 
       AND user_id NOT IN (SELECT ipb_user 
                       FROM   ipblocks 
                       WHERE  ipb_user = user_id)
       AND ipb_reason not like "%sername%"
ORDER  BY rc_timestamp DESC;
SQL

Checking query status...
