2011 Huichica Music Festival Tee

This rockin' tee features the custom artwork for the Second Annual Huichica Music Festival.

Description:

The Second Annual Huichica Music Festival is Sonoma's largest festival for emerging indie artists. Get your limited edition tee in time for the festival, or simply snag a super-cool piece of wearable art. Can't make it to the show? Here's your chance to have a little piece of Huichica!

Made in the USA with super-soft cotton-poly blend. Available in men's and women's styles. Quantities limited.

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 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 = ? )

SQLPARAMETERS

array
1	6185411f-94a6-b92b-169c-97e048e80755