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;