Women's Oiselle Runner Trucker Hat

Style: 603117

Brand: oiselle

$31.95

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX NON_INVT ORIGATTR1 QOH SKU_ID SORT_ORDER
1 CLOUD_CREST 66889 [empty string] [empty string] N CLOUD_CREST 0 479861 [empty string]
2 GROUNDEDFLYINGBIRD 66890 [empty string] [empty string] N GROUNDEDFLYINGBIRD 0 523056 [empty string]
3 KOOLHAASBIRD 66891 [empty string] [empty string] N KOOLHAASBIRD 0 523057 [empty string]
4 LOGO_PRINT_COSMOS 66892 [empty string] [empty string] N LOGO_PRINT_COSMOS 0 445151 [empty string]
5 MOODY_FLORAL 66893 [empty string] [empty string] N MOODY_FLORAL 0 479862 [empty string]
6 MOUNTAINS 66894 [empty string] [empty string] N MOUNTAINS 0 479863 [empty string]
7 MTFUGIJAPAN 66895 [empty string] [empty string] N MTFUGIJAPAN 0 523058 [empty string]
8 PINK_SUNRISE 66896 [empty string] [empty string] N PINK_SUNRISE 0 479864 [empty string]
9 WHESI 66897 [empty string] [empty string] N WHESI 0 352398 [empty string]
10 YOSEMITE_AT_SUNSET 66898 [empty string] [empty string] N YOSEMITE_AT_SUNSET 0 479865 [empty string]
11 AMERICAN_RUNNER 66899 [empty string] [empty string] N AMERICAN_RUNNER 0 524971 [empty string]
12 BB_BLUE_CREST 66900 [empty string] [empty string] N BB_BLUE_CREST 0 479859 [empty string]
13 BIG_BLUE 66901 [empty string] [empty string] N BIG_BLUE 0 352397 [empty string]
14 BLACK_CREST 66902 [empty string] [empty string] N BLACK_CREST 0 479860 [empty string]
15 BRIGHT 66903 [empty string] [empty string] N BRIGHT 0 352399 [empty string]
16 DARK_NIGHT 66904 [empty string] [empty string] N DARK_NIGHT 0 535198 [empty string]
17 WING_WHITE 66905 [empty string] [empty string] N WING_WHITE 0 535199 [empty string]
18 YOSEMITE_SUNRISE 66906 [empty string] [empty string] N YOSEMITE_SUNRISE 0 535200 [empty string]
19 PNW_FLOCK 66907 [empty string] [empty string] N PNW_FLOCK 0 548950 [empty string]
20 START_LINE 66908 [empty string] [empty string] N START_LINE 3 548951 [empty string]
21 ALPINE_LAKE 66909 [empty string] [empty string] N ALPINE_LAKE 0 548952 [empty string]
22 BLACK_LOGO 66910 [empty string] [empty string] N BLACK_LOGO 5 548953 [empty string]
23 BRYCE_CANYON 66911 [empty string] [empty string] N BRYCE_CANYON 0 548954 [empty string]
24 LEMON_TREE_PRINT 66912 [empty string] [empty string] N LEMON_TREE_PRINT 0 548955 [empty string]
25 CIRRUS_LOGO 66913 [empty string] [empty string] N CIRRUS_LOGO 6 572626 [empty string]
26 EMPIRE_FLOCK 66914 [empty string] [empty string] N EMPIRE_FLOCK 9 572627 [empty string]
27 GOLD_CREEK_POND 66915 [empty string] [empty string] N GOLD_CREEK_POND 9 572628 [empty string]
28 MOENA_MOUNTAINS 66916 [empty string] [empty string] N MOENA_MOUNTAINS 10 572629 [empty string]
29 FOGGY_WOODS 66917 [empty string] [empty string] N FOGGY_WOODS 8 572630 [empty string]
CACHED false
EXECUTIONTIME 15
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+