| 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 |
14337c94-c848-bca3-24e7-2c6538945fa1 |
|
|
2009-11-20 16:45:36.0 |
2012-04-20 15:54:46.0 |
<p>It is a cuvée of the very best of our estate Pinot Noir and estate Chardonnay, and with the 2006 vintage, its fourth release, these noble varietals are found in equal proportions. <br /><br />Delicate notes of fraise des bois (wild strawberry), nectarine blossom, tangerine, honeycomb and a touch of toast lead to an exceptionally luxurious finish. At once elegant and generous, the wine beckons immediate enjoyment, and will reward those with the patience to age it still further with added complexity.</p> |
[empty string] |
0 |
1 |
0 |
1 |
1 |
1 |
0 |
2006LeReveRose |
[empty string] |
[empty string] |
[empty string] |
Rose Sparkling Wine | Premium Wine |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
[empty string] |
0 |
http://www.domainecarneros.com/assets/images/wines/ |
2006-Le-Reve-_Rose1.jpg |
[empty string] |
110.0000 |
1320.0000 |
Bottle |
Case |
14337c94-c848-bca3-24e7-2c6538945fa1 |
14337c94-c848-bca3-24e7-2c6538945fa1 |
2006 Le Reve Rose Sparkling Wine |
RR105 |
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') |
|
[empty string] |
[empty string] |
[empty string] |
0.0000 |
0.0000 |
2006 Le Reve Rose Sparkling Wi |
<p>The term Le Rêve, French for “the dream,” is reserved for our most exquisite sparkling cuvées. Le Rêve Rosé is a wine of singular beauty, produced in limited quantities. </p> |
110.0000 |
1320.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=? |