| 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 |
81bd60de-1cc4-fbb6-23b3-a67283246965 |
|
|
2009-04-07 11:00:53.0 |
2009-10-12 12:11:05.0 |
<p>Our Rosé, has hints of wild strawberries, roses, jasmine, with notes of peach (San Francisco Chronicle Top 100 Wines, San Francisco Chronicle Wine Competition Doube Gold - January 2009) .</p>
<p>Riedel's limited edition pink "O" glass is an innovative new design in wine vessels from Maximillian Riedel, an 11th generation member of the famed Riedel crystal wine glass making family. Strikingly different because of the absence of a stem, these wine glasses look more like elegant tumblers. They are shaped to look as good as they feel in your hand, yet maintain all of the functionality of design you would expect from traditional Riedel stemware. These wine glasses are exceptional for casual, everyday use. Dishwasher safe.</p>
<p> </p>
<p>This gift item contains one bottle of the Domaine Carneros Cuvée de la Pompadour Brut Rosé Sparkling Wine & one pair (two glasses) of the Riedel "O" Champagne Tumbler. <br /><br />Remember! Include a gift message at checkout and we will include a gift card. </p> |
[empty string] |
0 |
1 |
0 |
1 |
1 |
1 |
0 |
PinkTumblerGift |
[empty string] |
[empty string] |
[empty string] |
Rose Sparkling Wine | Riedel Champagne Tumblers |
7b4dcc1b-9739-fc16-2052-375c507fe504 |
[empty string] |
0 |
http://www.domainecarneros.com/assets/images/wines/ |
Rose%2Dtumblers%2Ejpg |
[empty string] |
55.0000 |
[empty string] |
Case |
[empty string] |
81bd60de-1cc4-fbb6-23b3-a67283246965 |
81bd60de-1cc4-fbb6-23b3-a67283246965 |
Rosé Sparkling Wine & Pair of The Riedel "O" Champagne Tumblers |
5018 |
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 ('70a9e1f6-ab96-ce73-489e-57854fc1278a','31c3bede-fa01-aa57-5f23-b40801fbef07','31c0bb72-eb8e-6294-2839-035c088cd51e','31c2a7e0-f44a-ecac-87bb-fa3deeb5e5bc','4c70efd1-fe2b-9609-6293-b321e4a6f500','4cbe8bdb-c13f-8db1-f1b2-ca52e7db0100','70aea718-09b8-029f-e12f-a489822bc288','4cbfde2d-e200-f3e5-b619-e042df21f793') |
|
[empty string] |
[empty string] |
[empty string] |
0.0000 |
[empty string] |
[empty string] |
[empty string] |
55.0000 |
55.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=? |