Sparkling Wine | Domaine Carneros Wines

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-04-06 18:02:21.0	2010-06-22 10:02:14.0	<p>Our Vintage Rosé is aged for a full three years in our cellar before release to enhance its natural aromas.  Rosé wines are often believed to be made only from Pinot Noir, but many including ours have some Chardonnay added. In creating our Rosé we worked to create a wine of great balance using 57% Pinot Noir and 43% Chardonnay, but at the same time, emphasizing fruity and floral characteristics to a greater extent than is evident in the Vintage Brut or Le Rêve Blanc de Blancs. <br /><br />This limited release Vintage Rosé is available only at the winery. <br /><br /><br /> <br /> </p>	1	1	0	0	1	1	0	2006Rose	[empty string]	[empty string]	[empty string]	[empty string]	7b4dcc1b-9739-fc16-2052-375c507fe504	[empty string]	0	http://www.domainecarneros.com/assets/images/wines/	2006 RoseSparkling.jpg	36.0000	432.0000	Bottle	Case	d5ca0dd1-df16-5cdd-a1f2-aeed170594b3	d5ca0dd1-df16-5cdd-a1f2-aeed170594b3	2006 Brut Rosé Sparkling	5216	6c4560d0-08ad-4d07-ac80-acf490c85c00	0.0000	0.0000	[empty string]	36.0000	432.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='d5ca0dd1-df16-5cdd-a1f2-aeed170594b3'