[步骤]
SELECT TOP 111 * FROM RB_Product_Risklevel_PlatformCountry WHERE PlatformId = 3 AND RiskLevel = 0 AND CountryShorthand = 'US' AND SKU IN ('14874439','9667642','14258733','14237957','14214545','14190118','19336179','19224000','19339875','19333783','19337949','12460764','12450466','12450874','12449249','12452931','12478343','12452123','12452113','12427601','12416509','12416061','12414547','12418638','12446587','12418261','12418257','9981606','9907218','9907067','9906920','9981586','9907203','9907041','9842622','9464771','9415725','12555488','9388668','12529779','12497279','19081812','12504766')
SELECT * FROM p_product_risklevel WHERE SKU IN ('14874439','9667642','14258733','14237957','14214545','14190118','19336179','19224000','19339875','19333783','19337949','12460764','12450466','12450874','12449249','12452931','12478343','12452123','12452113','12427601','12416509','12416061','12414547','12418638','12446587','12418261','12418257','9981606','9907218','9907067','9906920','9981586','9907203','9907041','9842622','9464771','9415725','12555488','9388668','12529779','12497279','19081812','12504766') AND SiteCode = 'US'
[结果]
风险等级不匹配[期望]
按sql的写法 就是
查询 ebay 美国的风险等级是
select max(riskLevel) from table where platformId in (-1,3) and country in ('','US')