Yakima
Heavy Duty Straps
$44.00
| struct | |
|---|---|
| ACTION | [empty string] |
| BRAND | [empty string] |
| CHOOSEADDRESS | [empty string] |
| CONFIRM | NO |
| CURRENTPAGE | 1 |
| Color | [empty string] |
| DEPT | Car Racks |
| 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 | [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 | car_racks-spare_parts |
| SUBTYP_1 | EMPTY |
| SUBTYP_2 | EMPTY |
| SUBTYP_3 | EMPTY |
| Size | [empty string] |
| TITLE | [empty string] |
| TYP | Spare Parts |
| WEB_TAXONOMY_ID | 995 |
| mapping | /car_racks-spare_parts |
| waterproof | [empty string] |
| query | |||||||
|---|---|---|---|---|---|---|---|
| RESULTSET |
|
||||||
| CACHED | false | ||||||
| EXECUTIONTIME | 6 | ||||||
| SQL | SELECT subtyp_1, web_url FROM tb_web_taxonomy WHERE dept='CAR RACKS' and typ='SPARE PARTS' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY' ORDER BY sort_position | ||||||
| query | |||||||
|---|---|---|---|---|---|---|---|
| RESULTSET |
|
||||||
| CACHED | false | ||||||
| EXECUTIONTIME | 17 | ||||||
| SQL | SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount FROM web_all_products WHERE dept='CAR RACKS' and typ='SPARE PARTS' and upper(subtyp1)<>'EMPTY' and style_id IN (15755,18699) GROUP BY subtyp1 | ||||||
Sort By:
Items per page:
Yakima
Heavy Duty Straps
Thule
Load Stop Sq Bar Evo 4pk
$89.95
Sort By:
Items per page:
