Goodr Circle G's Running Sunglasses

Style: CGRS

Brand: goodr

$25.00

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX NON_INVT ORIGATTR1 QOH SKU_ID SORT_ORDER
1 FRESH_BAKED_MAN_BUNS 76189 [empty string] [empty string] N FRESH_BAKED_MAN_BUNS 0 525688 [empty string]
2 INFLUENCERS_PAY_DOUB 76190 [empty string] [empty string] N INFLUENCERS_PAY_DOUB 0 525689 [empty string]
3 MIDNIGHT_RAMBLE 76191 [empty string] [empty string] N MIDNIGHT_RAMBLE 9 525690 [empty string]
4 NINE_DOLLAR_POUR 76192 [empty string] [empty string] N NINE_DOLLAR_POUR 12 525691 [empty string]
5 PICKLED_THESE_MYSELF 76193 [empty string] [empty string] N PICKLED_THESE_MYSELF 0 525692 [empty string]
6 STRANGE_THINGS_AFOOT 76194 [empty string] [empty string] N STRANGE_THINGS_AFOOT 0 525693 [empty string]
7 CLEAR/PURPLE 76195 [empty string] [empty string] N CLEAR/PURPLE 0 522712 [empty string]
8 ORANGE/LIGHTBLUE 76196 [empty string] [empty string] N ORANGE/LIGHTBLUE 0 522713 [empty string]
9 TEAL/PURPLE 76197 [empty string] [empty string] N TEAL/PURPLE 0 522714 [empty string]
10 TORTOISE/BROWN 76198 [empty string] [empty string] N TORTOISE/BROWN 0 522715 [empty string]
11 BLACK/BLUE 76199 [empty string] [empty string] N BLACK/BLUE 0 522716 [empty string]
12 PINK/PINK 76200 [empty string] [empty string] N PINK/PINK -1 522717 [empty string]
13 INSERT_COIN 76201 [empty string] [empty string] N INSERT_COIN 0 540300 [empty string]
14 NOT_BLACK/OBSIDIAN 76202 [empty string] [empty string] N NOT_BLACK/OBSIDIAN 6 548442 [empty string]
15 MOONSTONE_MOONSHINE 76203 [empty string] [empty string] N MOONSTONE_MOONSHINE 0 554505 [empty string]
16 JADED_LITTLE_PILL 76204 [empty string] [empty string] N JADED_LITTLE_PILL 0 554506 [empty string]
17 KUNZITE_COMPELS_YOU 76205 [empty string] [empty string] N KUNZITE_COMPELS_YOU 0 554507 [empty string]
18 IM_WEARING_BURGUNDY 76206 [empty string] [empty string] N IM_WEARING_BURGUNDY 6 557390 [empty string]
19 MAI_TAI_ME_UP 76207 [empty string] [empty string] N MAI_TAI_ME_UP 0 559847 [empty string]
20 TROPIC_LIKE_ITS_HOT 76208 [empty string] [empty string] N TROPIC_LIKE_ITS_HOT 0 559848 [empty string]
21 FADE_ER_ADE_SHADES 76209 [empty string] [empty string] N FADE_ER_ADE_SHADES 6 567224 [empty string]
22 BODHIS_ULTIMATE_RIDE 76210 [empty string] [empty string] N BODHIS_ULTIMATE_RIDE 7 568372 [empty string]
23 THANKS_THEY_VINTAGE 76211 [empty string] [empty string] N THANKS_THEY_VINTAGE 12 589115 [empty string]
24 OUT_OF_BLACK 76212 [empty string] [empty string] N OUT_OF_BLACK 10 589116 [empty string]
25 HAVE_THESE_ON_VINYL 76213 [empty string] [empty string] N HAVE_THESE_ON_VINYL 6 589117 [empty string]
26 ATHENA_IS_AS_ATHENA 76214 [empty string] [empty string] N ATHENA_IS_AS_ATHENA 0 592366 [empty string]
27 HERAS_AWKWARD_FAMILY 76215 [empty string] [empty string] N HERAS_AWKWARD_FAMILY 4 592369 [empty string]
28 HERMES_JUNK_MAIL 76216 [empty string] [empty string] N HERMES_JUNK_MAIL 9 592370 [empty string]
29 BEAM_ME/PROBE_ME 76217 [empty string] [empty string] N BEAM_ME/PROBE_ME 8 604419 [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 38445
Checkout issues resolved. Free shipping on orders $50+.