$5.00
struct | |
---|---|
ACTION | [empty string] |
BRAND | pnw |
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 | 1 |
PAYMETHOD | CC |
PERPAGE | [empty string] |
PPSUCCESS | NO |
PRICE | 5-and-under |
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-components |
SUBTYP_1 | EMPTY |
SUBTYP_2 | EMPTY |
SUBTYP_3 | EMPTY |
Size | [empty string] |
TITLE | [empty string] |
TYP | Components |
WEB_TAXONOMY_ID | 773 |
mapping | /cycling-components |
waterproof | [empty string] |
query | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CACHED | false | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EXECUTIONTIME | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SQL | SELECT subtyp_1, web_url FROM tb_web_taxonomy WHERE dept='CYCLING' and typ='COMPONENTS' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY' ORDER BY sort_position |
query | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
RESULTSET |
|
|||||||||
CACHED | false | |||||||||
EXECUTIONTIME | 11 | |||||||||
SQL | SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount FROM web_all_products WHERE dept='CYCLING' and typ='COMPONENTS' and upper(subtyp1)<>'EMPTY' and style_id IN (17043) GROUP BY subtyp1 |
Free Shipping On All Orders Over $99