深圳智汇创想科技有限公司

SELECT o.CustomerID,
       a.OrderSourceType,
       o.WareHouseID,
       o.Country,
       k.SKU,
       Max(K.ID) AS ID
FROM   RB_OrderInfo o (nolock)
       INNER JOIN RB_OrderSource a
               ON o.CustomerID = a.CustomerID
                  AND o.OrdersourceID = a.ID
       INNER JOIN RB_OrderList k (nolock)
               ON o.CustomerID = k.CustomerID
                  AND o.OrderCode = k.OrderCode
WHERE  o.CustomerID = 1
       AND o.WareHouseID = 5312
       AND a.OrderSourceType = 2
       AND o.Country = 'DE'
       AND k.SKU IN ( '13966648', '13966932', '13966555', '13966290',
                      '13966271', '13965767', '13965901', '13965469',
                      '13965358', '13965063', '13965059', '13965016',
                      '13964272', '13966866', '13966431', '13966559',
                      '13966340', '13966105', '13965983', '13965859',
                      '13965336', '13964810', '13965419', '13965421',
                      '13965041', '13964878', '13964815', '13964651',
                      '13964116', '13964787', '13964691', '13964565',
                      '13964557', '13964511', '13964479', '13964490',
                      '13964435', '13964315', '13964105', '13964079',
                      '13964012', '13963853', '13963891', '13963692',
                      '13963642', '13963714', '13963636', '13963492',
                      '13963361', '13963311', '13963153', '13962612',
                      '13962533', '13962496', '13962444', '13962423',
                      '13962355', '13962173' )
       AND o.OrderState > 0
       AND o.ProductNumber = 1
       AND o.IsPay = 1
       AND o.IsStockOrder = 0
       AND o.DownLoadUpdateTime > '2000-01-01'
       AND o.PayTime < Dateadd(d, -1, Getdate())
       AND Isnull(o.TotalPrice, 0) > 0
GROUP  BY o.CustomerID,
          a.OrderSourceType,
          o.WareHouseID,
          o.Country,
          k.SKU;

IN中值太多，建议用表值参数 inner join 关联。