| 1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
| query |
| RESULTSET |
| query |
| |
ATTRIBUTE |
ATTRIBUTEVALUEID |
|
| CACHED |
false |
| EXECUTIONTIME |
15 |
| 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 |
d5ca0dd1-df16-5cdd-a1f2-aeed170594b3 |
|
|
2010-04-06 18:02:21.0 |
2012-05-08 09:49:53.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 62% Pinot Noir and 38% 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 /><em>2012 Ultimate Wine Challenge, 94 Points, Chairman's Trophy</em><br /><br /><br /> <br /> </p> |
[empty string] |
1 |
1 |
0 |
0 |
1 |
1 |
1 |
0 |
[empty string] |
2008BrutRose |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
[empty string] |
0 |
http://www.domainecarneros.com/assets/images/wines/ |
2008 brut rose.jpg |
[empty string] |
36.0000 |
432.0000 |
Bottle |
Case |
d5ca0dd1-df16-5cdd-a1f2-aeed170594b3 |
d5ca0dd1-df16-5cdd-a1f2-aeed170594b3 |
2008 Brut Rosé Sparkling Wine |
RS08B |
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 |
0 |
| 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 |
d5ca0dd1-df16-5cdd-a1f2-aeed170594b3 |
| 3 |
d5ca0dd1-df16-5cdd-a1f2-aeed170594b3 |
| 4 |
d5ca0dd1-df16-5cdd-a1f2-aeed170594b3 |
| 5 |
d5ca0dd1-df16-5cdd-a1f2-aeed170594b3 |
| 6 |
d5ca0dd1-df16-5cdd-a1f2-aeed170594b3 |
| 7 |
d5ca0dd1-df16-5cdd-a1f2-aeed170594b3 |
|
|
0.0000 |
0.0000 |
[empty string] |
In creating our Rosé we worked to create a wine of great balance using 62% Pinot Noir and 38% Chardonnay, but at the same time, emphasizing fruity and floral characteristics. |
36.0000 |
432.0000 |
cdc20456-1b78-7bfe-4c23-519d54dda8e1 |
0.0000 |
0.0000 |