| 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 |
8d826c94-036a-9cbe-474d-663afcee6e52 |
|
|
2011-04-25 09:33:45.0 |
2012-02-14 16:26:46.0 |
The highly praised 2007 vintage began very early with bud break in the vineyards occurring mid-March. The crop was small and cluster size small hence the resulting wine showed great intensity beginning with the first fermentation. The Brut cuvée has wonderful fruit aromas and elegant balance.<br /><br />The 2007 cuvée is composed of 60% Pinot Noir and 40% Chardonnay. Unusually, only 2% of the cuvée underwent malolactic fermentation prior to blending the cuvée for tirage bottling. The wine has been aged for three years prior to release and will further age gracefully in your cellar for 10 or more years.<br /> |
[empty string] |
1 |
1 |
0 |
0 |
1 |
1 |
1 |
0 |
[empty string] |
2007Brut |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Sparkling Wine | Domaine Carneros Sparkling Wine |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
[empty string] |
0 |
http://www.domainecarneros.com/assets/images/wines/ |
2007 brut.jpg |
[empty string] |
26.0000 |
312.0000 |
Bottle |
Case |
8d826c94-036a-9cbe-474d-663afcee6e52 |
8d826c94-036a-9cbe-474d-663afcee6e52 |
2007 Domaine Carneros Brut Cuvee |
BR111 |
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','31c2a7e0-f44a-ecac-87bb-fa3deeb5e5bc','31c3bede-fa01-aa57-5f23-b40801fbef07','70a9e1f6-ab96-ce73-489e-57854fc1278a','70aea718-09b8-029f-e12f-a489822bc288') |
|
0.0000 |
0.0000 |
[empty string] |
<span style="font-style: italic;"></span>Vintage dated each year, the Domaine Carneros Brut cuvée represents the best of Carneros Pinot Noir and Chardonnay made into a classic sparkling wine. <span style="font-weight: bold;">90 Points & Editor's Choice</span><!--, Wine Enthusiast[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:PunctuationKerning />
<w:ValidateAgainstSchemas />
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables />
<w:SnapToGridInCell />
<w:WrapTextWithPunct />
<w:UseAsianBreakRules />
<w:DontGrowAutofit />
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif][if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif][if !mso]><object
classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object>
<style>
st1\:*{behavior:url(#ieooui) }
</style>
<![endif][if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]--> |
26.0000 |
312.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=? |