这条数据的IS_cancel字段是空值

我的另一端SQL加入了这个字段作过滤，过滤掉等于1的，但是这条数据夜查不出来了，请问是啥情况

 SELECT

 q.车间,

 q.颜色,

 q.纸种,

 q.批次,

 q.产品代码,

  sum(q.重量)/1000 吨

FROM

 ( 

 SELECT distinct paper.PAPER_ROLL_CODE 批次,

 case m.COLOR when 'BaseSet_color/yellow' then '本色' when 'BaseSet_color/white' then '漂白'  else '其他' end 颜色,

 case m.PRODUCT_CODE  when null then '其他' else m.PRODUCT_CODE end 产品代码,

 paper.WEIGH 重量,

 case SUBSTRING(paper.PAPER_ROLL_CODE,1,1) when 'Y' then '原纸' when 'F' then '分切纸' when 'A' then '分盘纸' else '其他' end 纸种,

 CASE   

    WHEN cast(SUBSTRING(paper.PAPER_ROLL_CODE, 9, 2) as int) Between 01 and 04 THEN

    '一车间' 

    WHEN cast(SUBSTRING(paper.PAPER_ROLL_CODE, 9, 2) as int) Between 05 and 08 THEN

    '二车间' 

    WHEN cast(SUBSTRING(paper.PAPER_ROLL_CODE, 9, 2) as int) Between 09 and 14 THEN

    '三车间' 

    WHEN cast(SUBSTRING(paper.PAPER_ROLL_CODE, 9, 2) as int) Between 51 and 99 THEN

    '分切车间' 

    ELSE '未知' end

    车间

FROM

 WOM_PAPER_RECORDS paper LEFT JOIN BASESET_BATCH_INFOS  b on paper.PAPER_ROLL_CODE=b.BATCH_NUM

  LEFT JOIN  BASESET_MATERIALS m on paper.PRODUCT_ID=m.id

  LEFT JOIN  WOM_TASK_LISTS task on m.id = task.product

  where 

  DateDiff(mm,paper.CREATE_TIME,getdate())=2 and paper.WEIGH>0 and paper.IS_CANCEL <> 1

 ) q  

 where  q.纸种='原纸' and q.产品代码='UB-14.5' and q.批次='Y220302D05510'

 GROUP BY q.车间,q.颜色,q.纸种,q.批次,q.产品代码

 ORDER BY q.车间,q.颜色,q.纸种,q.批次,q.产品代码 asc

 SELECT top 10 * FROM WOM_PAPER_RECORDS WHERE PAPER_ROLL_CODE='Y220302D05510'