| RESULTSET |
| query |
| |
BRANDID |
COGS1 |
COGS2 |
COSTPERBOTTLE |
COSTPERCASE |
CUSTOMWINEATTRIBUTES |
DATEADDED |
DATEMODIFIED |
DESCRIPTION |
FACEBOOKTEASER |
ISACTIVE |
ISACTIVEBYSUPPLIER |
ISFAVORITE |
ISSHOWNONADDORDER |
ISTAXABLE |
ISWEBSERVICEENABLED |
ISWINESTARTPAGE |
MARKETINGURL |
MEMBERTEASER |
METATAGDESCRIPTION |
METATAGKEYWORDS |
METATAGTITLE |
MODIFIEDBY |
NONMEMBERTEASER |
OVERRIDECOMPLIANCE |
PHOTOPATH |
PICTURE |
PLAINNAME |
PRICE1 |
PRICE2 |
PRICEUNIT1 |
PRICEUNIT2 |
PRODUCTID |
PRODUCTKEYID |
PRODUCTNAME |
PRODUCTSKU |
PRODUCTTYPEID |
PROMOTIONALPRICES |
RELATEDPRODUCTS |
RELATEDRECIPES |
REPORTGROUPID |
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 |
8704dc08-f67c-2816-aafb-c0e7981dddea |
|
|
2011-01-14 16:13:18.0 |
2012-01-30 11:27:45.0 |
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<meta content="Word.Document" name="ProgId" />
<meta content="Microsoft Word 11" name="Generator" />
<meta content="Microsoft Word 11" name="Originator" />
<p>
<link href="file:///C:\DOCUME~1\LMITCH~1\LOCALS~1\Temp\msohtml1\01\clip_filelist.xml" rel="File-List" /><font size="2">The blend of the 2005 Le Rêve is 99% chardonnay selected from an array of five different estate-grown clones with 1% pinot blanc.<span style=""> </span>It has been aged in the bottle on the lees for five and a half years. The appellation is 100% Carneros, 100% from the 2005 vintage and 100% estate-grown.<span style=""> </span></font></p>
<!--[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]--><style type="text/css">
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:none;
font-size:12.0pt;
mso-bidi-font-size:10.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
layout-grid-mode:line;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style><!--[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]--> |
[empty string] |
0 |
1 |
0 |
1 |
1 |
1 |
0 |
2005LeReveBlancdeBlancs |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
[empty string] |
0 |
http://www.domainecarneros.com/assets/images/wines/ |
2005-Le-Reve.jpg |
[empty string] |
95.0000 |
1140.0000 |
Bottle |
Case |
8704dc08-f67c-2816-aafb-c0e7981dddea |
8704dc08-f67c-2816-aafb-c0e7981dddea |
2005 Le Reve Blanc de Blancs Sparkling Wine |
LR101 |
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 ('c849cb5c-0f6e-4551-b57f-50f9e0f61fa7','ae3b2752-f6d1-2372-c9b2-d2ccb88c2740') |
|
[empty string] |
[empty string] |
[empty string] |
0.0000 |
0.0000 |
[empty string] |
<p>The 2005 Le Rêve is the fourteenth vintage in a highly distinguished line of Blanc de Blancs, repeatedly voted Best of Class. <span style="FONT-WEIGHT: bold">95 Points</span>, <span style="FONT-STYLE: italic">Wine Enthusiast. <strong>92 Points</strong>, Wine Spectator.</span> </p> |
95.0000 |
1140.0000 |
cdc20456-1b78-7bfe-4c23-519d54dda8e1 |
0.0000 |
0.0000 |
|
| SQL |
SELECT
ProductID
,WineryID
,ProductTypeID
,ProductKeyID
,PhotoPath
,Picture
,ProductName
,ProductSKU
,Price1
,PriceUnit1
,SalePrice1
,COGS1
,Price2
,PriceUnit2
,SalePrice2
,COGS2
,WinePricePerBottle
,WinePricePerCase
,WineSalePricePerBottle
,WineSalePricePerCase
,CostPerBottle
,CostPerCase
,isActive
,isActiveBySupplier
,isWineStartPage
,Teaser
,MemberTeaser
,NonMemberTeaser
,MetaTagTitle
,MetaTagKeywords
,MetaTagDescription
,Description
,DateAdded
,DateModified
,ModifiedBy
,isTaxable
,isShownOnAddOrder
,MarketingURL
,OverrideCompliance
,isFavorite
,BrandID
,facebookTeaser
,ShortName
,PlainName
,'' as customwineattributes
,'' as promotionalprices
,'' as relatedproducts
,'' as relatedrecipes
,isWebserviceEnabled
,ReportGroupID
FROM Products p
WHERE
ProductID=?
AND WineryID=? |