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 80331 [empty string] [empty string] N FRESH_BAKED_MAN_BUNS 0 525688 [empty string]
2 INFLUENCERS_PAY_DOUB 80332 [empty string] [empty string] N INFLUENCERS_PAY_DOUB 0 525689 [empty string]
3 MIDNIGHT_RAMBLE 80333 [empty string] [empty string] N MIDNIGHT_RAMBLE 7 525690 [empty string]
4 NINE_DOLLAR_POUR 80334 [empty string] [empty string] N NINE_DOLLAR_POUR 3 525691 [empty string]
5 PICKLED_THESE_MYSELF 80335 [empty string] [empty string] N PICKLED_THESE_MYSELF 0 525692 [empty string]
6 STRANGE_THINGS_AFOOT 80336 [empty string] [empty string] N STRANGE_THINGS_AFOOT 1 525693 [empty string]
7 CLEAR/PURPLE 80337 [empty string] [empty string] N CLEAR/PURPLE 0 522712 [empty string]
8 ORANGE/LIGHTBLUE 80338 [empty string] [empty string] N ORANGE/LIGHTBLUE 0 522713 [empty string]
9 TEAL/PURPLE 80339 [empty string] [empty string] N TEAL/PURPLE 0 522714 [empty string]
10 TORTOISE/BROWN 80340 [empty string] [empty string] N TORTOISE/BROWN 0 522715 [empty string]
11 BLACK/BLUE 80341 [empty string] [empty string] N BLACK/BLUE 0 522716 [empty string]
12 PINK/PINK 80342 [empty string] [empty string] N PINK/PINK -1 522717 [empty string]
13 INSERT_COIN 80343 [empty string] [empty string] N INSERT_COIN 0 540300 [empty string]
14 NOT_BLACK/OBSIDIAN 80344 [empty string] [empty string] N NOT_BLACK/OBSIDIAN 8 548442 [empty string]
15 MOONSTONE_MOONSHINE 80345 [empty string] [empty string] N MOONSTONE_MOONSHINE 0 554505 [empty string]
16 JADED_LITTLE_PILL 80346 [empty string] [empty string] N JADED_LITTLE_PILL 0 554506 [empty string]
17 KUNZITE_COMPELS_YOU 80347 [empty string] [empty string] N KUNZITE_COMPELS_YOU 0 554507 [empty string]
18 IM_WEARING_BURGUNDY 80348 [empty string] [empty string] N IM_WEARING_BURGUNDY 10 557390 [empty string]
19 MAI_TAI_ME_UP 80349 [empty string] [empty string] N MAI_TAI_ME_UP 0 559847 [empty string]
20 TROPIC_LIKE_ITS_HOT 80350 [empty string] [empty string] N TROPIC_LIKE_ITS_HOT 0 559848 [empty string]
21 FADE_ER_ADE_SHADES 80351 [empty string] [empty string] N FADE_ER_ADE_SHADES 4 567224 [empty string]
22 BODHIS_ULTIMATE_RIDE 80352 [empty string] [empty string] N BODHIS_ULTIMATE_RIDE 6 568372 [empty string]
23 THANKS_THEY_VINTAGE 80353 [empty string] [empty string] N THANKS_THEY_VINTAGE 10 589115 [empty string]
24 OUT_OF_BLACK 80354 [empty string] [empty string] N OUT_OF_BLACK 10 589116 [empty string]
25 HAVE_THESE_ON_VINYL 80355 [empty string] [empty string] N HAVE_THESE_ON_VINYL 7 589117 [empty string]
26 ATHENA_IS_AS_ATHENA 80356 [empty string] [empty string] N ATHENA_IS_AS_ATHENA 0 592366 [empty string]
27 HERAS_AWKWARD_FAMILY 80357 [empty string] [empty string] N HERAS_AWKWARD_FAMILY 0 592369 [empty string]
28 HERMES_JUNK_MAIL 80358 [empty string] [empty string] N HERMES_JUNK_MAIL 5 592370 [empty string]
29 BEAM_ME/PROBE_ME 80359 [empty string] [empty string] N BEAM_ME/PROBE_ME 0 604419 [empty string]
30 SILVERBACK_SQUAT 80360 [empty string] [empty string] N SILVERBACK_SQUAT 0 619165 [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 38445
Free shipping on orders $50+