Billiard*

dominant category: 382 Sporting Goods
inferred category: 0
query frequency: 36387
total clicks: 17276

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

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))

site_id = 0 and profileId = 2467
Profile tracker id: Pr2467_6_Ed105_2_Ed106_2
Profile Expression: Pr3(((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))((),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)))

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

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

[MskuView - 1]
  MskuView("1")

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

[SIBEExpression - AND(AND(billiard*))]
  AND(
      AND("billiard*"))

• SearchQuery:AND(MACRO(ShowInSite5,0,0),MACRO(MskuView,1),EQ(AllCats,37792),LE(SafeStartTime,NOW),GT(EndTime,NOW),billiard*)
• 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%2C37792%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2Cbilliard*%29&Sp=EndTime&Nr=50&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+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=%7BATTR%28Condition%2Cdf%29,COUNT,Incr,0,0,0,0+%7D+%7BNOT%28HASATTR%28Condition%2Cdf%29%29,COUNT,Incr,0,0,0,0+%7D+%7BATTR%28Gender%2Cdf%29,COUNT,Incr,0,0,0,0+%7D+%7BNOT%28HASATTR%28Gender%2Cdf%29%29,COUNT,Incr,0,0,0,0+%7D+%7BATTR%28LH_FavSellers%29,COUNT,Incr,0,0,0,0+%7D+%7BATTR%28LH_SellerWithStore%29,COUNT,Incr,0,0,0,0+%7D+%7BATTR%28LH_SpecificSeller%29,COUNT,Incr,0,0,0,0+%7D+%7BUSLevel,COUNT,Incr,0,0,0,0+%7D+%7BHASATTR%28ProdReferenceId%29,COUNT,Incr,0,0,0,0+%7D+%7BATTR%28Product%2Cdf%29,COUNT,Incr,0,0,0,0+%7D+%7BNOT%28HASATTR%28Product%2Cdf%29%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+%7BATTR%28Sport%2Cdf%29,COUNT,Incr,0,0,0,0+%7D+%7BNOT%28HASATTR%28Sport%2Cdf%29%29,COUNT,Incr,0,0,0,0+%7D+%7BDsaPseudo,SUBCAT(%220%22,%2237792%22),Incr,0,0,0,0+DSAJoin+qd.category.category+%2B%3D+mst.LeafCats+DSAWhere+qd.query.query+%3D+%22billiard%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%3Abilliard%2B%22+AND+qd.site.site+%3D+%220%22%7D&Qi=core_all_matching_items_orch%3APageMA2ShowItems%3AM168%3Anull%3A:1260510957_0x7d10.4.27.62:hr-wshop233:sports-cards.shop.ebay.com:v3shopcore
• SearchIndex:DSA
• BackendHost:qsxsn-stitle987+qsxsn-stitle988+qsxsn-stitle991+qsxsn-stitle898+qsxsn-stitle903+qsxsn-stitle950+qsxsn-stitle883+qsxsn-stitle058+qsxsn-stitle799+qsxsn-stitle981+qsxsn-stitle689+qsxsn-stitle408+qsxsn-stitle643+qsxsn-stitle693+qsxsn-stitle809+qsxsn-stitle986+qsxsn-agg147
• QueryTimeInMicroSec:38350
• NumMatched:44
• NumReturned:44

calculated winner candidate is from Lighthouse Mapping:  Fan Apparel & Souvenirs
Final WinningPT is Fan Apparel & Souvenirs being displayed at top
DFN_NOT_DISPLAY_ASPECTS:false

AND(
    ShowInSite5("0","0"),
    AND(
        LESSTHANEQUAL(SafeStartTime,"NOW"),
        GREATERTHAN(EndTime,"NOW")),
    MskuView("1"),
    EQUAL(AllCats,"37792"),
    AND(
        AND("billiard*")))
[ProductType - US_SM_Fan_Shop]
  EQUAL(ProductType,"US_SM_Fan_Shop")

• SearchQuery:AND(EQ(ATTR(ProductType),NAME(US_SM_Fan_Shop)),MACRO(ShowInSite5,0,0),MACRO(MskuView,1),EQ(AllCats,37792),LE(SafeStartTime,NOW),GT(EndTime,NOW),billiard*)
• CompleteBackendQuery:Vr=0.1&Qy=AND%28EQ%28ATTR%28ProductType%29%2CNAME%28US_SM_Fan_Shop%29%29%2CMACRO%28ShowInSite5%2C0%2C0%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C37792%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2Cbilliard*%29&Sp=&Nr=0&Sk=0&Fl=ItemID&Gb=ATTR%28Condition%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Condition%2Cdf%29%29,COUNT,Incr,0,0,0,0+ATTR%28Gender%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Gender%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%28Product%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Product%2Cdf%29%29,COUNT,Incr,0,0,0,0+ATTR%28Sport%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Sport%2Cdf%29%29,COUNT,Incr,0,0,0,0&Qi=Dominant+Product+Type+Finder%3APageMA2ShowItems%3ADominantProductTypeQueryHandler%3Anull%3A:1260510957_0x7d10.4.27.62:hr-wshop233:sports-cards.shop.ebay.com:v3shopcore
• SearchIndex:ExpressSale
• BackendHost:qsxsn-stitle730+qsxsn-stitle731+qsxsn-stitle852+qsxsn-stitle827+qsxsn-stitle088+qsxsn-stitle998+qsxsn-stitle041+qsxsn-stitle793+qsxsn-stitle667+qsxsn-stitle979+qsxsn-stitle912+qsxsn-stitle804+qsxsn-stitle983+qsxsn-stitle846+qsxsn-stitle897+qsxsn-stitle986+qsxsn-agg154
• QueryTimeInMicroSec:34174
• NumMatched:44
• NumReturned:0

• SearchQuery:AND(EQ(ATTR(ProductType),NAME(US_SM_Fan_Shop)),MACRO(ShowInSite5,0,0),MACRO(MskuView,1),EQ(AllCats,37792),LE(SafeStartTime,NOW),GT(EndTime,NOW),billiard*)
• CompleteBackendQuery:Vr=0.1&Qy=AND%28EQ%28ATTR%28ProductType%29%2CNAME%28US_SM_Fan_Shop%29%29%2CMACRO%28ShowInSite5%2C0%2C0%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C37792%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%2Cbilliard*%29&Sp=&Nr=0&Sk=0&Fl=ItemID&Gb=ATTR%28Size%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Size%2Cdf%29%29,COUNT,Incr,0,0,0,0+ATTR%28Team%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Team%2Cdf%29%29,COUNT,Incr,0,0,0,0&Qi=Supressed_Aspects_SurfacingGB%3APageMA2ShowItems%3ADominantProductTypeQueryHandler%3Anull%3A:1260510957_0x7d10.4.27.62:hr-wshop233:sports-cards.shop.ebay.com:v3shopcore
• SearchIndex:ExpressSale
• BackendHost:qsxsn-stitle987+qsxsn-stitle573+qsxsn-stitle035+qsxsn-stitle835+qsxsn-stitle904+qsxsn-stitle998+qsxsn-stitle741+qsxsn-stitle885+qsxsn-stitle882+qsxsn-stitle665+qsxsn-stitle690+qsxsn-stitle804+qsxsn-stitle641+qsxsn-stitle700+qsxsn-stitle771+qsxsn-stitle812+qsxsn-agg152
• QueryTimeInMicroSec:23882
• NumMatched:44
• NumReturned:0

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

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

[MskuView - 1]
  MskuView("1")

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

[SIBEExpression - AND(AND(billiard*))]
  AND(
      AND("billiard*"))

[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")

• SearchQuery:AND(MACRO(MskuView,1),EQ(AllCats,37792),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),billiard*)
• CompleteBackendQuery:Vr=0.1&Qy=AND%28MACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C37792%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%2Cbilliard*%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+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=saleclass1&Rkw=%5Bkeyword%3DBilliard*%2Csite%3D0%2Ccategory%3D37792%5D&Pr=Pr3%28%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%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&Es=saleclass1%2C1%3A57%25%3B0%3A43%25%2C10&Qi=intl_exp%3APageMA2ShowItems%3AM63%3A2467%3A:1260510957_0x7d10.4.27.62:hr-wshop233:sports-cards.shop.ebay.com:v3shopcore
• SearchIndex:ExpressSale
• BackendHost:qsxsn-stitle504+qsxsn-stitle104+qsxsn-stitle009+qsxsn-stitle554+qsxsn-stitle013+qsxsn-stitle017+qsxsn-stitle021+qsxsn-stitle023+qsxsn-stitle630+qsxsn-stitle645+qsxsn-stitle132+qsxsn-stitle559+qsxsn-stitle139+qsxsn-stitle608+qsxsn-stitle661+qsxsn-stitle045+qsxsn-stitle991+qsxsn-stitle992+qsxsn-stitle050+qsxsn-stitle901+qsxsn-stitle794+qsxsn-stitle660+qsxsn-stitle976+qsxsn-stitle673+qsxsn-stitle912+qsxsn-stitle844+qsxsn-stitle641+qsxsn-stitle693+qsxsn-stitle711+qsxsn-stitle812+qsxsn-agg152
• QueryTimeInMicroSec:136053
• NumMatched:0
• NumReturned:0