'

No products match your search.
 
Copyright 2016. Gundlach Bundschu            Venue Info  |   Map & Directions  |   Contact Us  |   Wine Website by eWinery Solutions
Query
Template: /share/production/deployment/vinsuite-production/cfcs/inventory.cfc
Execution Time: 0.935 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
SELECT InventoryID, ProductID, ProductTypeID, ProductName, ProductPriceID,
ProductSKU, WineryID, [Count], ISNULL(NULLIF(Allocated, ''), 0) AS Allocated, OutOfStockOptionID, OutOfStockMessage,
ISNULL(NULLIF(DisplayQuantityLeftAt, ''), 0) AS DisplayQuantityLeftAt, EmailNotificationAt, EmailTo, ISNULL(NULLIF(OutOfStockAt, ''), 0) AS OutOfStockAt
FROM Inventory WITH (NOLOCK)
WHERE WineryID IS NULL
AND ProductID IN (
SELECT P.ProductKeyID
FROM ProductsXKits PXK
JOIN Products P ON P.ProductID = PXK.ProductID
WHERE PXK.KitID = 'DF48E7E3-947A-676C-58BC-A11275C30FD0'
)
  InventoryID ProductID ProductTypeID ProductName ProductPriceID ProductSKU WineryID Count Allocated OutOfStockOptionID OutOfStockMessage DisplayQuantityLeftAt EmailNotificationAt EmailTo OutOfStockAt