Home gear Women's Oiselle Runner Trucker Hat

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 77857 [empty string] [empty string] N CLOUD_CREST 0 479861 [empty string]
2 GROUNDEDFLYINGBIRD 77858 [empty string] [empty string] N GROUNDEDFLYINGBIRD 0 523056 [empty string]
3 KOOLHAASBIRD 77859 [empty string] [empty string] N KOOLHAASBIRD 0 523057 [empty string]
4 LOGO_PRINT_COSMOS 77860 [empty string] [empty string] N LOGO_PRINT_COSMOS 0 445151 [empty string]
5 MOODY_FLORAL 77861 [empty string] [empty string] N MOODY_FLORAL 0 479862 [empty string]
6 MOUNTAINS 77862 [empty string] [empty string] N MOUNTAINS 0 479863 [empty string]
7 MTFUGIJAPAN 77863 [empty string] [empty string] N MTFUGIJAPAN 0 523058 [empty string]
8 PINK_SUNRISE 77864 [empty string] [empty string] N PINK_SUNRISE 0 479864 [empty string]
9 WHESI 77865 [empty string] [empty string] N WHESI 0 352398 [empty string]
10 YOSEMITE_AT_SUNSET 77866 [empty string] [empty string] N YOSEMITE_AT_SUNSET 0 479865 [empty string]
11 AMERICAN_RUNNER 77867 [empty string] [empty string] N AMERICAN_RUNNER 0 524971 [empty string]
12 BB_BLUE_CREST 77868 [empty string] [empty string] N BB_BLUE_CREST 0 479859 [empty string]
13 BIG_BLUE 77869 [empty string] [empty string] N BIG_BLUE 0 352397 [empty string]
14 BLACK_CREST 77870 [empty string] [empty string] N BLACK_CREST 0 479860 [empty string]
15 BRIGHT 77871 [empty string] [empty string] N BRIGHT 0 352399 [empty string]
16 DARK_NIGHT 77872 [empty string] [empty string] N DARK_NIGHT 0 535198 [empty string]
17 WING_WHITE 77873 [empty string] [empty string] N WING_WHITE 0 535199 [empty string]
18 YOSEMITE_SUNRISE 77874 [empty string] [empty string] N YOSEMITE_SUNRISE 0 535200 [empty string]
19 PNW_FLOCK 77875 [empty string] [empty string] N PNW_FLOCK 0 548950 [empty string]
20 START_LINE 77876 [empty string] [empty string] N START_LINE 0 548951 [empty string]
21 ALPINE_LAKE 77877 [empty string] [empty string] N ALPINE_LAKE 0 548952 [empty string]
22 BLACK_LOGO 77878 [empty string] [empty string] N BLACK_LOGO 1 548953 [empty string]
23 BRYCE_CANYON 77879 [empty string] [empty string] N BRYCE_CANYON 0 548954 [empty string]
24 LEMON_TREE_PRINT 77880 [empty string] [empty string] N LEMON_TREE_PRINT 0 548955 [empty string]
25 CIRRUS_LOGO 77881 [empty string] [empty string] N CIRRUS_LOGO 0 572626 [empty string]
26 EMPIRE_FLOCK 77882 [empty string] [empty string] N EMPIRE_FLOCK 5 572627 [empty string]
27 GOLD_CREEK_POND 77883 [empty string] [empty string] N GOLD_CREEK_POND 0 572628 [empty string]
28 MOENA_MOUNTAINS 77884 [empty string] [empty string] N MOENA_MOUNTAINS 0 572629 [empty string]
29 FOGGY_WOODS 77885 [empty string] [empty string] N FOGGY_WOODS 0 572630 [empty string]
30 OISELLE_MOUNTAINS 77886 [empty string] [empty string] N OISELLE_MOUNTAINS 3 592470 [empty string]
31 MONUMENT_VALLEY 77887 [empty string] [empty string] N MONUMENT_VALLEY 5 592471 [empty string]
32 BADLANDS 77888 [empty string] [empty string] N BADLANDS 1 592472 [empty string]
33 CRATER_LAKE 77889 [empty string] [empty string] N CRATER_LAKE 0 592473 [empty string]
34 BLACK_FLOCK 77890 [empty string] [empty string] N BLACK_FLOCK 1 592474 [empty string]
35 CASPIAN_BLUE_FLOCK 77891 [empty string] [empty string] N CASPIAN_BLUE_FLOCK 4 592475 [empty string]
36 WING_INK_BLUE 77892 [empty string] [empty string] N WING_INK_BLUE 3 608839 [empty string]
37 MOUNTAIN_AURA 77893 [empty string] [empty string] N MOUNTAIN_AURA 3 608840 [empty string]
38 CIRCLE_BIRD_FOREST 77894 [empty string] [empty string] N CIRCLE_BIRD_FOREST 5 608841 [empty string]
39 ALBULA_ALPS 77895 [empty string] [empty string] N ALBULA_ALPS 5 608842 [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,4) GROUP BY b.attr1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 27186
ONE/SIZE

Shipping

We offer free standard shipping on all orders $50+ and a flat rate on all orders under that amount. Expedited shipping is available in checkout for a shipping premium. 

Returns

Any unworn product can be returned for a full refund within 90 days. We do not offer free return shipping except in cases of defective items. These can be returned for a full refund within 90 days at no expense to you. Please contact us with any inquiries.

Returns can be mailed to:
Runners Plus
8970 Kingsridge Dr.
Dayton, OH 45458

Free shipping on orders $50+
Sign in
Your Account (0)