Non-blocked editors created by now-blocked editors - 6 month edition

SQL

SELECT concat( "{{user3|", log_user_text, "}}") as "Creating / Blocked user",
       concat( "{{user3|", log_title, "}}" ) as "Created user", 
       concat( "<nowiki>", ipb_reason, "</nowiki>" ) as "Block Reason",
       log_comment as "Editor Comment"
FROM   logging 
       JOIN user 
         ON user_name = log_title 
       JOIN ipblocks 
         ON ipb_user = log_user 
WHERE  log_action = "create2" 
	   AND log_timestamp > now() - interval 6 month
       AND log_user IN (SELECT ipb_user 
                       FROM   ipblocks 
                       WHERE  ipb_user = log_user) 
       AND user_id NOT IN (SELECT ipb_user 
                       FROM   ipblocks 
                       WHERE  ipb_user = user_id)
       AND ipb_reason NOT LIKE "%sername%"
       AND ipb_reason NOT LIKE "%softerblock%"
       AND ipb_reason NOT LIKE "%ublock%"
       AND ipb_reason NOT LIKE "%causeblock%"
ORDER  BY log_timestamp DESC;
SQL

Checking query status...
