Findin[ Advanced Search ]
Include title and description
Related Searches:  red wing,  roseville,  weller,  mccoy,  fenton,  or browse this category
Clear AllPreferences
Show only
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
2 results found for (Crystal*) (Bullet*) [ Save this search ]
Preferences: Buy It Now [ Edit preferences | Clear preferences ]
We found other stuff close to what you're looking for
Retry your search in All Categories
This page was last updated: Nov-28 03:29. 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: px-wshop163/10.2.105.173

Application: Category Data

dominant category: 306 Records
inferred category: 0
query frequency: null
total clicks: null

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

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 = 2468
Profile tracker id: Pr2468_5_Ed105_2
Profile Expression: Pr3(((),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,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)))

site_id = 0 and profileId = 2468
Profile tracker id: Pr2468_5_Ed105_2
Profile Expression: Pr3(((),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,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)))

site_id = 0 and profileId = 2468
Profile tracker id: Pr2468_5_Ed105_2
Profile Expression: Pr3(((),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,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)))

site_id = 0 and profileId = 2468
Profile tracker id: Pr2468_5_Ed105_2
Profile Expression: Pr3(((),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,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)))

site_id = 0 and profileId = 2468
Profile tracker id: Pr2468_5_Ed105_2
Profile Expression: Pr3(((),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,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)))

site_id = 0 and profileId = 2468
Profile tracker id: Pr2468_5_Ed105_2
Profile Expression: Pr3(((),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,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)))

site_id = 0 and profileId = 2468
Profile tracker id: Pr2468_5_Ed105_2
Profile Expression: Pr3(((),BMMUL(BMSCALE(BMNORM(SUB(NOW,MACRO(EffectiveStartTime)),-100,1000000,0,864000),0,1000000,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)))

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

[LH_BIN=1]
  SaleClass("2")

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

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

[MskuView - 1]
  MskuView("1")

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

[SIBEExpression - AND(AND(OR(crystal*),OR(bullet*)))]
  AND(
      AND(
          OR("crystal*"),
          OR("bullet*")))

Application: core_all_matching_items_orch:PageMA2ShowItems:M168:null:

  • SearchQuery:AND(MACRO(SaleClass,2),MACRO(ShowInSite5,0,0),MACRO(MskuView,1),EQ(AllCats,870),LE(SafeStartTime,NOW),GT(EndTime,NOW),crystal*,bullet*)
  • CompleteBackendQuery:callname=DSAggregate&requestencoding=NV&responseencoding=NV&dsHdr=0;2;4&Vr=0.1&Qy=AND%28MACRO%28SaleClass%2C2%29%2CMACRO%28ShowInSite5%2C0%2C0%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C870%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2Ccrystal*%2Cbullet*%29&Sp=EndTime&Nr=28&So=Increasing&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+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,%22870%22),Incr,0,0,0,0+DSAJoin+qd.category.category+%2B%3D+mst.LeafCats+DSAWhere+qd.query.query+%3D+%22crystal%2Bbullet%2B%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%3Acrystal%2Bbullet%2B%22+AND+qd.site.site+%3D+%220%22%7D&Qi=core_all_matching_items_orch%3APageMA2ShowItems%3AM168%3Anull%3A:1259407768_0x7b10.2.105.173:px-wshop163:pottery-glass.shop.ebay.com:v3shopcore
  • SearchIndex:DSA
  • BackendHost:phxsn-stitle003+phxsn-stitle295+phxsn-stitle919+phxsn-stitle060+phxsn-stitle070+phxsn-stitle928+phxsn-stitle107+phxsn-stitle126+phxsn-stitle797+phxsn-stitle093+phxsn-stitle602+phxsn-stitle810+phxsn-stitle846+phxsn-stitle523+phxsn-stitle799+phxsn-stitle711+phxsn-stitle245+phxsn-stitle966+phxsn-stitle969+phxsn-stitle409+phxsn-stitle903+phxsn-stitle833+phxsn-stitle163+phxsn-stitle309+phxsn-stitle183+phxsn-stitle427+phxsn-stitle560+phxsn-stitle568+phxsn-stitle316+phxsn-stitle222+phxsn-agg183
  • QueryTimeInMicroSec:162216
  • NumMatched:2
  • NumReturned:2

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=Other eBay Items:	id=3294	supply=2	raw demand=0	demand=0.0	score=100.0	high confidence=85.0	light confidence=60.0
-------------------------
WinningPT is null because qualfiedPTList is empty
WinningPT is null because there is no qualified ProductType

Application: SIBE Services:

Query : null
Url : http://phxsibeclassicdb.vip.ebay.com:9090/koios?Qy=&Si=0&Aq=0.0&Vr=2&Sr=SERENDIP&Rf=5&Rl=5&Sq=0&Ca=870

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

[LH_BIN=1]
  SaleClass("2")

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

[MskuView - 1]
  MskuView("1")

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

[SIBEExpression - AND(AND(OR(crystal*),OR(bullet*)))]
  AND(
      AND(
          OR("crystal*"),
          OR("bullet*")))

[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(SaleClass,2),MACRO(MskuView,1),EQ(AllCats,870),EQ(IsSif,1),MACRO(ShowInSite5,0,2),LE(SafeStartTime,NOW),GT(EndTime,NOW),crystal*,bullet*)
  • CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28SaleClass%2C2%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C870%29%2CEQ%28IsSif%2C1%29%2CMACRO%28ShowInSite5%2C0%2C2%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2Ccrystal*%2Cbullet*%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+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%3D%28Crystal*%29+%28Bullet*%29%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:1259407768_0x7b10.2.105.173:px-wshop163:pottery-glass.shop.ebay.com:v3shopcore
  • SearchIndex:ExpressSale
  • BackendHost:phxsn-stitle003+phxsn-stitle813+phxsn-stitle041+phxsn-stitle779+phxsn-stitle443+phxsn-stitle084+phxsn-stitle109+phxsn-stitle122+phxsn-stitle936+phxsn-stitle800+phxsn-stitle354+phxsn-stitle538+phxsn-stitle522+phxsn-stitle804+phxsn-stitle772+phxsn-stitle827+phxsn-stitle778+phxsn-stitle966+phxsn-stitle889+phxsn-stitle895+phxsn-stitle974+phxsn-stitle294+phxsn-stitle278+phxsn-stitle258+phxsn-stitle178+phxsn-stitle368+phxsn-stitle199+phxsn-stitle206+phxsn-stitle220+phxsn-stitle222+phxsn-agg178
  • QueryTimeInMicroSec:207920
  • NumMatched:0
  • NumReturned:0

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

[LH_BIN=1]
  SaleClass("2")

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

[MskuView - 1]
  MskuView("1")

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

[SIBEExpression - AND(AND(OR(crystal*),OR(bullet*)))]
  AND(
      AND(
          OR("crystal*"),
          OR("bullet*")))

[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:2468:

  • SearchQuery:AND(MACRO(SaleClass,2),MACRO(MskuView,1),EQ(AllCats,870),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),crystal*,bullet*)
  • CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28SaleClass%2C2%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C870%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%2Ccrystal*%2Cbullet*%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+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%3D%28Crystal*%29+%28Bullet*%29%2Csite%3D0%2Ccategory%3D870%5D&Pr=Pr3%28%28%28%29%2CBMMUL%28BMSCALE%28BMNORM%28SUB%28NOW%2CMACRO%28EffectiveStartTime%29%29%2C-100%2C1000000%2C0%2C864000%29%2C0%2C1000000%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%29&Qi=intl_exp%3APageMA2ShowItems%3AM63%3A2468%3A:1259407768_0x7b10.2.105.173:px-wshop163:pottery-glass.shop.ebay.com:v3shopcore
  • SearchIndex:ExpressSale
  • BackendHost:phxsn-stitle834+phxsn-stitle018+phxsn-stitle293+phxsn-stitle780+phxsn-stitle926+phxsn-stitle929+phxsn-stitle932+phxsn-stitle120+phxsn-stitle938+phxsn-stitle148+phxsn-stitle555+phxsn-stitle823+phxsn-stitle080+phxsn-stitle951+phxsn-stitle956+phxsn-stitle775+phxsn-stitle858+phxsn-stitle965+phxsn-stitle353+phxsn-stitle971+phxsn-stitle974+phxsn-stitle158+phxsn-stitle636+phxsn-stitle309+phxsn-stitle426+phxsn-stitle851+phxsn-stitle199+phxsn-stitle517+phxsn-stitle685+phxsn-stitle482+phxsn-agg061
  • QueryTimeInMicroSec:241417
  • NumMatched:0
  • NumReturned:0

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

[LH_BIN=1]
  SaleClass("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(AND(OR(crystal*),OR(bullet*)))]
  AND(
      AND(
          OR("crystal*"),
          OR("bullet*")))

Application: core_all_matching_items_AllCats:PageMA2ShowItems:M94:Pr2468_5_Ed105_2:

  • SearchQuery:AND(MACRO(SaleClass,2),MACRO(ShowInSite5,0,0),MACRO(MskuView,1),LE(SafeStartTime,NOW),GT(EndTime,NOW),crystal*,bullet*)
  • CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28SaleClass%2C2%29%2CMACRO%28ShowInSite5%2C0%2C0%29%2CMACRO%28MskuView%2C1%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2Ccrystal*%2Cbullet*%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+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%3APr2468_5_Ed105_2%3A:1259407768_0x7b10.2.105.173:px-wshop163:pottery-glass.shop.ebay.com:v3shopcore
  • SearchIndex:ExpressSale
  • BackendHost:phxsn-stitle263+phxsn-stitle813+phxsn-stitle919+phxsn-stitle780+phxsn-stitle068+phxsn-stitle091+phxsn-stitle985+phxsn-stitle118+phxsn-stitle137+phxsn-stitle988+phxsn-stitle139+phxsn-stitle809+phxsn-stitle540+phxsn-stitle343+phxsn-stitle239+phxsn-stitle958+phxsn-stitle962+phxsn-stitle382+phxsn-stitle890+phxsn-stitle729+phxsn-stitle753+phxsn-stitle978+phxsn-stitle546+phxsn-stitle849+phxsn-stitle280+phxsn-stitle427+phxsn-stitle512+phxsn-stitle202+phxsn-stitle685+phxsn-stitle482+phxsn-agg183
  • QueryTimeInMicroSec:136447
  • NumMatched:9
  • NumReturned:0

Application: PC

Popular products
No suggestions.

Error
We're sorry, but there's been an error.
Please try again.