| 1 |
[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 |
ffae1b20-b218-16d6-c3a8-6aecbe1aeb21 |
|
|
2009-11-16 17:07:30.0 |
2010-09-08 16:19:25.0 |
<p>Wild hibiscus, syrup and sparkling wine create this exquisite cocktail! </p>
<p>Each flower sits beautifully in the bottom of your glass as the bubbles stream off and delicately open each petal. The syrup adds delicious raspberry and rhubarb flavor to your drink. </p>
<p>Features: Handmade in Sydney, Australia. Just 3 ingredients; Wild hibiscus flowers, cane sugar and water. Flowers are cooked in the jar and vacuum-sealed to give them a shelf life of 2 years. Each flower is hand packed to preserve shape and quality. Adds a vibrant crimson color and delicious raspberry and rhubarb flavor to cocktails. Completely edible. 8 page cocktail guide on the lid. Simply place a flower in your glass, add a dash of the syrup and top with Domaine Carneros Brut Cuvee Sparkling Wine. </p>
<p>Size: 8.8 oz jar. Includes: Approximately 11 hibiscus flowers (<em>Sparkling wine and flutes sold separately</em>)</p>
<p> </p>
<p><em>Gift idea: Pair with our Brut Vintage Cuvée.</em></p> |
[empty string] |
1 |
1 |
0 |
0 |
1 |
1 |
1 |
0 |
WildHibiscusSparklingCocktail |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
[empty string] |
0 |
http://www.domainecarneros.com/assets/images/products/ |
flute%5Fhibiscus1%2Ejpg |
10.9500 |
0.0000 |
[empty string] |
[empty string] |
ffae1b20-b218-16d6-c3a8-6aecbe1aeb21 |
ffae1b20-b218-16d6-c3a8-6aecbe1aeb21 |
Wild Hibiscus Flower in Syrup |
[empty string] |
d1103805-a836-4621-99bb-e04162c228dd |
| 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 |
ffae1b20-b218-16d6-c3a8-6aecbe1aeb21 |
| 3 |
ffae1b20-b218-16d6-c3a8-6aecbe1aeb21 |
| 4 |
ffae1b20-b218-16d6-c3a8-6aecbe1aeb21 |
| 5 |
ffae1b20-b218-16d6-c3a8-6aecbe1aeb21 |
| 6 |
ffae1b20-b218-16d6-c3a8-6aecbe1aeb21 |
| 7 |
ffae1b20-b218-16d6-c3a8-6aecbe1aeb21 |
|
|
17921 |
0.0000 |
0.0000 |
[empty string] |
[empty string] |
[empty string] |
cdc20456-1b78-7bfe-4c23-519d54dda8e1 |
[empty string] |
[empty string] |