USE zhwiki_p;

SELECT user_name,comment_text,(comment_text rlike "封禁|[Bb]lock") AS is_block

FROM change_tag,change_tag_def,user,page,revision,comment 

WHERE ct_tag_id=ctd_id AND ctd_name="Twinkle" AND ct_rev_id=rev_id AND rev_comment_id=comment_id AND comment_text rlike "uw\-|封禁|[Bb]lock|警告|[Ww]arn" AND user_registration>20180101000000 AND user_editcount<50 AND page_title=REPLACE(user_name," ","_") AND page_namespace=3 AND rev_id=page_latest;