[步骤]
SELECT
OrderSourceSKU, ASINorItemID, ListingPrice, SalePrice, *
FROM
RB_Amazon_Product_Base ( NOLOCK )
WHERE
OrderSourceSKUID IN ( SELECT id FROM dbo.RB_Product_OrderSourceSKU ( NOLOCK ) WHERE CustomerID = 1 AND OrderSourceID = 5005 AND isDelete = 0 )
AND IsDelete = 0
AND AddTime < '2023-01-01'
AND OrderSourceSKU = 'BH9U6TI0FYT135527KIUY5YA'
[结果]
[期望]
服务是在15号进行同步，15号该Listing没有做价格修改，价格应该是一致的
查了上面几条数据得创建时间是2023.2.9号，那个时候还没有更改价格
select ordersourcesku,OrderSourceID,ListingPrice from RB_Amazon_Product_Base_Marking (nolock)
where CustomerID=1 AND ordersourcesku IN ('157U0928KGI1I','BH9U6TI0FYT135527KIUY5YA','JM9Q7L17Z9A49V46HGD47F4')