| 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 |
05b51f42-d084-3fac-3673-98f942b07e9f |
|
|
2009-08-10 12:07:19.0 |
2011-03-03 09:32:00.0 |
<p>The 2007 Famous Gate pays homage to our estate’s deep commitment and long experience with Pinot Noir. Between our extensive Carneros vineyards planted to a wide variety of clonal selections, our winemaker’s passion for Pinot Noir and our commitment to artisan winemaking techniques, the Famous Gate represents the pinnacle of our Pinot Noir bottlings. The climate of the Carneros is known for three essential Pinot-friendly elements—sunshine, cooling fog and afternoon wind—a balanced triad that coaxes distinction from the wines of the region. </p>
<p>This limited release wine is available only at the winery. <br /></p> |
[empty string] |
1 |
1 |
0 |
0 |
1 |
1 |
1 |
0 |
2007FamousGatePinotNoir |
[empty string] |
[empty string] |
[empty string] |
2007 Pinot Noir | The Famous Gate Pinot Noir | 2007 Carneros Pinot Noir |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
[empty string] |
0 |
http://www.domainecarneros.com/assets/images/wines/ |
2007%2DPinot%5FFamous%2DGate%2Ejpg |
68.0000 |
816.0000 |
Bottle |
Case |
05b51f42-d084-3fac-3673-98f942b07e9f |
05b51f42-d084-3fac-3673-98f942b07e9f |
2007 The Famous Gate Pinot Noir |
5208 |
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 |
05b51f42-d084-3fac-3673-98f942b07e9f |
| 3 |
05b51f42-d084-3fac-3673-98f942b07e9f |
| 4 |
05b51f42-d084-3fac-3673-98f942b07e9f |
| 5 |
05b51f42-d084-3fac-3673-98f942b07e9f |
| 6 |
05b51f42-d084-3fac-3673-98f942b07e9f |
| 7 |
05b51f42-d084-3fac-3673-98f942b07e9f |
|
|
25606 |
0.0000 |
0.0000 |
<div style="text-align: left;">The 2007 Famous Gate Pinot Noir is filled with blackberry, cherry, smoke, tea and baking spice. The palate is both richly textured and elegantly structured, factors that provide for immediate enjoyment as well as graceful maturation. <br /></div> |
68.0000 |
816.0000 |
cdc20456-1b78-7bfe-4c23-519d54dda8e1 |
0.0000 |
0.0000 |
