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 74306 [empty string] [empty string] N DOWN_TO_FIESTA 0 529149 [empty string]
2 PABST_OCLOCK 74307 [empty string] [empty string] N PABST_OCLOCK 0 533010 [empty string]
3 PBR_EYE_CANDY 74308 [empty string] [empty string] N PBR_EYE_CANDY 0 533011 [empty string]
4 PIBBERMOUFLAGE 74309 [empty string] [empty string] N PIBBERMOUFLAGE 0 533012 [empty string]
5 FLAMINGOS_BOOZE 74310 [empty string] [empty string] N FLAMINGOS_BOOZE 10 534032 [empty string]
6 BECKYS_BACHELORETTE 74311 [empty string] [empty string] N BECKYS_BACHELORETTE 0 534033 [empty string]
7 PUMPKIN_SPICE_NIGHT 74312 [empty string] [empty string] N PUMPKIN_SPICE_NIGHT 0 535152 [empty string]
8 CAPED_CRUSADER_SUN 74313 [empty string] [empty string] N CAPED_CRUSADER_SUN 0 535394 [empty string]
9 POW_BAM_THANK_YOU 74314 [empty string] [empty string] N POW_BAM_THANK_YOU 0 535395 [empty string]
10 PHOENIX_BLOODY_MARY 74315 [empty string] [empty string] N PHOENIX_BLOODY_MARY 12 536640 [empty string]
11 PROFESSIONAL_RESPAWN 74316 [empty string] [empty string] N PROFESSIONAL_RESPAWN 14 539774 [empty string]
12 SIDE_SCROLL_EYE_ROLL 74317 [empty string] [empty string] N SIDE_SCROLL_EYE_ROLL 0 539775 [empty string]
13 WE_HAD_LIGHTS_FIRST 74318 [empty string] [empty string] N WE_HAD_LIGHTS_FIRST 0 539776 [empty string]
14 NAKATOMI_TOWER 74319 [empty string] [empty string] N NAKATOMI_TOWER 0 539777 [empty string]
15 UNION_JACK_FLASH 74320 [empty string] [empty string] N UNION_JACK_FLASH 0 540295 [empty string]
16 COLD_ENGLISH_BLOOD 74321 [empty string] [empty string] N COLD_ENGLISH_BLOOD 0 540296 [empty string]
17 TONGUING_YOU_62 74322 [empty string] [empty string] N TONGUING_YOU_62 0 540297 [empty string]
18 WHAT_WOULD_KEITH_DO 74323 [empty string] [empty string] N WHAT_WOULD_KEITH_DO 0 540298 [empty string]
19 INSERT_COIN_CONTINUE 74324 [empty string] [empty string] N INSERT_COIN_CONTINUE 0 540299 [empty string]
20 WAKKA_WAKKA_WAKKA 74325 [empty string] [empty string] N WAKKA_WAKKA_WAKKA 0 542243 [empty string]
21 PABST_ME_A_BEER 74326 [empty string] [empty string] N PABST_ME_A_BEER 0 542806 [empty string]
22 SUNNIES_SPRINKLES 74327 [empty string] [empty string] N SUNNIES_SPRINKLES 0 542807 [empty string]
23 ITS_TUESDAY_SOMEWHER 74328 [empty string] [empty string] N ITS_TUESDAY_SOMEWHER 0 542808 [empty string]
24 PASSION_OF_THE_CRUST 74329 [empty string] [empty string] N PASSION_OF_THE_CRUST 0 542809 [empty string]
25 DARK_KNIGHT_CLUBBIN 74330 [empty string] [empty string] N DARK_KNIGHT_CLUBBIN 0 550453 [empty string]
26 GLAMAZON_GODDESS 74331 [empty string] [empty string] N GLAMAZON_GODDESS 0 550454 [empty string]
27 JOKES_ON_YOU 74332 [empty string] [empty string] N JOKES_ON_YOU 0 550455 [empty string]
28 WELCOME_NEIGHBORHOOD 74333 [empty string] [empty string] N WELCOME_NEIGHBORHOOD 0 550456 [empty string]
29 JUSTICE_AND_GRACE 74334 [empty string] [empty string] N JUSTICE_AND_GRACE 0 550457 [empty string]
30 NEW_DISGUISE_WHO_DIS 74335 [empty string] [empty string] N NEW_DISGUISE_WHO_DIS 0 550458 [empty string]
31 FLAMINGOITE_AURA 74336 [empty string] [empty string] N FLAMINGOITE_AURA 0 554502 [empty string]
32 CITRINE_MIMOSA_DREAM 74337 [empty string] [empty string] N CITRINE_MIMOSA_DREAM 0 554503 [empty string]
33 ZEBRA_JASPER_COACH 74338 [empty string] [empty string] N ZEBRA_JASPER_COACH 0 554504 [empty string]
34 DONT_FLOCK_FLAMINGO 74339 [empty string] [empty string] N DONT_FLOCK_FLAMINGO 0 556115 [empty string]
35 THE_GANGS_ALL_QUEER 74340 [empty string] [empty string] N THE_GANGS_ALL_QUEER 0 556116 [empty string]
36 The Eh Team 74341 [empty string] [empty string] N The Eh Team 0 557386 [empty string]
37 SCREW_METRIC_SYSTEM 74342 [empty string] [empty string] N SCREW_METRIC_SYSTEM 0 557387 [empty string]
38 BAD_AND_BAMBOOZY 74343 [empty string] [empty string] N BAD_AND_BAMBOOZY 0 559850 [empty string]
39 GRPE_APE_MISTAKE 74344 [empty string] [empty string] N GRPE_APE_MISTAKE 0 559851 [empty string]
40 TROPICAL_TUMMY 74345 [empty string] [empty string] N TROPICAL_TUMMY 0 559852 [empty string]
41 SIRENS_BOOTY_CALL 74346 [empty string] [empty string] N SIRENS_BOOTY_CALL 0 559853 [empty string]
42 YOU_HAD_ME_AT_DUNKIN 74347 [empty string] [empty string] N YOU_HAD_ME_AT_DUNKIN 0 560728 [empty string]
43 KING_OF_THE_TROPICS 74348 [empty string] [empty string] N KING_OF_THE_TROPICS 0 563075 [empty string]
44 TOURIST_TRAP_TABLOID 74349 [empty string] [empty string] N TOURIST_TRAP_TABLOID 0 563076 [empty string]
45 ELECTRIC_DINOTOPIA 74350 [empty string] [empty string] N ELECTRIC_DINOTOPIA 12 566302 [empty string]
46 BACK_9_BLACKOUT 74351 [empty string] [empty string] N BACK_9_BLACKOUT 3 566799 [empty string]
47 THREE_PARTS_TEE 74352 [empty string] [empty string] N THREE_PARTS_TEE 0 567225 [empty string]
48 SQUAWK_SQUAWK_MFLOCK 74353 [empty string] [empty string] N SQUAWK_SQUAWK_MFLOCK 0 567407 [empty string]
49 CARL_SINGLE_FLMINGLE 74354 [empty string] [empty string] N CARL_SINGLE_FLMINGLE 0 567408 [empty string]
50 DONT_SNAKE_MY_WAVE 74355 [empty string] [empty string] N DONT_SNAKE_MY_WAVE 0 568369 [empty string]
51 SELLS_HOUSE/BUYS_VAN 74356 [empty string] [empty string] N SELLS_HOUSE/BUYS_VAN 0 568370 [empty string]
52 NOT_YOUR_BRO_BRAH 74357 [empty string] [empty string] N NOT_YOUR_BRO_BRAH 0 568371 [empty string]
53 RADIOACTIVE_SPECTRAL 74358 [empty string] [empty string] N RADIOACTIVE_SPECTRAL 0 572219 [empty string]
54 LOST_IN_TRANSITION 74359 [empty string] [empty string] N LOST_IN_TRANSITION 0 582850 [empty string]
55 TALK_CELTIC_TO_ME 74360 [empty string] [empty string] N TALK_CELTIC_TO_ME 11 589118 [empty string]
56 APPOLLOGIZE_FOR_NOTH 74361 [empty string] [empty string] N APPOLLOGIZE_FOR_NOTH 7 592363 [empty string]
57 DIONYSUS_ORGY 74362 [empty string] [empty string] N DIONYSUS_ORGY 11 592364 [empty string]
58 BEACH_PLEASE 74363 [empty string] [empty string] N BEACH_PLEASE 13 593305 [empty string]
59 THESE_SHADES_TRASH 74364 [empty string] [empty string] N THESE_SHADES_TRASH 19 594490 [empty string]
60 I_DO_TO_OPEN_BAR 74365 [empty string] [empty string] N I_DO_TO_OPEN_BAR 27 594823 [empty string]
61 THANKS_ITS_A_RENTAL 74366 [empty string] [empty string] N THANKS_ITS_A_RENTAL 24 594824 [empty string]
62 PRIDE_NO_PREJUDICE 74367 [empty string] [empty string] N PRIDE_NO_PREJUDICE 95 595268 [empty string]
63 MUD_WRESTLING 74368 [empty string] [empty string] N MUD_WRESTLING 10 596060 [empty string]
64 ARTEMIS_IDENTITY 74369 [empty string] [empty string] N ARTEMIS_IDENTITY 8 596061 [empty string]
65 GET_CANUCKED_UP 74370 [empty string] [empty string] N GET_CANUCKED_UP 10 597352 [empty string]
66 HAM_CURED_CRAMPS 74371 [empty string] [empty string] N HAM_CURED_CRAMPS 8 597353 [empty string]
67 DR_4_R_E_SHOTS 74372 [empty string] [empty string] N DR_4_R_E_SHOTS 10 597354 [empty string]
68 FOUNDING_FATHER 74373 [empty string] [empty string] N FOUNDING_FATHER 0 598738 [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+