Gemstone

dominant category: 11700 Möbel & Wohnen
inferred category: 0
query frequency: 48
total clicks: 64

[LH_PrefLoc=2]
  AND(
      OKToShowInSite2("15"),
      UseCase("8"),
      ShowInLocation1("15","2"))

[Colour=Black]
  EQUAL(Colour,"Black,df")

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

[MskuView - 1]
  MskuView("1")

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

• SearchQuery:AND(EQ(ATTR(Colour,df),NAME(Black,df)),MACRO(MskuView,1),EQ(AllCats,146296),MACRO(OKToShowInSite2,15),MACRO(UseCase,8),MACRO(ShowInLocation1,15,2),LE(SafeStartTime,NOW),GT(EndTime,NOW))
• CompleteBackendQuery:callname=DSAggregate&requestencoding=NV&responseencoding=NV&dsHdr=15;2;5&Vr=0.1&Qy=AND%28EQ%28ATTR%28Colour%2Cdf%29%2CNAME%28Black%2Cdf%29%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C146296%29%2CMACRO%28OKToShowInSite2%2C15%29%2CMACRO%28UseCase%2C8%29%2CMACRO%28ShowInLocation1%2C15%2C2%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%29&Sp=MACRO(TCPart1,15,0,15,0,0,1)+MACRO(TCPart2,15,0,15,0,0,1)+EndTime&Nr=28&So=Decreasing+Decreasing+Increasing&St=Num=1,Num=1,Num=1&Dd=DEDUP(ParentID,EQ(ParentID,0))&Sc=,,&Sk=0&Fl=ItemID+MskuPictureTrait+PaisaPay+DELevel+EscrowPay+USLevel+HasReservePrice+CurrencyID+UserDesignation+ItemType+Attr4088+UKLevel+PbpEligibility+GalleryVer+ATTR%284055%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+SHIPCALC%28Fu%2CFa%2C15%2C0%2C0%2C2147483647%2C5%29&Gb=%7BAttr3810,COUNT,Incr,0,0,0,1+%7D+%7BDsaPseudo,DEMANDSCOREONLY,Decr,0,0,0,1+DSAJoin+qd.category.category+%2B%3D+mst.LeafCats+DSAWhere+qd.query.query+%7E%3D+%22%7Ca0%3A2%3Ba1%3ABlack%3B%7C_%7C_%7C_%22+AND+qd.site.site+%3D+%2215%22%7D+%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%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+%7BHASATTR%28ProdReferenceId%29,COUNT,Incr,0,0,0,0+%7D+%7BATTR%28Product%2520Type%2Cdf%29,COUNT,Incr,0,0,0,0+%7D+%7BNOT%28HASATTR%28Product%2520Type%2Cdf%29%29,COUNT,Incr,0,0,0,0+%7D+%7BAutotagProdRefId,SCORE;COUNT;DEMANDSCORE,Decrv%281%29,0,6,0,1+DSAJoin+qd.product.product+%2B%3D+mst.AutotagProdRefId+DSAWhere+qd.query.query+%7E%3D+%22%7Ca0%3A2%3Ba1%3ABlack%3B%7C_%7C_%7C_%22+AND+qd.site.site+%3D+%2215%22%7D+%7BStoreSellerID,COUNT,Decrv%280%29,0,150,0,0+%7D+%7BATTR%28Shape%2Cdf%29,COUNT,Incr,0,0,0,0+%7D+%7BNOT%28HASATTR%28Shape%2Cdf%29%29,COUNT,Incr,0,0,0,0+%7D+%7BSite,COUNT,Incr,0,0,0,0+%7D+%7BDsaPseudo,SUBCAT(%221%22,%22146296%22),Incr,0,0,0,0+DSAJoin+qd.category.category+%2B%3D+mst.LeafCats+DSAWhere+qd.query.query+%3D+%22_%22+AND+qd.site.site+%3D+%2215%22%7D+%7BDsaPseudo,SUBDAP(%22_%7C_%22),Incr,0,0,0,0+DSAJoin+dapd.subdap.subdap+%2B%3D+dapd.subdap.subdap+DSAWhere+dapd.dap.dap+%3D+%22_%7C_%7C_%22%7D&Qi=core_all_matching_items_orch%3APageMA2ShowItems%3AM168%3Anull%3A:1261758910_0x8110.4.27.64:hr-wshop235:crafts.shop.ebay.com.au:v3shopintl
• SearchIndex:DSA
• BackendHost:qsxsn-stitle506+qsxsn-stitle071+qsxsn-stitle538+qsxsn-stitle112+qsxsn-stitle567+qsxsn-stitle587+qsxsn-stitle120+qsxsn-stitle617+qsxsn-stitle126+qsxsn-stitle647+qsxsn-stitle580+qsxsn-stitle081+qsxsn-stitle762+qsxsn-stitle653+qsxsn-stitle816+qsxsn-stitle059+qsxsn-stitle742+qsxsn-stitle996+qsxsn-stitle997+qsxsn-stitle954+qsxsn-stitle964+qsxsn-stitle965+qsxsn-stitle976+qsxsn-stitle972+qsxsn-stitle690+qsxsn-stitle803+qsxsn-stitle702+qsxsn-stitle705+qsxsn-stitle710+qsxsn-stitle986+qsxsn-agg052
• QueryTimeInMicroSec:61818
• NumMatched:109
• NumReturned:28

local aspect applied and PC2813 is off, so, retain it but still need to calculate
calling DFN surface algorithm 

Total Supply Count For Product Type:109
Total Demand Score For Product Type:0
PT coverage list
PT Name=Beads:	id=6184	supply=109	demand=0.0	score=100.0	high confidence=75.0	light confidence=75.0
-------------------------
Qualfied PT list
PT Name=Beads:	id=6184	supply=109	demand=0.0	score=100.0	high confidence=75.0	light confidence=75.0
-------------------------
PT Name=Beads:	id=6184	supply=109	demand=0.0	score=100.0	high confidence=75.0	light confidence=75.0
WinningPT is Beads
local aspect applied and PC2813 is off, new winningPT Beads is the same as _dmpt=Beads
Final WinningPT is Beads being displayed at top
DFN_NOT_DISPLAY_ASPECTS:false

• SearchQuery:AND(EQ(ATTR(Colour,df),NAME(Black,df)),MACRO(MskuView,1),EQ(AllCats,146296),MACRO(OKToShowInSite2,15),MACRO(UseCase,8),MACRO(ShowInLocation1,15,2),LE(SafeStartTime,NOW),GT(EndTime,NOW))
• CompleteBackendQuery:Vr=0.1&Qy=AND%28EQ%28ATTR%28Colour%2Cdf%29%2CNAME%28Black%2Cdf%29%29%2CMACRO%28MskuView%2C1%29%2CEQ%28AllCats%2C146296%29%2CMACRO%28OKToShowInSite2%2C15%29%2CMACRO%28UseCase%2C8%29%2CMACRO%28ShowInLocation1%2C15%2C2%29%2CLE%28SafeStartTime%2CNOW%29%2CGT%28EndTime%2CNOW%29%29&Sp=&Nr=0&Sk=0&Fl=ItemID&Gb=ATTR%28Bead%2520Type%2Cdf%29,COUNT,Incr,0,0,0,0+NOT%28HASATTR%28Bead%2520Type%2Cdf%29%29,COUNT,Incr,0,0,0,0&Qi=Supressed_Aspects_SurfacingGB%3APageMA2ShowItems%3AAutoPseudoSelectionUtil%3Anull%3A:1261758910_0x8110.4.27.64:hr-wshop235:crafts.shop.ebay.com.au:v3shopintl
• SearchIndex:ExpressSale
• BackendHost:qsxsn-stitle501+qsxsn-stitle104+qsxsn-stitle537+qsxsn-stitle552+qsxsn-stitle570+qsxsn-stitle582+qsxsn-stitle598+qsxsn-stitle616+qsxsn-stitle631+qsxsn-stitle647+qsxsn-stitle580+qsxsn-stitle135+qsxsn-stitle139+qsxsn-stitle140+qsxsn-stitle989+qsxsn-stitle988+qsxsn-stitle742+qsxsn-stitle036+qsxsn-stitle955+qsxsn-stitle834+qsxsn-stitle052+qsxsn-stitle091+qsxsn-stitle882+qsxsn-stitle973+qsxsn-stitle689+qsxsn-stitle403+qsxsn-stitle891+qsxsn-stitle984+qsxsn-stitle847+qsxsn-stitle812+qsxsn-agg147
• QueryTimeInMicroSec:13971
• NumMatched:109
• NumReturned:0

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

• SearchQuery:AND(OR(EQ(OwnerId,362832758),EQ(OwnerId,38628839),EQ(OwnerId,308141372),EQ(OwnerId,302056058),EQ(OwnerId,576020117),EQ(OwnerId,450333071),EQ(OwnerId,207270897),EQ(OwnerId,139405287),EQ(OwnerId,45780980),EQ(OwnerId,92214323),EQ(OwnerId,262893440),EQ(OwnerId,637276131),EQ(OwnerId,781124823),EQ(OwnerId,643768153),EQ(OwnerId,41704056),EQ(OwnerId,889306194),EQ(OwnerId,143114869)))
• CompleteBackendQuery:Vr=0.1&Qy=AND%28OR%28EQ%28OwnerId%2C362832758%29%2CEQ%28OwnerId%2C38628839%29%2CEQ%28OwnerId%2C308141372%29%2CEQ%28OwnerId%2C302056058%29%2CEQ%28OwnerId%2C576020117%29%2CEQ%28OwnerId%2C450333071%29%2CEQ%28OwnerId%2C207270897%29%2CEQ%28OwnerId%2C139405287%29%2CEQ%28OwnerId%2C45780980%29%2CEQ%28OwnerId%2C92214323%29%2CEQ%28OwnerId%2C262893440%29%2CEQ%28OwnerId%2C637276131%29%2CEQ%28OwnerId%2C781124823%29%2CEQ%28OwnerId%2C643768153%29%2CEQ%28OwnerId%2C41704056%29%2CEQ%28OwnerId%2C889306194%29%2CEQ%28OwnerId%2C143114869%29%29%29&Sp=StoreId&Nr=150&So=Increasing&St=Num=1&Sk=0&Fl=StoreId+SubsLevel+SiteId+Name+OwnerId&Qi=FindingVoyagerStoreCache-StoreQuery%3A%3AFindingVoyagerStoreCache%3A%3A:1261758910_0x8110.4.27.64:hr-wshop235:crafts.shop.ebay.com.au:v3shopintl
• SearchIndex:Store
• BackendHost:qsxsn-sname05
• QueryTimeInMicroSec:128
• NumMatched:17
• NumReturned:17