Crisis or Reform Poster

Subtotal: $0.00

Description:

Crisis or Reform

Either way, Gundlach Bundschu is the life of the party.

By entering Gundlach Bundschu's Wine Store, you affirm that you are of
legal drinking age in the country where this site is accessed.

Ship to:

Pick up at the winery

close window

Enter your Email Address and your Username and Password will be sent to you.

query

RESULTSET

query
	ALLOCATED	COUNT	DISPLAYQUANTITYLEFTAT	EMAILNOTIFICATIONAT	EMAILTO	INVENTORYID	OUTOFSTOCKAT	OUTOFSTOCKMESSAGE	OUTOFSTOCKOPTIONID	PRODUCTID	PRODUCTNAME	PRODUCTPRICEID	PRODUCTSKU	PRODUCTTYPEID	WINERYID

CACHED

false

EXECUTIONTIME

SQL

SELECT InventoryID, ProductID, ProductTypeID, ProductName, ProductPriceID, ProductSKU, WineryID, [Count], Allocated, OutOfStockOptionID, OutOfStockMessage, DisplayQuantityLeftAt, EmailNotificationAt, EmailTo, OutOfStockAt FROM Inventory WHERE WineryID = ? AND ProductID IN ( SELECT P.ProductKeyID FROM ProductsXKits PXK JOIN Products P ON P.ProductID = PXK.ProductID WHERE PXK.KitID = ? )

SQLPARAMETERS

array
1	0ac76744-1b78-7bfc-a22f-fd38bb04664d
2	1e516c9a-1b78-7bfc-a241-6f18a3c2495d