Goodr OG Running Sunglasses

Style: OGRS2

Brand: goodr

$25.00

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX NON_INVT ORIGATTR1 QOH SKU_ID SORT_ORDER
1 DOWN_TO_FIESTA 59992 [empty string] [empty string] N DOWN_TO_FIESTA 6 529149 [empty string]
2 PABST_OCLOCK 59993 [empty string] [empty string] N PABST_OCLOCK 30 533010 [empty string]
3 PBR_EYE_CANDY 59994 [empty string] [empty string] N PBR_EYE_CANDY 8 533011 [empty string]
4 PIBBERMOUFLAGE 59995 [empty string] [empty string] N PIBBERMOUFLAGE 28 533012 [empty string]
5 FLAMINGOS_BOOZE 59996 [empty string] [empty string] N FLAMINGOS_BOOZE 12 534032 [empty string]
6 BECKYS_BACHELORETTE 59997 [empty string] [empty string] N BECKYS_BACHELORETTE 4 534033 [empty string]
7 PUMPKIN_SPICE_NIGHT 59998 [empty string] [empty string] N PUMPKIN_SPICE_NIGHT 11 535152 [empty string]
8 CAPED_CRUSADER_SUN 59999 [empty string] [empty string] N CAPED_CRUSADER_SUN 16 535394 [empty string]
9 POW_BAM_THANK_YOU 60000 [empty string] [empty string] N POW_BAM_THANK_YOU 1 535395 [empty string]
10 PHOENIX_BLOODY_MARY 60001 [empty string] [empty string] N PHOENIX_BLOODY_MARY 2 536640 [empty string]
11 PROFESSIONAL_RESPAWN 60002 [empty string] [empty string] N PROFESSIONAL_RESPAWN 3 539774 [empty string]
12 SIDE_SCROLL_EYE_ROLL 60003 [empty string] [empty string] N SIDE_SCROLL_EYE_ROLL 7 539775 [empty string]
13 WE_HAD_LIGHTS_FIRST 60004 [empty string] [empty string] N WE_HAD_LIGHTS_FIRST 1 539776 [empty string]
14 NAKATOMI_TOWER 60005 [empty string] [empty string] N NAKATOMI_TOWER 8 539777 [empty string]
15 UNION_JACK_FLASH 60006 [empty string] [empty string] N UNION_JACK_FLASH 5 540295 [empty string]
16 COLD_ENGLISH_BLOOD 60007 [empty string] [empty string] N COLD_ENGLISH_BLOOD 5 540296 [empty string]
17 TONGUING_YOU_62 60008 [empty string] [empty string] N TONGUING_YOU_62 6 540297 [empty string]
18 WHAT_WOULD_KEITH_DO 60009 [empty string] [empty string] N WHAT_WOULD_KEITH_DO 9 540298 [empty string]
19 INSERT_COIN_CONTINUE 60010 [empty string] [empty string] N INSERT_COIN_CONTINUE 0 540299 [empty string]
20 WAKKA_WAKKA_WAKKA 60011 [empty string] [empty string] N WAKKA_WAKKA_WAKKA 4 542243 [empty string]
21 PABST_ME_A_BEER 60012 [empty string] [empty string] N PABST_ME_A_BEER 0 542806 [empty string]
22 SUNNIES_SPRINKLES 60013 [empty string] [empty string] N SUNNIES_SPRINKLES 8 542807 [empty string]
23 ITS_TUESDAY_SOMEWHER 60014 [empty string] [empty string] N ITS_TUESDAY_SOMEWHER 8 542808 [empty string]
24 PASSION_OF_THE_CRUST 60015 [empty string] [empty string] N PASSION_OF_THE_CRUST 7 542809 [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 38733
Free shipping on all orders $50+