'

No products match your search.
 
Copyright 2015. 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: 2.16 ms
Record Count: 0
Cached: No
Lazy: No
SQL:
SELECT InventoryID, ProductID, ProductTypeID, ProductName, ProductPriceID, ProductSKU, WineryID, [Count], Allocated, OutOfStockOptionID, OutOfStockMessage, DisplayQuantityLeftAt, EmailNotificationAt, EmailTo, 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