Home gear Goodr OG Running Sunglasses

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 80361 [empty string] [empty string] N DOWN_TO_FIESTA 0 529149 [empty string]
2 PABST_OCLOCK 80362 [empty string] [empty string] N PABST_OCLOCK 0 533010 [empty string]
3 PBR_EYE_CANDY 80363 [empty string] [empty string] N PBR_EYE_CANDY 0 533011 [empty string]
4 PIBBERMOUFLAGE 80364 [empty string] [empty string] N PIBBERMOUFLAGE 0 533012 [empty string]
5 FLAMINGOS_BOOZE 80365 [empty string] [empty string] N FLAMINGOS_BOOZE 2 534032 [empty string]
6 BECKYS_BACHELORETTE 80366 [empty string] [empty string] N BECKYS_BACHELORETTE 0 534033 [empty string]
7 PUMPKIN_SPICE_NIGHT 80367 [empty string] [empty string] N PUMPKIN_SPICE_NIGHT 0 535152 [empty string]
8 CAPED_CRUSADER_SUN 80368 [empty string] [empty string] N CAPED_CRUSADER_SUN 0 535394 [empty string]
9 POW_BAM_THANK_YOU 80369 [empty string] [empty string] N POW_BAM_THANK_YOU 0 535395 [empty string]
10 PHOENIX_BLOODY_MARY 80370 [empty string] [empty string] N PHOENIX_BLOODY_MARY 15 536640 [empty string]
11 PROFESSIONAL_RESPAWN 80371 [empty string] [empty string] N PROFESSIONAL_RESPAWN 1 539774 [empty string]
12 SIDE_SCROLL_EYE_ROLL 80372 [empty string] [empty string] N SIDE_SCROLL_EYE_ROLL 1 539775 [empty string]
13 WE_HAD_LIGHTS_FIRST 80373 [empty string] [empty string] N WE_HAD_LIGHTS_FIRST 0 539776 [empty string]
14 NAKATOMI_TOWER 80374 [empty string] [empty string] N NAKATOMI_TOWER 0 539777 [empty string]
15 UNION_JACK_FLASH 80375 [empty string] [empty string] N UNION_JACK_FLASH 0 540295 [empty string]
16 COLD_ENGLISH_BLOOD 80376 [empty string] [empty string] N COLD_ENGLISH_BLOOD 0 540296 [empty string]
17 TONGUING_YOU_62 80377 [empty string] [empty string] N TONGUING_YOU_62 0 540297 [empty string]
18 WHAT_WOULD_KEITH_DO 80378 [empty string] [empty string] N WHAT_WOULD_KEITH_DO 0 540298 [empty string]
19 INSERT_COIN_CONTINUE 80379 [empty string] [empty string] N INSERT_COIN_CONTINUE 0 540299 [empty string]
20 WAKKA_WAKKA_WAKKA 80380 [empty string] [empty string] N WAKKA_WAKKA_WAKKA 4 542243 [empty string]
21 PABST_ME_A_BEER 80381 [empty string] [empty string] N PABST_ME_A_BEER 0 542806 [empty string]
22 SUNNIES_SPRINKLES 80382 [empty string] [empty string] N SUNNIES_SPRINKLES 0 542807 [empty string]
23 ITS_TUESDAY_SOMEWHER 80383 [empty string] [empty string] N ITS_TUESDAY_SOMEWHER 0 542808 [empty string]
24 PASSION_OF_THE_CRUST 80384 [empty string] [empty string] N PASSION_OF_THE_CRUST 0 542809 [empty string]
25 DARK_KNIGHT_CLUBBIN 80385 [empty string] [empty string] N DARK_KNIGHT_CLUBBIN 0 550453 [empty string]
26 GLAMAZON_GODDESS 80386 [empty string] [empty string] N GLAMAZON_GODDESS 0 550454 [empty string]
27 JOKES_ON_YOU 80387 [empty string] [empty string] N JOKES_ON_YOU 0 550455 [empty string]
28 WELCOME_NEIGHBORHOOD 80388 [empty string] [empty string] N WELCOME_NEIGHBORHOOD 0 550456 [empty string]
29 JUSTICE_AND_GRACE 80389 [empty string] [empty string] N JUSTICE_AND_GRACE 0 550457 [empty string]
30 NEW_DISGUISE_WHO_DIS 80390 [empty string] [empty string] N NEW_DISGUISE_WHO_DIS 0 550458 [empty string]
31 FLAMINGOITE_AURA 80391 [empty string] [empty string] N FLAMINGOITE_AURA 0 554502 [empty string]
32 CITRINE_MIMOSA_DREAM 80392 [empty string] [empty string] N CITRINE_MIMOSA_DREAM 0 554503 [empty string]
33 ZEBRA_JASPER_COACH 80393 [empty string] [empty string] N ZEBRA_JASPER_COACH 0 554504 [empty string]
34 DONT_FLOCK_FLAMINGO 80394 [empty string] [empty string] N DONT_FLOCK_FLAMINGO 0 556115 [empty string]
35 THE_GANGS_ALL_QUEER 80395 [empty string] [empty string] N THE_GANGS_ALL_QUEER 0 556116 [empty string]
36 The Eh Team 80396 [empty string] [empty string] N The Eh Team 0 557386 [empty string]
37 SCREW_METRIC_SYSTEM 80397 [empty string] [empty string] N SCREW_METRIC_SYSTEM 0 557387 [empty string]
38 BAD_AND_BAMBOOZY 80398 [empty string] [empty string] N BAD_AND_BAMBOOZY 0 559850 [empty string]
39 GRPE_APE_MISTAKE 80399 [empty string] [empty string] N GRPE_APE_MISTAKE 0 559851 [empty string]
40 TROPICAL_TUMMY 80400 [empty string] [empty string] N TROPICAL_TUMMY 0 559852 [empty string]
41 SIRENS_BOOTY_CALL 80401 [empty string] [empty string] N SIRENS_BOOTY_CALL 0 559853 [empty string]
42 YOU_HAD_ME_AT_DUNKIN 80402 [empty string] [empty string] N YOU_HAD_ME_AT_DUNKIN 0 560728 [empty string]
43 KING_OF_THE_TROPICS 80403 [empty string] [empty string] N KING_OF_THE_TROPICS 0 563075 [empty string]
44 TOURIST_TRAP_TABLOID 80404 [empty string] [empty string] N TOURIST_TRAP_TABLOID 0 563076 [empty string]
45 ELECTRIC_DINOTOPIA 80405 [empty string] [empty string] N ELECTRIC_DINOTOPIA 5 566302 [empty string]
46 BACK_9_BLACKOUT 80406 [empty string] [empty string] N BACK_9_BLACKOUT 0 566799 [empty string]
47 THREE_PARTS_TEE 80407 [empty string] [empty string] N THREE_PARTS_TEE 0 567225 [empty string]
48 SQUAWK_SQUAWK_MFLOCK 80408 [empty string] [empty string] N SQUAWK_SQUAWK_MFLOCK 0 567407 [empty string]
49 CARL_SINGLE_FLMINGLE 80409 [empty string] [empty string] N CARL_SINGLE_FLMINGLE 0 567408 [empty string]
50 DONT_SNAKE_MY_WAVE 80410 [empty string] [empty string] N DONT_SNAKE_MY_WAVE 0 568369 [empty string]
51 SELLS_HOUSE/BUYS_VAN 80411 [empty string] [empty string] N SELLS_HOUSE/BUYS_VAN 0 568370 [empty string]
52 NOT_YOUR_BRO_BRAH 80412 [empty string] [empty string] N NOT_YOUR_BRO_BRAH 0 568371 [empty string]
53 RADIOACTIVE_SPECTRAL 80413 [empty string] [empty string] N RADIOACTIVE_SPECTRAL 0 572219 [empty string]
54 LOST_IN_TRANSITION 80414 [empty string] [empty string] N LOST_IN_TRANSITION 0 582850 [empty string]
55 TALK_CELTIC_TO_ME 80415 [empty string] [empty string] N TALK_CELTIC_TO_ME 0 589118 [empty string]
56 APPOLLOGIZE_FOR_NOTH 80416 [empty string] [empty string] N APPOLLOGIZE_FOR_NOTH 0 592363 [empty string]
57 DIONYSUS_ORGY 80417 [empty string] [empty string] N DIONYSUS_ORGY 0 592364 [empty string]
58 BEACH_PLEASE 80418 [empty string] [empty string] N BEACH_PLEASE -1 593305 [empty string]
59 THESE_SHADES_TRASH 80419 [empty string] [empty string] N THESE_SHADES_TRASH 0 594490 [empty string]
60 I_DO_TO_OPEN_BAR 80420 [empty string] [empty string] N I_DO_TO_OPEN_BAR 0 594823 [empty string]
61 THANKS_ITS_A_RENTAL 80421 [empty string] [empty string] N THANKS_ITS_A_RENTAL 0 594824 [empty string]
62 PRIDE_NO_PREJUDICE 80422 [empty string] [empty string] N PRIDE_NO_PREJUDICE 0 595268 [empty string]
63 MUD_WRESTLING 80423 [empty string] [empty string] N MUD_WRESTLING 0 596060 [empty string]
64 ARTEMIS_IDENTITY 80424 [empty string] [empty string] N ARTEMIS_IDENTITY 0 596061 [empty string]
65 GET_CANUCKED_UP 80425 [empty string] [empty string] N GET_CANUCKED_UP 6 597352 [empty string]
66 HAM_CURED_CRAMPS 80426 [empty string] [empty string] N HAM_CURED_CRAMPS 0 597353 [empty string]
67 DR_4_R_E_SHOTS 80427 [empty string] [empty string] N DR_4_R_E_SHOTS 5 597354 [empty string]
68 FOUNDING_FATHER 80428 [empty string] [empty string] N FOUNDING_FATHER 84 598738 [empty string]
69 CHEETAHS_ALWAYS_WIN 80429 [empty string] [empty string] N CHEETAHS_ALWAYS_WIN 7 601539 [empty string]
70 BIFROST_BRIDGE 80430 [empty string] [empty string] N BIFROST_BRIDGE 0 602383 [empty string]
71 MIGHTY_MJOLNIR 80431 [empty string] [empty string] N MIGHTY_MJOLNIR 0 602384 [empty string]
72 LOVE_AND_THUNDER 80432 [empty string] [empty string] N LOVE_AND_THUNDER 0 602385 [empty string]
73 IN_DOG_WE_TRUST 80433 [empty string] [empty string] N IN_DOG_WE_TRUST 0 603110 [empty string]
74 GRAND_CANYON 80434 [empty string] [empty string] N GRAND_CANYON 0 603111 [empty string]
75 REDWOOD 80435 [empty string] [empty string] N REDWOOD 0 603112 [empty string]
76 HOT_ALIEN_SUMMER 80436 [empty string] [empty string] N HOT_ALIEN_SUMMER 3 604418 [empty string]
77 GAZPACHO_NO_BRAKES 80437 [empty string] [empty string] N GAZPACHO_NO_BRAKES 17 605442 [empty string]
78 NO_IDEA_HOW_DID_THAT 80438 [empty string] [empty string] N NO_IDEA_HOW_DID_THAT 0 605555 [empty string]
79 INITIATE_GOD_MODE 80439 [empty string] [empty string] N INITIATE_GOD_MODE 0 605556 [empty string]
80 SEE_YOU_DIGITAL_HELL 80440 [empty string] [empty string] N SEE_YOU_DIGITAL_HELL 7 605557 [empty string]
81 NEVER_GET_RECIPE 80441 [empty string] [empty string] N NEVER_GET_RECIPE 24 614148 [empty string]
82 SILVERBACK_SQUAT 80442 [empty string] [empty string] N SILVERBACK_SQUAT 0 619166 [empty string]
CACHED false
EXECUTIONTIME 16
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 38733

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 of $50+.
Sign in
Your Account (0)