subject not like '%neeee%',subject=null时like 会失效 改为:and ifnull(subject ,'') not like '%non_focus_pcc_finding%'