Findin[ Advanced Search ]
Include title and description
Related Searches:  browse this category
Refine search
Preferences
Distance
Please enter valid zipcode.
Please select a valid popular city.
Please enter valid zipcode or select a valid popular city.
Within miles of ZIP
See all matching eBay Stores
All items
Auctions only
Buy It Now only
2 results found for blood diamond [ Save this search ]
Page 1 of 1
We found other stuff close to what you're looking for
Retry your search in All Categories
See additional items from eBay Stores. Learn more.|RSS Learn more.
This page was last updated: Nov-25 17:08. Number of bids and bid amounts may be slightly out of date. See each listing for international shipping options and costs.

About eBay | Announcements | Security Center | Resolution Center | eBay Toolbar | Policies | Government Relations | Site Map | Help
Copyright © 1995-2009 eBay Inc. All Rights Reserved. Designated trademarks and brands are the property of their respective owners. Use of this Web site constitutes acceptance of the eBay User Agreement and Privacy Policy.
eBay official time
View CAL LogDiagnostics for Application Server: sq-wshop346/10.7.95.156

Application: Category Data

dominant category: 11232 DVDs & Movies
inferred category: 0
query frequency: 10991
total clicks: 6202

Application: Shortcut Surfacing Module

Shortcut Module Information:
RS_LISTVIEW_PLACEMENT:	7
RS_GALLERYVIEW_ROW:	2
RS_COVERAGE_TYPE:	Total Coverage
RS_TOP_DOMAINS:	6
RS_MIN_AGGREGATE_COVERAGE:	0.5
RS_MINIMUM_RESULTS:	500
RS_MAX_DOMAINS_DISPLAYED:	6
RS_DOMAIN_MIN_COVERAGE:	0.01
RS_DOMAIN_MIN_SUPPLY:	10

Application: Best Match Profile

Search request Module
site_id = 0 and profileId = 2464
Profile tracker id: Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2
Profile Expression: Pr3(((EQ(IsAdFormat,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,1,25000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceKnown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,150000,850000),BMSCALE(BMDIV(DecayedSalesCount,MAX(1,DecayedImpressionCount),100000000,0,1000000,1),0,1000000,1000,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((EQ(saleclass1,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(AND(EQ(USScore3,10000),EQ(TnS_xsh,50)),VARSET(BRValue,985000),1000000)),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceUnknown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,350000,650000),BMSCALE(BMNORM(IQPredictedQuality,100,9000,6000,15000),0,9000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,25000),1000000,0)))

site_id = 0 and profileId = 1145
Cannot find profileTrackerId. Look up again for SiteId= -1
Profile tracker id: Pr1145_1
Profile Expression: Pr(TitleRel(100))

site_id = 0 and profileId = 1145
Cannot find profileTrackerId. Look up again for SiteId= -1
Profile tracker id: Pr1145_1
Profile Expression: Pr(TitleRel(100))


SIF expansion component
site_id = 0 and profileId = 2465
Profile tracker id: Pr2465_5_Ed105_2_Ed105_2
Profile Expression: Pr3(((MACRO(IsFixedPriceKnown,$ThresholdImpression$,$ThresholdTimeOnSite$)),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,150000,850000),BMSCALE(BMDIV(DecayedSalesCount,MAX(1,DecayedImpressionCount),100000000,0,1000000,1),0,1000000,1000,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((MACRO(IsFixedPriceUnknown,$ThresholdImpression$,$ThresholdTimeOnSite$)),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,350000,650000),BMSCALE(IF(EQ(saleclass1,1),BMNORM(IQPredictedQuality,100,100000,6000,14207),BMNORM(IQPredictedQuality,100,100000,6000,9920)),0,100000,1000,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0)))

site_id = 0 and profileId = 2464
Profile tracker id: Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2
Profile Expression: Pr3(((EQ(IsAdFormat,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,1,25000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceKnown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,150000,850000),BMSCALE(BMDIV(DecayedSalesCount,MAX(1,DecayedImpressionCount),100000000,0,1000000,1),0,1000000,1000,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((EQ(saleclass1,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(AND(EQ(USScore3,10000),EQ(TnS_xsh,50)),VARSET(BRValue,985000),1000000)),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceUnknown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,350000,650000),BMSCALE(BMNORM(IQPredictedQuality,100,9000,6000,15000),0,9000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,25000),1000000,0)))

site_id = 0 and profileId = 2464
Profile tracker id: Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2
Profile Expression: Pr3(((EQ(IsAdFormat,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,1,25000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceKnown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,150000,850000),BMSCALE(BMDIV(DecayedSalesCount,MAX(1,DecayedImpressionCount),100000000,0,1000000,1),0,1000000,1000,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((EQ(saleclass1,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(AND(EQ(USScore3,10000),EQ(TnS_xsh,50)),VARSET(BRValue,985000),1000000)),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceUnknown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,350000,650000),BMSCALE(BMNORM(IQPredictedQuality,100,9000,6000,15000),0,9000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,25000),1000000,0)))

site_id = 0 and profileId = 2464
Profile tracker id: Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2
Profile Expression: Pr3(((EQ(IsAdFormat,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,1,25000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceKnown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,150000,850000),BMSCALE(BMDIV(DecayedSalesCount,MAX(1,DecayedImpressionCount),100000000,0,1000000,1),0,1000000,1000,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((EQ(saleclass1,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(AND(EQ(USScore3,10000),EQ(TnS_xsh,50)),VARSET(BRValue,985000),1000000)),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceUnknown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,350000,650000),BMSCALE(BMNORM(IQPredictedQuality,100,9000,6000,15000),0,9000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,25000),1000000,0)))

site_id = 0 and profileId = 2464
Profile tracker id: Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2
Profile Expression: Pr3(((EQ(IsAdFormat,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,1,25000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceKnown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,150000,850000),BMSCALE(BMDIV(DecayedSalesCount,MAX(1,DecayedImpressionCount),100000000,0,1000000,1),0,1000000,1000,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((EQ(saleclass1,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(AND(EQ(USScore3,10000),EQ(TnS_xsh,50)),VARSET(BRValue,985000),1000000)),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceUnknown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,350000,650000),BMSCALE(BMNORM(IQPredictedQuality,100,9000,6000,15000),0,9000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,25000),1000000,0)))

site_id = 0 and profileId = 2464
Profile tracker id: Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2
Profile Expression: Pr3(((EQ(IsAdFormat,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,1,25000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceKnown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,150000,850000),BMSCALE(BMDIV(DecayedSalesCount,MAX(1,DecayedImpressionCount),100000000,0,1000000,1),0,1000000,1000,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((EQ(saleclass1,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(AND(EQ(USScore3,10000),EQ(TnS_xsh,50)),VARSET(BRValue,985000),1000000)),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceUnknown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,350000,650000),BMSCALE(BMNORM(IQPredictedQuality,100,9000,6000,15000),0,9000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,25000),1000000,0)))

site_id = 0 and profileId = 2464
Profile tracker id: Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2
Profile Expression: Pr3(((EQ(IsAdFormat,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,1,25000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceKnown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,150000,850000),BMSCALE(BMDIV(DecayedSalesCount,MAX(1,DecayedImpressionCount),100000000,0,1000000,1),0,1000000,1000,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((EQ(saleclass1,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(AND(EQ(USScore3,10000),EQ(TnS_xsh,50)),VARSET(BRValue,985000),1000000)),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceUnknown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,350000,650000),BMSCALE(BMNORM(IQPredictedQuality,100,9000,6000,15000),0,9000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,25000),1000000,0)))

site_id = 0 and profileId = 2464
Profile tracker id: Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2
Profile Expression: Pr3(((EQ(IsAdFormat,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,1,25000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceKnown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,150000,850000),BMSCALE(BMDIV(DecayedSalesCount,MAX(1,DecayedImpressionCount),100000000,0,1000000,1),0,1000000,1000,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((EQ(saleclass1,1)),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(AND(EQ(USScore3,10000),EQ(TnS_xsh,50)),VARSET(BRValue,985000),1000000)),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((AND(MACRO(IsFixedPriceUnknown,$ThresholdImpression$,$ThresholdTimeOnSite$),OR(EQ(eBaySaleType,7),EQ(eBaySaleType,9)))),BMMUL(BMSCALE(BMNORM(TitleRel,100,1000000,-32000,32000),0,1000000,350000,650000),BMSCALE(BMNORM(IQPredictedQuality,100,9000,6000,15000),0,9000,1,1000000),BMSCALE(EXPRLIST(VARSET(BRValue,1000000),VARSET(FSH,MACRO(FreeShippingInSite,$SiteId$)),IF(LT(USScore3,10000),VARSET(BRValue,500000),IF(GT(USScore3,10000),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1270000),VARSET(BRValue,1240000)),IF(EQ(VARUSE(FSH),1),VARSET(BRValue,1090000),IF(EQ(TnS_xsh,50),VARSET(BRValue,900000),1000000)))),VARUSE(BRValue)),0,1000000,0,1000000),1000000,0))((),BMMUL(BMSCALE(BMNORM(SUB(NOW,EndTime),100,1000000,-864000,0),0,1000000,1,25000),1000000,0)))

Application: SIBE Services:

Query : blood diamond
Url : http://sibeclassic-qry-sqw-001.vip.ebay.com:9090/koios?Qy=blood+diamond&Si=0&Aq=0.9&Vr=2&Sr=SIFFTAS+KWNV&Rf=0&Rl=0&Sq=0&Qr=blood+diamond
Query : blood diamond
Url : http://sibeclassic-qry-sqw-001.vip.ebay.com:9090/koios?Qy=blood+diamond&Si=0&Aq=0.0&Vr=2&Sr=SERENDIP&Rf=5&Rl=5&Sq=0&Qr=blood+diamond&Ca=279

Application: Query Constraint for - core_all_matching_items_orch:PageMA2ShowItems:M168:2464:Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2

[ShowInFinding3 - EBAY_MAIN=0 MAIN=0]
  ShowInSite5("0","0")

[CURRENT_ACTIVE]
  AND(
      LESSTHANEQUAL(SafeStartTime,"NOW"),
      GREATERTHAN(EndTime,"NOW"))

[MskuView - 1]
  MskuView("1")

[AllCats - 279]
  EQUAL(AllCats,"279")

[SIBEExpression - AND(OR(AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),P...]
  AND(
      OR(
          AND("AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))")))

Application: core_all_matching_items_orch:PageMA2ShowItems:M168:2464:Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2

  • SearchQuery:AND(MACRO(ShowInSite5,0,0),MACRO(MskuView,1),EQ(AllCats,279),LE(SafeStartTime,NOW),GT(EndTime,NOW),AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))))
  • CompleteBackendQuery:callname=DSAggregate&requestencoding=NV&responseencoding=NV&dsHdr=0;2;4&Vr=0.1&Qy=AND%28MACRO%28ShowInSite5%2C0%2C0%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C279%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2CAND%28AND%28blood%2COR%28PHRASE%28april%2Cbirth%2Cstone%29%2CPHRASE%28april%2Cbirth%2Cstones%29%2CPHRASE%28april%2Cbirthstone%29%2CPHRASE%28april%2Cbirthstones%29%2CPHRASE%28birthstone%2Cfor%2Capril%29%2Cdiamond%2Cdiamonds%2CEQ%28ATTR%28Birthstone%2Cdf%29%2CNAME%28April%2520%2528Diamond%2529%2Cdf%29%29%2CEQ%28ATTR%28Main%2520Stone%2Cdf%29%2CNAME%28Diamond%2Cdf%29%29%29%29%29%29&Sp=RELEVANCE_SORT2&Nr=50&So=Decreasing&St=Num=1&flpr=30%7C300%7C2.13%7C0.8%7C0.8%7C3%7C100000000%7C30&Dd=DEDUP(ParentID,EQ(ParentID,0))&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%29+SHIPCALC%28Fu%2CFa%2C1%2C0%2C0%2C2147483647%2C5%29+Ctry+eBayGal+QuantitySold+BinPrice+SafeStartTime+ParenteBayPicURL+MACRO%28EffectiveStartTime%29+IsSif+eBayPayPal+EndTime+MskuTraitNames+Quantity+MACRO%28IsFeaturedFirst%29+StartTime+SoldAsBestOffer+PaymentTypes+eBaySaleType+Bids+BestOffer+Title+Attr3804+attr650+DescriptionFormatted+attr651+eBayFeatured+MotorsSubmodel+MACRO%28FormatBucket%2C1%2C450%2C86400000%29+PostCode+OriginalIndexTime+ParentSuperGalleryCount+ProdReferenceId+PersistentBIN+PowerSellerFlag+eBayBin+IsClassifiedFormat+ParentSuperGalleryVersion+SuperGalleryCount+eBayPicURL+ShippingFlag+ParentGalleryVer+BuyerFixedShippingCost+SoldAsBin+eBayGTC+SuperGalleryVersion+FlatShipCost+ParentID+GalleryOffset+Site+GiftIcon+eBayChar+ItemSubtitle+eBayGalFeatured+InsuranceReqdFlag+InsuranceFee+CurrentPrice+IsSuperSize+MotorsSubtitle+ATTR%28ProductType%29+SellerID+IsMsku+LeafCats&Gb=%7BHASATTR%28ProdReferenceId%29,COUNT,Incr,0,0,0,0+%7D+%7BStoreSellerID,COUNT,Decrv%280%29,0,150,0,0+%7D+%7BSite,COUNT,Incr,0,0,0,0+%7D+%7BDsaPseudo,SUBCAT(%220%22,%22279%22),Incr,0,0,0,0+DSAJoin+qd.category.category+%2B%3D+mst.LeafCats+DSAWhere+qd.query.query+%3D+%22blood%2Bdiamond%22+AND+qd.site.site+%3D+%220%22%7D+%7BDsaPseudo,SUBDAP(%22_%7C_%22),Incr,0,0,0,0+DSAJoin+qd.dap.dap+%2B%3D+qd.dap.dap+DSAWhere+qd.query.query+%3D+%22kw%3Ablood%2Bdiamond%22+AND+qd.site.site+%3D+%220%22%7D&Im=MACRO%28FormatBucket%2C1%2C450%2C86400000%29&Rkw=%5Bkeyword%3Dblood+diamond%2Csite%3D0%2Ccategory%3D279%5D&Pr=Pr3%28%28%28EQ%28IsAdFormat%2C1%29%29%2CBMMUL%28BMSCALE%28BMNORM%28SUB%28NOW%2CMACRO%28EffectiveStartTime%29%29%2C-100%2C1000000%2C0%2C864000%29%2C0%2C1000000%2C1%2C25000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CVARSET%28FSH%2CMACRO%28FreeShippingInSite%2C0%29%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28GT%28USScore3%2C10000%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1270000%29%2CVARSET%28BRValue%2C1240000%29%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1090000%29%2CIF%28EQ%28TnS_xsh%2C50%29%2CVARSET%28BRValue%2C900000%29%2C1000000%29%29%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%28%28AND%28MACRO%28IsFixedPriceKnown%2C450%2C86400000%29%2COR%28EQ%28eBaySaleType%2C7%29%2CEQ%28eBaySaleType%2C9%29%29%29%29%2CBMMUL%28BMSCALE%28BMNORM%28TitleRel%2C100%2C1000000%2C-32000%2C32000%29%2C0%2C1000000%2C150000%2C850000%29%2CBMSCALE%28BMDIV%28DecayedSalesCount%2CMAX%281%2CDecayedImpressionCount%29%2C100000000%2C0%2C1000000%2C1%29%2C0%2C1000000%2C1000%2C1000000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CVARSET%28FSH%2CMACRO%28FreeShippingInSite%2C0%29%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28GT%28USScore3%2C10000%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1270000%29%2CVARSET%28BRValue%2C1240000%29%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1090000%29%2CIF%28EQ%28TnS_xsh%2C50%29%2CVARSET%28BRValue%2C900000%29%2C1000000%29%29%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%28%28EQ%28saleclass1%2C1%29%29%2CBMMUL%28BMSCALE%28BMNORM%28SUB%28NOW%2CEndTime%29%2C100%2C1000000%2C-864000%2C0%29%2C0%2C1000000%2C1%2C1000000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28AND%28EQ%28USScore3%2C10000%29%2CEQ%28TnS_xsh%2C50%29%29%2CVARSET%28BRValue%2C985000%29%2C1000000%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%28%28AND%28MACRO%28IsFixedPriceUnknown%2C450%2C86400000%29%2COR%28EQ%28eBaySaleType%2C7%29%2CEQ%28eBaySaleType%2C9%29%29%29%29%2CBMMUL%28BMSCALE%28BMNORM%28TitleRel%2C100%2C1000000%2C-32000%2C32000%29%2C0%2C1000000%2C350000%2C650000%29%2CBMSCALE%28BMNORM%28IQPredictedQuality%2C100%2C9000%2C6000%2C15000%29%2C0%2C9000%2C1%2C1000000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CVARSET%28FSH%2CMACRO%28FreeShippingInSite%2C0%29%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28GT%28USScore3%2C10000%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1270000%29%2CVARSET%28BRValue%2C1240000%29%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1090000%29%2CIF%28EQ%28TnS_xsh%2C50%29%2CVARSET%28BRValue%2C900000%29%2C1000000%29%29%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%28%28%29%2CBMMUL%28BMSCALE%28BMNORM%28SUB%28NOW%2CEndTime%29%2C100%2C1000000%2C-864000%2C0%29%2C0%2C1000000%2C1%2C25000%29%2C1000000%2C0%29%29%29&Es=MACRO%28FormatBucket%2C1%2C450%2C86400000%29%2C0%3A74%25%3B1%3A20%25%3B2%3A7%25%2C50&Qi=core_all_matching_items_orch%3APageMA2ShowItems%3AM168%3A2464%3APr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2:1259197756_0x7110.7.95.156:sq-wshop346:books.shop.ebay.com:v3shopcore
  • SearchIndex:DSA
  • BackendHost:sqwsn-stitle255+sqwsn-stitle901+sqwsn-stitle290+sqwsn-stitle988+sqwsn-stitle481+sqwsn-stitle326+sqwsn-stitle492+sqwsn-stitle350+sqwsn-stitle557+sqwsn-stitle122+sqwsn-stitle576+sqwsn-stitle428+sqwsn-stitle205+sqwsn-stitle813+sqwsn-stitle814+sqwsn-stitle815+sqwsn-agg140
  • QueryTimeInMicroSec:47277
  • NumMatched:2
  • NumReturned:2

Application: fetch_featuredfirst_items:PageMA2ShowItems:C2:Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2:Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2

  • SearchQuery:AND(MACRO(ShowInSite5,0,0),MACRO(MskuView,1),EQ(AllCats,279),MACRO(IsFeaturedFirstTnsFiltered),EQ(USLevel,1),LE(SafeStartTime,NOW),GT(EndTime,NOW),AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))))
  • CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28ShowInSite5%2C0%2C0%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C279%29%2CMACRO%28IsFeaturedFirstTnsFiltered%29%2CEQ%28USLevel%2C1%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2CAND%28AND%28blood%2COR%28PHRASE%28april%2Cbirth%2Cstone%29%2CPHRASE%28april%2Cbirth%2Cstones%29%2CPHRASE%28april%2Cbirthstone%29%2CPHRASE%28april%2Cbirthstones%29%2CPHRASE%28birthstone%2Cfor%2Capril%29%2Cdiamond%2Cdiamonds%2CEQ%28ATTR%28Birthstone%2Cdf%29%2CNAME%28April%2520%2528Diamond%2529%2Cdf%29%29%2CEQ%28ATTR%28Main%2520Stone%2Cdf%29%2CNAME%28Diamond%2Cdf%29%29%29%29%29%29&Sp=RELEVANCE_SORT2&Nr=10&So=Decreasing&St=Num=1&Dd=DEDUP(ParentID,EQ(ParentID,0))&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%29+SHIPCALC%28Fu%2CFa%2C1%2C0%2C0%2C2147483647%2C5%29+Ctry+eBayGal+QuantitySold+BinPrice+SafeStartTime+ParenteBayPicURL+MACRO%28EffectiveStartTime%29+IsSif+eBayPayPal+EndTime+MskuTraitNames+Quantity+MACRO%28IsFeaturedFirst%29+StartTime+SoldAsBestOffer+PaymentTypes+eBaySaleType+Bids+BestOffer+Title+Attr3804+attr650+DescriptionFormatted+attr651+eBayFeatured+MotorsSubmodel+MACRO%28FormatBucket%2C1%2C450%2C86400000%29+PostCode+OriginalIndexTime+ParentSuperGalleryCount+ProdReferenceId+PersistentBIN+PowerSellerFlag+eBayBin+IsClassifiedFormat+ParentSuperGalleryVersion+SuperGalleryCount+eBayPicURL+ShippingFlag+ParentGalleryVer+BuyerFixedShippingCost+SoldAsBin+eBayGTC+SuperGalleryVersion+FlatShipCost+ParentID+GalleryOffset+Site+GiftIcon+eBayChar+ItemSubtitle+eBayGalFeatured+InsuranceReqdFlag+InsuranceFee+CurrentPrice+IsSuperSize+MotorsSubtitle+ATTR%28ProductType%29+SellerID+IsMsku+LeafCats&Rkw=%5Bkeyword%3Dblood+diamond%2Csite%3D0%2Ccategory%3D279%5D&Pr=Pr%28TitleRel%28100%29%29&Qi=fetch_featuredfirst_items%3APageMA2ShowItems%3AC2%3APr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2%3APr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2:1259197757_0x7110.7.95.156:sq-wshop346:books.shop.ebay.com:v3shopcore
  • SearchIndex:ExpressSale
  • BackendHost:sqwsn-stitle617+sqwsn-stitle619+sqwsn-stitle777+sqwsn-stitle306+sqwsn-stitle991+sqwsn-stitle313+sqwsn-stitle661+sqwsn-stitle996+sqwsn-stitle808+sqwsn-stitle563+sqwsn-stitle160+sqwsn-stitle573+sqwsn-stitle204+sqwsn-stitle190+sqwsn-stitle223+sqwsn-stitle608+sqwsn-agg133
  • QueryTimeInMicroSec:39743
  • NumMatched:0
  • NumReturned:0

Application: DFN Surfacing Module

calling DFN surface algorithm 

Total Supply Count For Product Type:2
Total Demand Score For Product Type:0
PT coverage list
PT Name=Children's Books:	id=7502	supply=2	raw demand=0	demand=0.0	score=100.0	high confidence=85.0	light confidence=60.0
-------------------------
Qualfied PT list
PT Name=Children's Books:	id=7502	supply=2	raw demand=0	demand=0.0	score=100.0	high confidence=85.0	light confidence=60.0
-------------------------
PT Name=Children's Books:	id=7502	supply=2	raw demand=0	demand=0.0	score=100.0	high confidence=85.0	light confidence=60.0
WinningPT is Children's Books
Final WinningPT is Children's Books being displayed at top
DFN_NOT_DISPLAY_ASPECTS:false

Application: Query Constraint for - Dominant Product Type Finder:PageMA2ShowItems:DominantProductTypeQueryHandler:Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2:

AND(
    ShowInSite5("0","0"),
    AND(
        LESSTHANEQUAL(SafeStartTime,"NOW"),
        GREATERTHAN(EndTime,"NOW")),
    MskuView("1"),
    EQUAL(AllCats,"279"),
    AND(
        OR(
            AND("AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))"))))
[ProductType - US_Childrens_Books]
  EQUAL(ProductType,"US_Childrens_Books")

Application: Dominant Product Type Finder:PageMA2ShowItems:DominantProductTypeQueryHandler:Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2:

  • SearchQuery:AND(EQ(ATTR(ProductType),NAME(US_Childrens_Books)),MACRO(ShowInSite5,0,0),MACRO(MskuView,1),EQ(AllCats,279),LE(SafeStartTime,NOW),GT(EndTime,NOW),AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))))
  • CompleteBackendQuery:Vr=0.1&Qy=AND%28EQ%28ATTR%28ProductType%29%2CNAME%28US_Childrens_Books%29%29%2CMACRO%28ShowInSite5%2C0%2C0%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C279%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2CAND%28AND%28blood%2COR%28PHRASE%28april%2Cbirth%2Cstone%29%2CPHRASE%28april%2Cbirth%2Cstones%29%2CPHRASE%28april%2Cbirthstone%29%2CPHRASE%28april%2Cbirthstones%29%2CPHRASE%28birthstone%2Cfor%2Capril%29%2Cdiamond%2Cdiamonds%2CEQ%28ATTR%28Birthstone%2Cdf%29%2CNAME%28April%2520%2528Diamond%2529%2Cdf%29%29%2CEQ%28ATTR%28Main%2520Stone%2Cdf%29%2CNAME%28Diamond%2Cdf%29%29%29%29%29%29&Sp=&Nr=0&Sk=0&Fl=ItemID&Gb=ATTR%28Age%2520Level%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Age%2520Level%2Cdf%29%29,COUNT,Incr,0,0,0,0+ATTR%28Condition%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Condition%2Cdf%29%29,COUNT,Incr,0,0,0,0+ATTR%28Format%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Format%2Cdf%29%29,COUNT,Incr,0,0,0,0+ATTR%28LH_FavSellers%29,COUNT,Incr,0,0,0,0+ATTR%28LH_SellerWithStore%29,COUNT,Incr,0,0,0,0+ATTR%28LH_SpecificSeller%29,COUNT,Incr,0,0,0,0+USLevel,COUNT,Incr,0,0,0,0+ATTR%28Language%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Language%2Cdf%29%29,COUNT,Incr,0,0,0,0+ATTR%28Publication%2520Year%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Publication%2520Year%2Cdf%29%29,COUNT,Incr,0,0,0,0+ATTR%28Special%2520Attributes%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Special%2520Attributes%2Cdf%29%29,COUNT,Incr,0,0,0,0+ATTR%28Subject%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Subject%2Cdf%29%29,COUNT,Incr,0,0,0,0&Qi=Dominant+Product+Type+Finder%3APageMA2ShowItems%3ADominantProductTypeQueryHandler%3APr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2%3A:1259197757_0x7110.7.95.156:sq-wshop346:books.shop.ebay.com:v3shopcore
  • SearchIndex:ExpressSale
  • BackendHost:sqwsn-stitle897+sqwsn-stitle880+sqwsn-stitle907+sqwsn-stitle988+sqwsn-stitle600+sqwsn-stitle657+sqwsn-stitle994+sqwsn-stitle490+sqwsn-stitle415+sqwsn-stitle134+sqwsn-stitle432+sqwsn-stitle811+sqwsn-stitle186+sqwsn-stitle200+sqwsn-stitle218+sqwsn-stitle615+sqwsn-agg091
  • QueryTimeInMicroSec:46626
  • NumMatched:2
  • NumReturned:0

Application: Supressed_Aspects_SurfacingGB:PageMA2ShowItems:DominantProductTypeQueryHandler:Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2:

  • SearchQuery:AND(EQ(ATTR(ProductType),NAME(US_Childrens_Books)),MACRO(ShowInSite5,0,0),MACRO(MskuView,1),EQ(AllCats,279),LE(SafeStartTime,NOW),GT(EndTime,NOW),AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))))
  • CompleteBackendQuery:Vr=0.1&Qy=AND%28EQ%28ATTR%28ProductType%29%2CNAME%28US_Childrens_Books%29%29%2CMACRO%28ShowInSite5%2C0%2C0%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C279%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2CAND%28AND%28blood%2COR%28PHRASE%28april%2Cbirth%2Cstone%29%2CPHRASE%28april%2Cbirth%2Cstones%29%2CPHRASE%28april%2Cbirthstone%29%2CPHRASE%28april%2Cbirthstones%29%2CPHRASE%28birthstone%2Cfor%2Capril%29%2Cdiamond%2Cdiamonds%2CEQ%28ATTR%28Birthstone%2Cdf%29%2CNAME%28April%2520%2528Diamond%2529%2Cdf%29%29%2CEQ%28ATTR%28Main%2520Stone%2Cdf%29%2CNAME%28Diamond%2Cdf%29%29%29%29%29%29&Sp=&Nr=0&Sk=0&Fl=ItemID&Gb=ATTR%28Topic%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Topic%2Cdf%29%29,COUNT,Incr,0,0,0,0&Qi=Supressed_Aspects_SurfacingGB%3APageMA2ShowItems%3ADominantProductTypeQueryHandler%3APr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2%3A:1259197757_0x7110.7.95.156:sq-wshop346:books.shop.ebay.com:v3shopcore
  • SearchIndex:ExpressSale
  • BackendHost:sqwsn-stitle254+sqwsn-stitle618+sqwsn-stitle986+sqwsn-stitle885+sqwsn-stitle321+sqwsn-stitle324+sqwsn-stitle932+sqwsn-stitle996+sqwsn-stitle417+sqwsn-stitle418+sqwsn-stitle178+sqwsn-stitle424+sqwsn-stitle591+sqwsn-stitle813+sqwsn-stitle218+sqwsn-stitle608+sqwsn-agg086
  • QueryTimeInMicroSec:24240
  • NumMatched:2
  • NumReturned:0

Application: Query Constraint for - core_all_matching_items_SIF:PageMA2ShowItems:M20:2465:

[CURRENT_ACTIVE]
  AND(
      LESSTHANEQUAL(SafeStartTime,"NOW"),
      GREATERTHAN(EndTime,"NOW"))

[MskuView - 1]
  MskuView("1")

[AllCats - 279]
  EQUAL(AllCats,"279")

[SIBEExpression - AND(OR(AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),P...]
  AND(
      OR(
          AND("AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))")))

[IsSif]
  EQUAL(IsSif,"1")

[ShowInFinding3 - EBAY_MAIN=0 STORE=2]
  ShowInSite5("0","2")

Application: core_all_matching_items_SIF:PageMA2ShowItems:M20:2465:

  • SearchQuery:AND(MACRO(MskuView,1),EQ(AllCats,279),EQ(IsSif,1),MACRO(ShowInSite5,0,2),LE(SafeStartTime,NOW),GT(EndTime,NOW),AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))))
  • CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C279%29%2CEQ%28IsSif%2C1%29%2CMACRO%28ShowInSite5%2C0%2C2%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2CAND%28AND%28blood%2COR%28PHRASE%28april%2Cbirth%2Cstone%29%2CPHRASE%28april%2Cbirth%2Cstones%29%2CPHRASE%28april%2Cbirthstone%29%2CPHRASE%28april%2Cbirthstones%29%2CPHRASE%28birthstone%2Cfor%2Capril%29%2Cdiamond%2Cdiamonds%2CEQ%28ATTR%28Birthstone%2Cdf%29%2CNAME%28April%2520%2528Diamond%2529%2Cdf%29%29%2CEQ%28ATTR%28Main%2520Stone%2Cdf%29%2CNAME%28Diamond%2Cdf%29%29%29%29%29%29&Sp=RELEVANCE_SORT2&Nr=50&So=Decreasing&St=Num=1&Dd=DEDUP(ParentID,EQ(ParentID,0))&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%29+SHIPCALC%28Fu%2CFa%2C1%2C0%2C0%2C2147483647%2C5%29+Ctry+eBayGal+QuantitySold+BinPrice+SafeStartTime+ParenteBayPicURL+MACRO%28EffectiveStartTime%29+IsSif+eBayPayPal+EndTime+MskuTraitNames+Quantity+MACRO%28IsFeaturedFirst%29+StartTime+SoldAsBestOffer+PaymentTypes+eBaySaleType+Bids+BestOffer+Title+Attr3804+attr650+DescriptionFormatted+attr651+eBayFeatured+MotorsSubmodel+MACRO%28FormatBucket%2C1%2C450%2C86400000%29+PostCode+OriginalIndexTime+ParentSuperGalleryCount+ProdReferenceId+PersistentBIN+PowerSellerFlag+eBayBin+IsClassifiedFormat+ParentSuperGalleryVersion+SuperGalleryCount+eBayPicURL+ShippingFlag+ParentGalleryVer+BuyerFixedShippingCost+SoldAsBin+eBayGTC+SuperGalleryVersion+FlatShipCost+ParentID+GalleryOffset+Site+GiftIcon+eBayChar+ItemSubtitle+eBayGalFeatured+InsuranceReqdFlag+InsuranceFee+CurrentPrice+IsSuperSize+MotorsSubtitle+ATTR%28ProductType%29+SellerID+IsMsku+LeafCats&Rkw=%5Bkeyword%3Dblood+diamond%2Csite%3D0%2C%5D&Pr=Pr3%28%28%28MACRO%28IsFixedPriceKnown%2C500%2C864000%29%29%2CBMMUL%28BMSCALE%28BMNORM%28TitleRel%2C100%2C1000000%2C-32000%2C32000%29%2C0%2C1000000%2C150000%2C850000%29%2CBMSCALE%28BMDIV%28DecayedSalesCount%2CMAX%281%2CDecayedImpressionCount%29%2C100000000%2C0%2C1000000%2C1%29%2C0%2C1000000%2C1000%2C1000000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CVARSET%28FSH%2CMACRO%28FreeShippingInSite%2C0%29%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28GT%28USScore3%2C10000%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1270000%29%2CVARSET%28BRValue%2C1240000%29%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1090000%29%2CIF%28EQ%28TnS_xsh%2C50%29%2CVARSET%28BRValue%2C900000%29%2C1000000%29%29%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%28%28MACRO%28IsFixedPriceUnknown%2C500%2C864000%29%29%2CBMMUL%28BMSCALE%28BMNORM%28TitleRel%2C100%2C1000000%2C-32000%2C32000%29%2C0%2C1000000%2C350000%2C650000%29%2CBMSCALE%28IF%28EQ%28saleclass1%2C1%29%2CBMNORM%28IQPredictedQuality%2C100%2C100000%2C6000%2C14207%29%2CBMNORM%28IQPredictedQuality%2C100%2C100000%2C6000%2C9920%29%29%2C0%2C100000%2C1000%2C1000000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CVARSET%28FSH%2CMACRO%28FreeShippingInSite%2C0%29%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28GT%28USScore3%2C10000%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1270000%29%2CVARSET%28BRValue%2C1240000%29%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1090000%29%2CIF%28EQ%28TnS_xsh%2C50%29%2CVARSET%28BRValue%2C900000%29%2C1000000%29%29%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%29&Qi=core_all_matching_items_SIF%3APageMA2ShowItems%3AM20%3A2465%3A:1259197757_0x7110.7.95.156:sq-wshop346:books.shop.ebay.com:v3shopcore
  • SearchIndex:ExpressSale
  • BackendHost:sqwsn-stitle850+sqwsn-stitle019+sqwsn-stitle854+sqwsn-stitle044+sqwsn-stitle058+sqwsn-stitle061+sqwsn-stitle073+sqwsn-stitle865+sqwsn-stitle099+sqwsn-stitle410+sqwsn-stitle505+sqwsn-stitle521+sqwsn-stitle875+sqwsn-stitle835+sqwsn-stitle620+sqwsn-stitle454+sqwsn-stitle906+sqwsn-stitle989+sqwsn-stitle820+sqwsn-stitle336+sqwsn-stitle346+sqwsn-stitle361+sqwsn-stitle121+sqwsn-stitle419+sqwsn-stitle583+sqwsn-stitle165+sqwsn-stitle437+sqwsn-stitle189+sqwsn-stitle452+sqwsn-stitle239+sqwsn-agg128
  • QueryTimeInMicroSec:177251
  • NumMatched:0
  • NumReturned:0

Application: Query Constraint for - intl_exp:PageMA2ShowItems:M63:2464:

[CURRENT_ACTIVE]
  AND(
      LESSTHANEQUAL(SafeStartTime,"NOW"),
      GREATERTHAN(EndTime,"NOW"))

[MskuView - 1]
  MskuView("1")

[AllCats - 279]
  EQUAL(AllCats,"279")

[SIBEExpression - AND(OR(AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),P...]
  AND(
      OR(
          AND("AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))")))

[DefaultCompositeConstraint-NOT-(ShowInFinding3 - EBAY_MAIN=0 SIF_AND_NSIF_ITEMS_SEARCH=8)]
  NOT(
      ShowInSite5("0","8"))

[DefaultCompositeConstraint-NOT-(Site - 0)]
  NOT(
      EQUAL(Site,"0"))

[UseCase - EBAY_MAIN=0 SIF_AND_NSIF_ITEMS_SEARCH=8]
  UseCase("8")

[OKToShowInSite2 - EBAY_MAIN=0 SIF_AND_NSIF_ITEMS_SEARCH=8]
  OKToShowInSite2("0")

[AvailableToCountry - EBAY_MAIN=0 SIF_AND_NSIF_ITEMS_SEARCH=8]
  AvailableToCountry("1")

[ListedInCBTSites - EBAY_MAIN=0 SIF_AND_NSIF_ITEMS_SEARCH=8]
  ListedInCBTSites("0")

Application: intl_exp:PageMA2ShowItems:M63:2464:

  • SearchQuery:AND(MACRO(MskuView,1),EQ(AllCats,279),NOT(MACRO(ShowInSite5,0,8)),NOT(EQ(Site,0)),MACRO(UseCase,8),MACRO(OKToShowInSite2,0),MACRO(AvailableToCountry,1),MACRO(ListedInCBTSites,0),LE(SafeStartTime,NOW),GT(EndTime,NOW),AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))))
  • CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C279%29%2CNOT%28MACRO%28ShowInSite5%2C0%2C8%29%29%2CNOT%28EQ%28Site%2C0%29%29%2CMACRO%28UseCase%2C8%29%2CMACRO%28OKToShowInSite2%2C0%29%2CMACRO%28AvailableToCountry%2C1%29%2CMACRO%28ListedInCBTSites%2C0%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2CAND%28AND%28blood%2COR%28PHRASE%28april%2Cbirth%2Cstone%29%2CPHRASE%28april%2Cbirth%2Cstones%29%2CPHRASE%28april%2Cbirthstone%29%2CPHRASE%28april%2Cbirthstones%29%2CPHRASE%28birthstone%2Cfor%2Capril%29%2Cdiamond%2Cdiamonds%2CEQ%28ATTR%28Birthstone%2Cdf%29%2CNAME%28April%2520%2528Diamond%2529%2Cdf%29%29%2CEQ%28ATTR%28Main%2520Stone%2Cdf%29%2CNAME%28Diamond%2Cdf%29%29%29%29%29%29&Sp=RELEVANCE_SORT2&Nr=10&So=Decreasing&St=Num=1&Dd=DEDUP(ParentID,EQ(ParentID,0))&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%29+SHIPCALC%28Fu%2CFa%2C1%2C0%2C0%2C2147483647%2C5%29+Ctry+eBayGal+QuantitySold+BinPrice+SafeStartTime+ParenteBayPicURL+MACRO%28EffectiveStartTime%29+IsSif+eBayPayPal+EndTime+MskuTraitNames+Quantity+MACRO%28IsFeaturedFirst%29+StartTime+SoldAsBestOffer+PaymentTypes+eBaySaleType+Bids+BestOffer+Title+Attr3804+attr650+DescriptionFormatted+attr651+eBayFeatured+MotorsSubmodel+MACRO%28FormatBucket%2C1%2C450%2C86400000%29+PostCode+OriginalIndexTime+ParentSuperGalleryCount+ProdReferenceId+PersistentBIN+PowerSellerFlag+eBayBin+IsClassifiedFormat+ParentSuperGalleryVersion+SuperGalleryCount+eBayPicURL+ShippingFlag+ParentGalleryVer+BuyerFixedShippingCost+SoldAsBin+eBayGTC+SuperGalleryVersion+FlatShipCost+ParentID+GalleryOffset+Site+GiftIcon+eBayChar+ItemSubtitle+eBayGalFeatured+InsuranceReqdFlag+InsuranceFee+CurrentPrice+IsSuperSize+MotorsSubtitle+ATTR%28ProductType%29+SellerID+IsMsku+LeafCats&Im=MACRO%28FormatBucket%2C1%2C450%2C86400000%29&Rkw=%5Bkeyword%3Dblood+diamond%2Csite%3D0%2Ccategory%3D279%5D&Pr=Pr3%28%28%28EQ%28IsAdFormat%2C1%29%29%2CBMMUL%28BMSCALE%28BMNORM%28SUB%28NOW%2CMACRO%28EffectiveStartTime%29%29%2C-100%2C1000000%2C0%2C864000%29%2C0%2C1000000%2C1%2C25000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CVARSET%28FSH%2CMACRO%28FreeShippingInSite%2C0%29%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28GT%28USScore3%2C10000%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1270000%29%2CVARSET%28BRValue%2C1240000%29%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1090000%29%2CIF%28EQ%28TnS_xsh%2C50%29%2CVARSET%28BRValue%2C900000%29%2C1000000%29%29%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%28%28AND%28MACRO%28IsFixedPriceKnown%2C450%2C86400000%29%2COR%28EQ%28eBaySaleType%2C7%29%2CEQ%28eBaySaleType%2C9%29%29%29%29%2CBMMUL%28BMSCALE%28BMNORM%28TitleRel%2C100%2C1000000%2C-32000%2C32000%29%2C0%2C1000000%2C150000%2C850000%29%2CBMSCALE%28BMDIV%28DecayedSalesCount%2CMAX%281%2CDecayedImpressionCount%29%2C100000000%2C0%2C1000000%2C1%29%2C0%2C1000000%2C1000%2C1000000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CVARSET%28FSH%2CMACRO%28FreeShippingInSite%2C0%29%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28GT%28USScore3%2C10000%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1270000%29%2CVARSET%28BRValue%2C1240000%29%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1090000%29%2CIF%28EQ%28TnS_xsh%2C50%29%2CVARSET%28BRValue%2C900000%29%2C1000000%29%29%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%28%28EQ%28saleclass1%2C1%29%29%2CBMMUL%28BMSCALE%28BMNORM%28SUB%28NOW%2CEndTime%29%2C100%2C1000000%2C-864000%2C0%29%2C0%2C1000000%2C1%2C1000000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28AND%28EQ%28USScore3%2C10000%29%2CEQ%28TnS_xsh%2C50%29%29%2CVARSET%28BRValue%2C985000%29%2C1000000%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%28%28AND%28MACRO%28IsFixedPriceUnknown%2C450%2C86400000%29%2COR%28EQ%28eBaySaleType%2C7%29%2CEQ%28eBaySaleType%2C9%29%29%29%29%2CBMMUL%28BMSCALE%28BMNORM%28TitleRel%2C100%2C1000000%2C-32000%2C32000%29%2C0%2C1000000%2C350000%2C650000%29%2CBMSCALE%28BMNORM%28IQPredictedQuality%2C100%2C9000%2C6000%2C15000%29%2C0%2C9000%2C1%2C1000000%29%2CBMSCALE%28EXPRLIST%28VARSET%28BRValue%2C1000000%29%2CVARSET%28FSH%2CMACRO%28FreeShippingInSite%2C0%29%29%2CIF%28LT%28USScore3%2C10000%29%2CVARSET%28BRValue%2C500000%29%2CIF%28GT%28USScore3%2C10000%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1270000%29%2CVARSET%28BRValue%2C1240000%29%29%2CIF%28EQ%28VARUSE%28FSH%29%2C1%29%2CVARSET%28BRValue%2C1090000%29%2CIF%28EQ%28TnS_xsh%2C50%29%2CVARSET%28BRValue%2C900000%29%2C1000000%29%29%29%29%2CVARUSE%28BRValue%29%29%2C0%2C1000000%2C0%2C1000000%29%2C1000000%2C0%29%29%28%28%29%2CBMMUL%28BMSCALE%28BMNORM%28SUB%28NOW%2CEndTime%29%2C100%2C1000000%2C-864000%2C0%29%2C0%2C1000000%2C1%2C25000%29%2C1000000%2C0%29%29%29&Es=MACRO%28FormatBucket%2C1%2C450%2C86400000%29%2C0%3A74%25%3B1%3A20%25%3B2%3A7%25%2C10&Qi=intl_exp%3APageMA2ShowItems%3AM63%3A2464%3A:1259197757_0x7110.7.95.156:sq-wshop346:books.shop.ebay.com:v3shopcore
  • SearchIndex:ExpressSale
  • BackendHost:sqwsn-stitle369+sqwsn-stitle374+sqwsn-stitle030+sqwsn-stitle039+sqwsn-stitle056+sqwsn-stitle705+sqwsn-stitle077+sqwsn-stitle717+sqwsn-stitle406+sqwsn-stitle118+sqwsn-stitle970+sqwsn-stitle519+sqwsn-stitle531+sqwsn-stitle512+sqwsn-stitle455+sqwsn-stitle984+sqwsn-stitle286+sqwsn-stitle282+sqwsn-stitle990+sqwsn-stitle312+sqwsn-stitle666+sqwsn-stitle345+sqwsn-stitle560+sqwsn-stitle133+sqwsn-stitle178+sqwsn-stitle584+sqwsn-stitle586+sqwsn-stitle190+sqwsn-stitle603+sqwsn-stitle450+sqwsn-agg091
  • QueryTimeInMicroSec:192745
  • NumMatched:0
  • NumReturned:0

Application: Query Constraint for - core_all_matching_items_AllCats:PageMA2ShowItems:M94:Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2:

[ShowInFinding3 - EBAY_MAIN=0 MAIN=0]
  ShowInSite5("0","0")

[CURRENT_ACTIVE]
  AND(
      LESSTHANEQUAL(SafeStartTime,"NOW"),
      GREATERTHAN(EndTime,"NOW"))

[MskuView - 1]
  MskuView("1")

[SIBEExpression - AND(OR(AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),P...]
  AND(
      OR(
          AND("AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))")))

Application: core_all_matching_items_AllCats:PageMA2ShowItems:M94:Pr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2:

  • SearchQuery:AND(MACRO(ShowInSite5,0,0),MACRO(MskuView,1),LE(SafeStartTime,NOW),GT(EndTime,NOW),AND(AND(blood,OR(PHRASE(april,birth,stone),PHRASE(april,birth,stones),PHRASE(april,birthstone),PHRASE(april,birthstones),PHRASE(birthstone,for,april),diamond,diamonds,EQ(ATTR(Birthstone,df),NAME(April%20%28Diamond%29,df)),EQ(ATTR(Main%20Stone,df),NAME(Diamond,df))))))
  • CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28ShowInSite5%2C0%2C0%29%2CMACRO%28MskuView%2C1%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2CAND%28AND%28blood%2COR%28PHRASE%28april%2Cbirth%2Cstone%29%2CPHRASE%28april%2Cbirth%2Cstones%29%2CPHRASE%28april%2Cbirthstone%29%2CPHRASE%28april%2Cbirthstones%29%2CPHRASE%28birthstone%2Cfor%2Capril%29%2Cdiamond%2Cdiamonds%2CEQ%28ATTR%28Birthstone%2Cdf%29%2CNAME%28April%2520%2528Diamond%2529%2Cdf%29%29%2CEQ%28ATTR%28Main%2520Stone%2Cdf%29%2CNAME%28Diamond%2Cdf%29%29%29%29%29%29&Sp=RELEVANCE_SORT2&Nr=0&So=Decreasing&St=Num=1&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%29+SHIPCALC%28Fu%2CFa%2C1%2C0%2C0%2C2147483647%2C5%29+Ctry+eBayGal+QuantitySold+BinPrice+SafeStartTime+ParenteBayPicURL+MACRO%28EffectiveStartTime%29+IsSif+eBayPayPal+EndTime+MskuTraitNames+Quantity+MACRO%28IsFeaturedFirst%29+StartTime+SoldAsBestOffer+PaymentTypes+eBaySaleType+Bids+BestOffer+Title+Attr3804+attr650+DescriptionFormatted+attr651+eBayFeatured+MotorsSubmodel+MACRO%28FormatBucket%2C1%2C450%2C86400000%29+PostCode+OriginalIndexTime+ParentSuperGalleryCount+ProdReferenceId+PersistentBIN+PowerSellerFlag+eBayBin+IsClassifiedFormat+ParentSuperGalleryVersion+SuperGalleryCount+eBayPicURL+ShippingFlag+ParentGalleryVer+BuyerFixedShippingCost+SoldAsBin+eBayGTC+SuperGalleryVersion+FlatShipCost+ParentID+GalleryOffset+Site+GiftIcon+eBayChar+ItemSubtitle+eBayGalFeatured+InsuranceReqdFlag+InsuranceFee+CurrentPrice+IsSuperSize+MotorsSubtitle+ATTR%28ProductType%29+SellerID+IsMsku+LeafCats&Gb=AllCats,COUNT,Incr,0,0,0,0&Pr=Pr%28TnS_xsh%28-100%29%29&Qi=core_all_matching_items_AllCats%3APageMA2ShowItems%3AM94%3APr2464_9_Ed105_2_Ed105_2_Ed105_2_Ed106_2%3A:1259197757_0x7110.7.95.156:sq-wshop346:books.shop.ebay.com:v3shopcore
  • SearchIndex:ExpressSale
  • BackendHost:sqwsn-stitle247+sqwsn-stitle257+sqwsn-stitle471+sqwsn-stitle306+sqwsn-stitle481+sqwsn-stitle927+sqwsn-stitle928+sqwsn-stitle663+sqwsn-stitle568+sqwsn-stitle420+sqwsn-stitle172+sqwsn-stitle170+sqwsn-stitle197+sqwsn-stitle439+sqwsn-stitle235+sqwsn-stitle221+sqwsn-agg134
  • QueryTimeInMicroSec:32835
  • NumMatched:542
  • NumReturned:0

Application: PC

Application: Even Selection DATA 
Items in format buckets:
	FormatBucket 0-AUCTION: 0
	FormatBucket 1-FPK: 0
	FormatBucket 2-FPU: 2



Popular products
No suggestions.
Hide eBay suggestions
Error
We're sorry, but there's been an error.
Please try again.