| 1 |
[empty string] |
| query |
| RESULTSET |
| query |
| |
ATTRIBUTE |
ATTRIBUTEVALUEID |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT
cwa.attribute
,cwav.attributevalueid
FROM customwineattributes cwa
LEFT OUTER JOIN customwineattributevalues cwav ON cwa.attributeID = cwav.attributeID
LEFT OUTER JOIN productsxcustomwineattributevalues pxc ON cwav.attributevalueid = pxc.attributevalueid
WHERE pxc.productid = ?
ORDER BY cwav.displayorder asc, cwav.attributevalue asc |
| SQLPARAMETERS |
| array
|
|---|
| 1 |
c18481eb-0aba-21b5-d356-afeb014e85ca |
|
|
2008-06-25 13:57:44.0 |
2010-02-17 13:52:46.0 |
Vintage dated each year, the Domaine Carneros Brut cuvée represents the best of Carneros Pinot Noir and Chardonnay made into a classic sparkling wine.<br /><br />The 2005 vintage started with an early spring followed by a long cool summer that allowed the crop to mature to perfection. For the fourth year in a row the crop was small and the resulting fruit intense. The Brut cuvée has wonderful floral aromas and great balance. <br /><br />The 2005 cuvée is composed of 64% Pinot Noir, 34% Chardonnay and 2% Pinot Blanc. Approximately 8% of the cuvée underwent malolactic fermentation prior to blending the cuvée for tirage bottling. The wine has been aged for three years prior to release and will further age gracefully in your cellar (if you can resist opening). |
[empty string] |
0 |
1 |
0 |
1 |
1 |
1 |
BrutSparkling |
6 -11 Bottle Purchases (10% Discount applied at Check Out) <br />12+ Bottle Purchases (15% Discount applied at Check Out)
<h6>Chateau Society: <br />10% Discount for 1-5 Bottle Purchases <br />15% Discount for 6-11 Bottle Purchases <br />20% Discount for 12+ Bottle Purchases<br /></h6> |
[empty string] |
Brut Sparkling | Sparkling WS 92 Points Rating |
2005 Brut Cuvée Sparkling Wine | WS Rated 92 pts |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
6 -11 Bottle Purchases (10% Discount applied at Check Out) <br />12+ Bottle Purchases (15% Discount applied at Check Out)
<h6>Chateau Society: <br />10% Discount for 1-5 Bottle Purchases <br />15% Discount for 6-11 Bottle Purchases <br />20% Discount for 12+ Bottle Purchases<br /></h6> |
0 |
http://www.domainecarneros.com/assets/images/wines/ |
brut_shot.png |
26.0000 |
312.0000 |
Bottle |
Case |
c18481eb-0aba-21b5-d356-afeb014e85ca |
c18481eb-0aba-21b5-d356-afeb014e85ca |
2005 Vintage Brut Sparkling Wine |
5176 |
6c4560d0-08ad-4d07-ac80-acf490c85c00 |
| query |
| RESULTSET |
| query |
| |
APPLIESTO |
COUPONACCESSTYPEID |
COUPONCODE |
COUPONID |
COUPONNAME |
COUPONTYPEID |
DISCOUNT |
DISPLAYASNEWPRICE |
DISPLAYASPRICE |
DISPLAYPRICEALWAYS |
DISPLAYPRICEFOREVERYONE |
DISPLAYTEXT |
EXPIRYDATE |
FIXEDDOLLARS |
ISAPPLICABLE |
ISDISCOUNTOTHERSHIPPING |
ISDOLLARSOFF |
ISFIXEDDOLLARS |
ISLOWESTCOSTSHIPPING |
ONDOLLARVOLUMELESS |
ONDOLLARVOLUMEOVER |
ONQUANTITIESLESS |
ONQUANTITIESOVER |
STARTDATE |
|
| CACHED |
false |
| EXECUTIONTIME |
15 |
| SQL |
SELECT DISTINCT
c.couponid
,c.CouponName
,c.CouponAccessTypeID
,c.CouponCode
,c.CouponTypeID
,c.StartDate
,c.ExpiryDate
,c.Discount
,c.FixedDollars
,c.isFixedDollars
,c.isDollarsOff
,c.AppliesTo
,c.onQuantitiesOver
,c.onQuantitiesLess
,c.isLowestCostShipping
,c.isDiscountOtherShipping
,c.onDollarVolumeOver
,c.onDollarVolumeLess
,c.displayasprice
,c.displayasnewprice
,c.displaypricealways
,c.displaypriceforeveryone
,Cast(c.displaytext as nvarchar(Max)) as 'displaytext'
,0 as 'isapplicable'
FROM coupons c
LEFT OUTER JOIN couponsxcoupontypes cxct on cxct.couponid = c.couponid
LEFT OUTER JOIN couponexcludes ce on ce.couponid = c.couponid
WHERE c.wineryid = ?
AND c.issingleuse=0
AND c.isused=0
AND c.isforordergroup=0
AND c.appliesto='products'
AND c.displayasprice = 1
AND (ce.productid is NULL OR ce.productid <> ?)
AND (
c.coupontypeid = '17271DA7-969F-496A-86EF-896B09E32991'
OR (c.coupontypeid = 'e67b8c62-2e3d-417d-990e-f28af95a6fcd' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid IN (select productcategoryid from productsxproductcategories where productid=?))
OR (c.coupontypeid = '1f8a985b-2421-458a-99fb-a10bedc920a2' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = ?)
OR (c.coupontypeid = '802f4cea-8b85-46e6-9704-c5d792470f0d' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = (select producttypeid from products p where p.productid = ?))
OR (c.coupontypeid = '75352a6e-a93c-4f79-8aca-0f185ee3f6f0' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = (select winebrandid from wines w left outer join products p on w.wineid = p.productkeyid where p.productid = ?))
OR (c.coupontypeid = '75352a6e-a93c-4f79-8aca-0f185ee3f6f0' AND cxct.keycodeid IS NOT NULL AND cxct.keycodeid = (select thirdpartywinebrandid from thirdpartywines tpw left outer join products p on tpw.thirdpartywineid = p.productkeyid where p.productid = ?))
)
AND (c.onquantitiesover = 0
OR c.displaypricealways = 1
)
AND (c.onquantitiesless is null
OR c.displaypricealways = 1
)
AND (c.ondollarvolumeover = 0
OR c.displaypricealways = 1
)
AND (c.ondollarvolumeless is null
OR c.displaypricealways = 1
)
AND (c.displaypriceforeveryone = 1
) |
| SQLPARAMETERS |
| array
|
|---|
| 1 |
cdc20456-1b78-7bfe-4c23-519d54dda8e1 |
| 2 |
c18481eb-0aba-21b5-d356-afeb014e85ca |
| 3 |
c18481eb-0aba-21b5-d356-afeb014e85ca |
| 4 |
c18481eb-0aba-21b5-d356-afeb014e85ca |
| 5 |
c18481eb-0aba-21b5-d356-afeb014e85ca |
| 6 |
c18481eb-0aba-21b5-d356-afeb014e85ca |
| 7 |
c18481eb-0aba-21b5-d356-afeb014e85ca |
|
|
[empty string] |
[empty string] |
0.0000 |
0.0000 |
<p>Our Vintage Brut represents the best of Carneros pinot noir and chardonnay made into a classic sparkling wine. </p>
<p><strong><em>Food and Wine Magazine</em></strong>, October 2009 , Best United States Sparkling Wine </p>
<p><strong><em>Wine Spectator,</em></strong> September 2008, 92 points<br /><br /><br /><br /></p> |
26.0000 |
312.0000 |
cdc20456-1b78-7bfe-4c23-519d54dda8e1 |
0.0000 |
0.0000 |
