| RESULTSET |
| query |
| |
BRANDID |
COGS1 |
COGS2 |
COSTPERBOTTLE |
COSTPERCASE |
CUSTOMWINEATTRIBUTES |
DATEADDED |
DATEMODIFIED |
DESCRIPTION |
FACEBOOKTEASER |
ISACTIVE |
ISACTIVEBYSUPPLIER |
ISFAVORITE |
ISFOREXPORT |
ISSHOWNONADDORDER |
ISTAXABLE |
ISWEBSERVICEENABLED |
ISWINESTARTPAGE |
MARKETINGFEE |
MARKETINGURL |
MARKETPLACESKU |
MEMBERTEASER |
METATAGDESCRIPTION |
METATAGKEYWORDS |
METATAGTITLE |
MODIFIEDBY |
NONMEMBERTEASER |
OVERRIDECOMPLIANCE |
PHOTOPATH |
PICTURE |
PLAINNAME |
PRICE1 |
PRICE2 |
PRICEUNIT1 |
PRICEUNIT2 |
PRODUCTID |
PRODUCTKEYID |
PRODUCTNAME |
PRODUCTSKU |
PRODUCTTYPEID |
PROMOTIONALPRICES |
SALEPRICE1 |
SALEPRICE2 |
SHORTNAME |
TEASER |
WINEPRICEPERBOTTLE |
WINEPRICEPERCASE |
WINERYID |
WINESALEPRICEPERBOTTLE |
WINESALEPRICEPERCASE |
| 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 |
ea027322-daba-1db9-a4b5-ab61bf2cc4ab |
|
|
2008-07-03 10:40:06.0 |
2011-08-10 15:33:42.0 |
<p>With all due respect to 2007, the 2009 might just be the vintage of the decade! Rain during berry set allowed only a modest crop level. But, the coolest summer in 20 years provided a long and mild growing season where our estate grown organic fruit attained full ripeness at a leisurely pace. <br /><br />Domaine Carneros Pinot Noir begins in our four different Certified Organic (CCOF) estate vineyards. A selection of eleven different clones/selections of Pinot Noir all contributed their unique personality to make a compelling blend. <br /><br />The fruit was gently de-stemmed, leaving many whole berries. A “cold soak” followed for five full days prior to fermentation, which took 9 to 12 days in small open-topped vats. The fermenting must was punched three times a day to heighten color and flavor development. After pressing off, the finished wine went directly into French oak barrels where it was gently racked once during the 10 months of barrel aging. <br /><br /><br /><br /><br /></p> |
[empty string] |
1 |
1 |
0 |
0 |
1 |
1 |
1 |
0 |
[empty string] |
2009EstatePinotNoir |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Domaine Carneros Estate Pinot Noir |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
[empty string] |
0 |
http://www.domainecarneros.com/assets/images/wines/ |
2009 Pinot Noir Carneros3.jpg |
[empty string] |
35.0000 |
420.0000 |
Bottle |
Case |
ea027322-daba-1db9-a4b5-ab61bf2cc4ab |
ea027322-daba-1db9-a4b5-ab61bf2cc4ab |
2009 Domaine Carneros - Estate Pinot Noir |
DC106 |
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 * from promo_prices where couponid not in ('ae3b2752-f6d1-2372-c9b2-d2ccb88c2740') |
|
0.0000 |
0.0000 |
[empty string] |
<p>The palate delivers cedar, juicy red fruit flavors, and a persistent hint of dark chocolate with a broad richness of even-tempered tannin that stretches into a long finish. </p> |
35.0000 |
420.0000 |
cdc20456-1b78-7bfe-4c23-519d54dda8e1 |
0.0000 |
0.0000 |
|
| SQL |
SELECT
P.ProductID,P.WineryID,P.ProductTypeID,P.ProductKeyID,P.PhotoPath,P.Picture,P.ProductName,P.ProductSKU,P.Price1,P.PriceUnit1,P.SalePrice1,
P.Price2,P.PriceUnit2,P.SalePrice2,P.WinePricePerBottle,P.WinePricePerCase,P.WineSalePricePerBottle,P.WineSalePricePerCase,P.isActive,
P.isActiveBySupplier,P.isWineStartPage,P.Teaser,P.MemberTeaser,P.NonMemberTeaser,P.MetaTagTitle,P.MetaTagKeywords,P.MetaTagDescription,
P.Description,P.DateAdded,P.DateModified,P.ModifiedBy,P.isTaxable,P.isShownOnAddOrder,P.MarketingURL,P.OverrideCompliance,P.isFavorite,
P.BrandID,P.isForExport,P.facebookTeaser,P.isWebserviceEnabled,P.cogs1,P.cogs2,P.CostPerBottle,P.CostPerCase,P.MarketplaceSKU,P.MarketingFee,P.ShortName,P.PlainName
,'' as customwineattributes
,'' as promotionalprices
FROM Products P, ProductsXStates PXS
WHERE
P.ProductKeyID=PXS.ProductID
AND PXS.StateCode=?
AND PXS.isApproved=1
AND P.WineryID=?
AND P.isActive=1
AND P.isActiveBySupplier=1
AND P.ProductID=? |