Description
To get SKU detected per sessionuid
Query :
To get SKU detected per sessionuid
Query :
SELECT app.AssetPurityId, app.ProductId, p.Product,app.IsDeleted,count(app.ProductId)FacingsCount
FROM AssetPurityProduct app
JOIN Product p ON p.ProductId = app.ProductId
WHERE AssetPurityId IN ('118738419','118738420')
--AND p.LocalName LIKE 'Minute Maid%'
AND p.ProductId = '2287207'
GROUP BY AssetPurityId, app.ProductId, p.Product, app.IsDeleted
--------------------------------------------------