一、原因：合并代码时代码漏掉了，导致调价数据异常

二、排查异常数据的SQL

--查询非指定部门的策略数据
SELECT
    * 
FROM
    aad_adjustprice_strategy_v2 
WHERE
    isautochecksalesadjustment = 0  and status=1
    LIMIT 100; --非指定部门的策略查询活动要包含销售调整结尾
    
    
SELECT
    y."name" "活动名称" 
FROM
    Aad_AdjustPriceData_Detail_V2 x
    INNER JOIN aad_campaign y ON x.customerid = y.customerid 
    AND x.ordersourceid = y.ordersourceid     
    AND x.campaignid = y.campaignid 
WHERE
    x.customerid = 1 
    AND x.strategyid in (select id from aad_adjustprice_strategy_v2 where isautochecksalesadjustment=0 and status=1 ) -- 策略ID    
    
    AND x.creationtime >= '2026-01-08 13:00:00' 
    AND y."name" not LIKE'%销售调整';
    
    
        
    --查询指定部门的策略数据
    select *from aad_adjustprice_strategy_v2 where isautochecksalesadjustment=1 and status=1 LIMIT 100
    
    
    --指定部门的策略查询活动不包含销售调整结尾
SELECT
x.creationtime,
    y."name" "活动名称" 
FROM
    Aad_AdjustPriceData_Detail_V2 x
    INNER JOIN aad_campaign y ON x.customerid = y.customerid 
    AND x.ordersourceid = y.ordersourceid 
    AND x.campaignid = y.campaignid 
WHERE
    x.customerid = 1 
    AND x.strategyid in (select id from aad_adjustprice_strategy_v2 where (isautochecksalesadjustment=1 or isautochecksalesadjustment is null) and status=1 ) -- 策略ID    
    AND x.creationtime >= '2026-01-08 13:00:00' 
    AND y."name"  LIKE'%销售调整%'
    and y.STATE='enabled'