struct | |
---|---|
ACTION | [empty string] |
BRAND | [empty string] |
CHOOSEADDRESS | [empty string] |
CONFIRM | NO |
CURRENTPAGE | 1 |
Color | [empty string] |
DEPT | Cycling |
GOTO | [empty string] |
KEYWORD | [empty string] |
NAV_CHOOSER | home |
NEW | [empty string] |
ORDER | [empty string] |
ORDERBY | [empty string] |
PAGE | 4 |
PAYMETHOD | CC |
PERPAGE | [empty string] |
PPSUCCESS | NO |
PRICE | 20-to-25 |
RATE | [empty string] |
RECEIPT_NUM | [empty string] |
RETURNTO | [empty string] |
RETURN_TO_PAGE | [empty string] |
SALE | [empty string] |
SAVEDCART | NO |
SHIPPING | [empty string] |
SHOP | cycling-accessories |
SUBTYP_1 | EMPTY |
SUBTYP_2 | EMPTY |
SUBTYP_3 | EMPTY |
Size | [empty string] |
TITLE | [empty string] |
TYP | Accessories |
WEB_TAXONOMY_ID | 752 |
mapping | /cycling-accessories |
waterproof | [empty string] |
query | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQL | SELECT subtyp_1, web_url FROM tb_web_taxonomy WHERE dept='CYCLING' and typ='ACCESSORIES' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY' ORDER BY sort_position |
query | |||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||
CACHED | false | ||||||||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 9 | ||||||||||||||||||||||||||||||||||||||||||
SQL | SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount FROM web_all_products WHERE dept='CYCLING' and typ='ACCESSORIES' and upper(subtyp1)<>'EMPTY' and style_id IN (1066,1236,1275,1276,6852,10355,10391,10512,10670,15371,16117,16491,17153,17388,17822,19235,19477,19664,19978,20035,20653,20654,20655,20656,20658,21459) GROUP BY subtyp1 |
Free Shipping On All Orders Over $99