Women's Oiselle Runner Trucker Hat

Style: 603117

Brand: oiselle

$37.95

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX NON_INVT ORIGATTR1 QOH SKU_ID SORT_ORDER
1 CLOUD_CREST 71534 [empty string] [empty string] N CLOUD_CREST 0 479861 [empty string]
2 GROUNDEDFLYINGBIRD 71535 [empty string] [empty string] N GROUNDEDFLYINGBIRD 0 523056 [empty string]
3 KOOLHAASBIRD 71536 [empty string] [empty string] N KOOLHAASBIRD 0 523057 [empty string]
4 LOGO_PRINT_COSMOS 71537 [empty string] [empty string] N LOGO_PRINT_COSMOS 0 445151 [empty string]
5 MOODY_FLORAL 71538 [empty string] [empty string] N MOODY_FLORAL 0 479862 [empty string]
6 MOUNTAINS 71539 [empty string] [empty string] N MOUNTAINS 0 479863 [empty string]
7 MTFUGIJAPAN 71540 [empty string] [empty string] N MTFUGIJAPAN 0 523058 [empty string]
8 PINK_SUNRISE 71541 [empty string] [empty string] N PINK_SUNRISE 0 479864 [empty string]
9 WHESI 71542 [empty string] [empty string] N WHESI 0 352398 [empty string]
10 YOSEMITE_AT_SUNSET 71543 [empty string] [empty string] N YOSEMITE_AT_SUNSET 0 479865 [empty string]
11 AMERICAN_RUNNER 71544 [empty string] [empty string] N AMERICAN_RUNNER 0 524971 [empty string]
12 BB_BLUE_CREST 71545 [empty string] [empty string] N BB_BLUE_CREST 0 479859 [empty string]
13 BIG_BLUE 71546 [empty string] [empty string] N BIG_BLUE 0 352397 [empty string]
14 BLACK_CREST 71547 [empty string] [empty string] N BLACK_CREST 0 479860 [empty string]
15 BRIGHT 71548 [empty string] [empty string] N BRIGHT 0 352399 [empty string]
16 DARK_NIGHT 71549 [empty string] [empty string] N DARK_NIGHT 0 535198 [empty string]
17 WING_WHITE 71550 [empty string] [empty string] N WING_WHITE 0 535199 [empty string]
18 YOSEMITE_SUNRISE 71551 [empty string] [empty string] N YOSEMITE_SUNRISE 0 535200 [empty string]
19 PNW_FLOCK 71552 [empty string] [empty string] N PNW_FLOCK 0 548950 [empty string]
20 START_LINE 71553 [empty string] [empty string] N START_LINE 0 548951 [empty string]
21 ALPINE_LAKE 71554 [empty string] [empty string] N ALPINE_LAKE 0 548952 [empty string]
22 BLACK_LOGO 71555 [empty string] [empty string] N BLACK_LOGO 2 548953 [empty string]
23 BRYCE_CANYON 71556 [empty string] [empty string] N BRYCE_CANYON 0 548954 [empty string]
24 LEMON_TREE_PRINT 71557 [empty string] [empty string] N LEMON_TREE_PRINT 0 548955 [empty string]
25 CIRRUS_LOGO 71558 [empty string] [empty string] N CIRRUS_LOGO 1 572626 [empty string]
26 EMPIRE_FLOCK 71559 [empty string] [empty string] N EMPIRE_FLOCK 7 572627 [empty string]
27 GOLD_CREEK_POND 71560 [empty string] [empty string] N GOLD_CREEK_POND 0 572628 [empty string]
28 MOENA_MOUNTAINS 71561 [empty string] [empty string] N MOENA_MOUNTAINS 0 572629 [empty string]
29 FOGGY_WOODS 71562 [empty string] [empty string] N FOGGY_WOODS 0 572630 [empty string]
30 OISELLE_MOUNTAINS 71563 [empty string] [empty string] N OISELLE_MOUNTAINS 5 592470 [empty string]
31 MONUMENT_VALLEY 71564 [empty string] [empty string] N MONUMENT_VALLEY 6 592471 [empty string]
32 BADLANDS 71565 [empty string] [empty string] N BADLANDS 3 592472 [empty string]
33 CRATER_LAKE 71566 [empty string] [empty string] N CRATER_LAKE 0 592473 [empty string]
34 BLACK_FLOCK 71567 [empty string] [empty string] N BLACK_FLOCK 5 592474 [empty string]
35 CASPIAN_BLUE_FLOCK 71568 [empty string] [empty string] N CASPIAN_BLUE_FLOCK 5 592475 [empty string]
CACHED false
EXECUTIONTIME 0
SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(z.non_invt) as non_invt FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) LEFT JOIN tb_styles z on (z.style_id = a.style_id) WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=? AND e.store_id in(1,2,3) GROUP BY b.attr1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 27186
ONE/SIZE
Free shipping on all orders $50+