Pinot Noir | Domaine Carneros Pinot Noir

My Account | Check Out

Home

Shipping State

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

Ship to:

close window

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

query

RESULTSET

query
	BRANDID	DATEADDED	DATEMODIFIED	DESCRIPTION	ISACTIVE	ISACTIVEBYSUPPLIER	ISFAVORITE	ISFOREXPORT	ISSHOWNONADDORDER	ISTAXABLE	ISWINESTARTPAGE	MARKETINGURL	MEMBERTEASER	METATAGDESCRIPTION	METATAGKEYWORDS	METATAGTITLE	MODIFIEDBY	NONMEMBERTEASER	OVERRIDECOMPLIANCE	PHOTOPATH	PICTURE	PRICE1	PRICE2	PRICEUNIT1	PRICEUNIT2	PRODUCTID	PRODUCTKEYID	PRODUCTNAME	PRODUCTSKU	PRODUCTTYPEID	SALEPRICE1	SALEPRICE2	TEASER	WINEPRICEPERBOTTLE	WINEPRICEPERCASE	WINERYID	WINESALEPRICEPERBOTTLE	WINESALEPRICEPERCASE
1	[empty string]	2010-02-18 11:00:09.0	2010-06-28 15:44:23.0	[empty string]	1	1	0	0	1	1	0	2008AvantGardePinotNoir	[empty string]	[empty string]	[empty string]	2008 Avant-Garde Pinot Noir \| Domaine Carneros	7b4dcc1b-9739-fc16-2052-375c507fe504	[empty string]	0	http://www.domainecarneros.com/assets/images/wines/	2008%2DPinot%2DNoir%2DAvant%2DGarde%2Ejpg	24.0000	288.0000	Bottle	Case	e273914c-c603-2275-a9d5-c684f34ca597	e273914c-c603-2275-a9d5-c684f34ca597	2008 Avant-Garde Pinot Noir	5219	6c4560d0-08ad-4d07-ac80-acf490c85c00	0.0000	0.0000	This Avant-Garde is extremely aromatic, with the dominant fruit notes of black cherry, cranberry and raspberry accented with exotic spices and hints of toasty oak and orange peel.	24.0000	288.0000	cdc20456-1b78-7bfe-4c23-519d54dda8e1	0.0000	0.0000

CACHED

false

EXECUTIONTIME

SQL

SELECT P.* FROM Products P, ProductsXStates PXS WHERE P.ProductKeyID=PXS.ProductID AND PXS.StateCode='CA' AND PXS.isApproved=1 AND P.WineryID='cdc20456-1b78-7bfe-4c23-519d54dda8e1' AND P.isActive=1 AND P.isActiveBySupplier=1 AND P.ProductID='e273914c-c603-2275-a9d5-c684f34ca597'