struct | |
---|---|
ACTION | [empty string] |
BRAND | [empty string] |
CHOOSEADDRESS | [empty string] |
CONFIRM | NO |
CURRENTPAGE | 1 |
Color | [empty string] |
DEPT | Camp and Hike |
GOTO | [empty string] |
KEYWORD | [empty string] |
NAV_CHOOSER | home |
NEW | [empty string] |
ORDER | [empty string] |
ORDERBY | [empty string] |
PAGE | 12 |
PAYMETHOD | CC |
PERPAGE | [empty string] |
PPSUCCESS | NO |
PRICE | [empty string] |
RATE | [empty string] |
RECEIPT_NUM | [empty string] |
RETURNTO | [empty string] |
RETURN_TO_PAGE | [empty string] |
SALE | [empty string] |
SAVEDCART | NO |
SHIPPING | [empty string] |
SHOP | camp_and_hike-camp_kitchen |
SUBTYP_1 | EMPTY |
SUBTYP_2 | EMPTY |
SUBTYP_3 | EMPTY |
Size | [empty string] |
TITLE | [empty string] |
TYP | Camp Kitchen |
WEB_TAXONOMY_ID | 914 |
mapping | /camp_and_hike-camp_kitchen |
waterproof | [empty string] |
query | |||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
||||||||||||||||||||||||||||||||||||
CACHED | false | ||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 3 | ||||||||||||||||||||||||||||||||||||
SQL | SELECT subtyp_1, web_url FROM tb_web_taxonomy WHERE dept='CAMP AND HIKE' and typ='CAMP KITCHEN' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY' ORDER BY sort_position |
query | |||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
||||||||||||||||||||||||||||||||||||
CACHED | false | ||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 10 | ||||||||||||||||||||||||||||||||||||
SQL | SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount FROM web_all_products WHERE dept='CAMP AND HIKE' and typ='CAMP KITCHEN' and upper(subtyp1)<>'EMPTY' and style_id IN (1440,1443,1444,1452,1458,1460,1461,1462,1463,1468,1472,1473,1474,1475,1480,1482,1486,1490,1492,1493,1496,1508,1527,1528,1538,1539,1540,1541,1543,1544,1545,1546,1548,1549,1550,1551,1552,1553,2448,2452,2456,2457,2458,2770,3114,3115,3167,3171,3172,3748,3759,3760,3786,3787,3827,3856,3903,3968,4000,4016,4033,4069,4071,4072,4074,4075,4100,4120,4483,5039,5040,5042,5043,6601,8371,8372,8373,8374,8395,8403,8408,11333,13970,14182,14816,14970,15083,15336,15337,15550,15589,15590,15801,15802,16299,17317,17318,17694,17830,17831,18259,19004,19019,19189,19605,20941,21742,21743,21757,21758,21759,21760,21761,21762,21763,21764,21765,21766,21767,21768,21769,21770,21771,21772,21773,21774,21775,21973,21974) GROUP BY subtyp1 |
Free Shipping On All Orders Over $99