| 1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[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 |
4418815c-becc-66db-0e53-430b1af91195 |
|
|
2011-07-19 13:31:21.0 |
2011-09-29 15:26:14.0 |
<p><font size="3"><span style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10pt">The blend of the 2002 Le Rêve is 99% chardonnay selected from five different estate-grown clones and 1% estate pinot blanc<span></span>. Giving the impression of fine oak barrel aging, the wine’s hint of vanilla is characteristic of the impeccable Carneros fruit which also supported a smaller than usual dosage.</span></font></p> |
[empty string] |
0 |
1 |
0 |
1 |
1 |
1 |
0 |
2002LateDisgorgedLeReve |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
[empty string] |
0 |
http://www.domainecarneros.com/assets/images/wines/ |
02LDLeReve_web2.jpg |
[empty string] |
105.0000 |
1260.0000 |
Bottle |
Case |
4418815c-becc-66db-0e53-430b1af91195 |
4418815c-becc-66db-0e53-430b1af91195 |
2002 Late Disgorged Le Reve Blanc de Blancs |
LL103 |
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 |
4418815c-becc-66db-0e53-430b1af91195 |
| 3 |
4418815c-becc-66db-0e53-430b1af91195 |
| 4 |
4418815c-becc-66db-0e53-430b1af91195 |
| 5 |
4418815c-becc-66db-0e53-430b1af91195 |
| 6 |
4418815c-becc-66db-0e53-430b1af91195 |
| 7 |
4418815c-becc-66db-0e53-430b1af91195 |
|
|
[empty string] |
[empty string] |
[empty string] |
0.0000 |
0.0000 |
[empty string] |
<font size="2"><span style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10pt">Aged nearly nine years <i>en bouteille, </i></span><span style="FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10pt">the 2002 Late Disgorged Le Rêve is a testament to patience.</span></font> |
105.0000 |
1260.0000 |
cdc20456-1b78-7bfe-4c23-519d54dda8e1 |
0.0000 |
0.0000 |