| 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 |
a5b62363-1cc4-fbb6-2345-1b24d7edf2bc |
|
|
2009-02-23 16:36:31.0 |
2012-04-13 15:19:33.0 |
<p>The fruit for this wine is sourced from all four Domaine Carneros vineyards in the rolling hills of Carneros. This blend exhibits the most fragrant characteristics present in select lots from these vineyards. <br /><br />The wine is fermented in small open-topped tanks and then aged for 10 months in Burgundian French oak barrels from cooperages that are specially selected to complement the aroma and flavor profile of this wine. </p>
<p>This limited release wine is available only at the winery.<br /><br /><br /></p> |
[empty string] |
0 |
1 |
0 |
1 |
1 |
1 |
0 |
2009AvantGardePinotNoir |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
[empty string] |
0 |
http://www.domainecarneros.com/assets/images/wines/ |
2009-pinot-noir.jpg |
[empty string] |
24.0000 |
288.0000 |
Bottle |
Case |
a5b62363-1cc4-fbb6-2345-1b24d7edf2bc |
a5b62363-1cc4-fbb6-2345-1b24d7edf2bc |
2009 Avant-Garde Pinot Noir |
AP100 |
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 |
16 |
| 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 |
a5b62363-1cc4-fbb6-2345-1b24d7edf2bc |
| 3 |
a5b62363-1cc4-fbb6-2345-1b24d7edf2bc |
| 4 |
a5b62363-1cc4-fbb6-2345-1b24d7edf2bc |
| 5 |
a5b62363-1cc4-fbb6-2345-1b24d7edf2bc |
| 6 |
a5b62363-1cc4-fbb6-2345-1b24d7edf2bc |
| 7 |
a5b62363-1cc4-fbb6-2345-1b24d7edf2bc |
|
|
[empty string] |
[empty string] |
[empty string] |
0.0000 |
0.0000 |
2009 Avant-Garde Pinot Noir |
Domaine Carneros Avant-Garde Pinot Noir was created to be the vanguard of the vintage, heralding the distinctive fresh fruit qualities of the Carneros Region. |
24.0000 |
288.0000 |
cdc20456-1b78-7bfe-4c23-519d54dda8e1 |
0.0000 |
0.0000 |