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 66766 [empty string] [empty string] N DOWN_TO_FIESTA 0 529149 [empty string]
2 PABST_OCLOCK 66767 [empty string] [empty string] N PABST_OCLOCK 0 533010 [empty string]
3 PBR_EYE_CANDY 66768 [empty string] [empty string] N PBR_EYE_CANDY 0 533011 [empty string]
4 PIBBERMOUFLAGE 66769 [empty string] [empty string] N PIBBERMOUFLAGE 16 533012 [empty string]
5 FLAMINGOS_BOOZE 66770 [empty string] [empty string] N FLAMINGOS_BOOZE 3 534032 [empty string]
6 BECKYS_BACHELORETTE 66771 [empty string] [empty string] N BECKYS_BACHELORETTE 0 534033 [empty string]
7 PUMPKIN_SPICE_NIGHT 66772 [empty string] [empty string] N PUMPKIN_SPICE_NIGHT 0 535152 [empty string]
8 CAPED_CRUSADER_SUN 66773 [empty string] [empty string] N CAPED_CRUSADER_SUN 0 535394 [empty string]
9 POW_BAM_THANK_YOU 66774 [empty string] [empty string] N POW_BAM_THANK_YOU 0 535395 [empty string]
10 PHOENIX_BLOODY_MARY 66775 [empty string] [empty string] N PHOENIX_BLOODY_MARY 23 536640 [empty string]
11 PROFESSIONAL_RESPAWN 66776 [empty string] [empty string] N PROFESSIONAL_RESPAWN 12 539774 [empty string]
12 SIDE_SCROLL_EYE_ROLL 66777 [empty string] [empty string] N SIDE_SCROLL_EYE_ROLL 6 539775 [empty string]
13 WE_HAD_LIGHTS_FIRST 66778 [empty string] [empty string] N WE_HAD_LIGHTS_FIRST 0 539776 [empty string]
14 NAKATOMI_TOWER 66779 [empty string] [empty string] N NAKATOMI_TOWER 0 539777 [empty string]
15 UNION_JACK_FLASH 66780 [empty string] [empty string] N UNION_JACK_FLASH 1 540295 [empty string]
16 COLD_ENGLISH_BLOOD 66781 [empty string] [empty string] N COLD_ENGLISH_BLOOD 0 540296 [empty string]
17 TONGUING_YOU_62 66782 [empty string] [empty string] N TONGUING_YOU_62 0 540297 [empty string]
18 WHAT_WOULD_KEITH_DO 66783 [empty string] [empty string] N WHAT_WOULD_KEITH_DO 1 540298 [empty string]
19 INSERT_COIN_CONTINUE 66784 [empty string] [empty string] N INSERT_COIN_CONTINUE 0 540299 [empty string]
20 WAKKA_WAKKA_WAKKA 66785 [empty string] [empty string] N WAKKA_WAKKA_WAKKA 10 542243 [empty string]
21 PABST_ME_A_BEER 66786 [empty string] [empty string] N PABST_ME_A_BEER 0 542806 [empty string]
22 SUNNIES_SPRINKLES 66787 [empty string] [empty string] N SUNNIES_SPRINKLES 0 542807 [empty string]
23 ITS_TUESDAY_SOMEWHER 66788 [empty string] [empty string] N ITS_TUESDAY_SOMEWHER 0 542808 [empty string]
24 PASSION_OF_THE_CRUST 66789 [empty string] [empty string] N PASSION_OF_THE_CRUST 0 542809 [empty string]
25 DARK_KNIGHT_CLUBBIN 66790 [empty string] [empty string] N DARK_KNIGHT_CLUBBIN 2 550453 [empty string]
26 GLAMAZON_GODDESS 66791 [empty string] [empty string] N GLAMAZON_GODDESS 0 550454 [empty string]
27 JOKES_ON_YOU 66792 [empty string] [empty string] N JOKES_ON_YOU 0 550455 [empty string]
28 WELCOME_NEIGHBORHOOD 66793 [empty string] [empty string] N WELCOME_NEIGHBORHOOD 7 550456 [empty string]
29 JUSTICE_AND_GRACE 66794 [empty string] [empty string] N JUSTICE_AND_GRACE 0 550457 [empty string]
30 NEW_DISGUISE_WHO_DIS 66795 [empty string] [empty string] N NEW_DISGUISE_WHO_DIS 0 550458 [empty string]
31 FLAMINGOITE_AURA 66796 [empty string] [empty string] N FLAMINGOITE_AURA 0 554502 [empty string]
32 CITRINE_MIMOSA_DREAM 66797 [empty string] [empty string] N CITRINE_MIMOSA_DREAM -1 554503 [empty string]
33 ZEBRA_JASPER_COACH 66798 [empty string] [empty string] N ZEBRA_JASPER_COACH 0 554504 [empty string]
34 DONT_FLOCK_FLAMINGO 66799 [empty string] [empty string] N DONT_FLOCK_FLAMINGO 8 556115 [empty string]
35 THE_GANGS_ALL_QUEER 66800 [empty string] [empty string] N THE_GANGS_ALL_QUEER 0 556116 [empty string]
36 The Eh Team 66801 [empty string] [empty string] N The Eh Team 0 557386 [empty string]
37 SCREW_METRIC_SYSTEM 66802 [empty string] [empty string] N SCREW_METRIC_SYSTEM 4 557387 [empty string]
38 BAD_AND_BAMBOOZY 66803 [empty string] [empty string] N BAD_AND_BAMBOOZY 0 559850 [empty string]
39 GRPE_APE_MISTAKE 66804 [empty string] [empty string] N GRPE_APE_MISTAKE 0 559851 [empty string]
40 TROPICAL_TUMMY 66805 [empty string] [empty string] N TROPICAL_TUMMY 0 559852 [empty string]
41 SIRENS_BOOTY_CALL 66806 [empty string] [empty string] N SIRENS_BOOTY_CALL 0 559853 [empty string]
42 YOU_HAD_ME_AT_DUNKIN 66807 [empty string] [empty string] N YOU_HAD_ME_AT_DUNKIN 0 560728 [empty string]
43 KING_OF_THE_TROPICS 66808 [empty string] [empty string] N KING_OF_THE_TROPICS 2 563075 [empty string]
44 TOURIST_TRAP_TABLOID 66809 [empty string] [empty string] N TOURIST_TRAP_TABLOID 4 563076 [empty string]
45 ELECTRIC_DINOTOPIA 66810 [empty string] [empty string] N ELECTRIC_DINOTOPIA 1 566302 [empty string]
46 BACK_9_BLACKOUT 66811 [empty string] [empty string] N BACK_9_BLACKOUT 6 566799 [empty string]
47 THREE_PARTS_TEE 66812 [empty string] [empty string] N THREE_PARTS_TEE 5 567225 [empty string]
48 SQUAWK_SQUAWK_MFLOCK 66813 [empty string] [empty string] N SQUAWK_SQUAWK_MFLOCK 0 567407 [empty string]
49 CARL_SINGLE_FLMINGLE 66814 [empty string] [empty string] N CARL_SINGLE_FLMINGLE 17 567408 [empty string]
50 DONT_SNAKE_MY_WAVE 66815 [empty string] [empty string] N DONT_SNAKE_MY_WAVE 7 568369 [empty string]
51 SELLS_HOUSE/BUYS_VAN 66816 [empty string] [empty string] N SELLS_HOUSE/BUYS_VAN 3 568370 [empty string]
52 NOT_YOUR_BRO_BRAH 66817 [empty string] [empty string] N NOT_YOUR_BRO_BRAH 4 568371 [empty string]
53 RADIOACTIVE_SPECTRAL 66818 [empty string] [empty string] N RADIOACTIVE_SPECTRAL 13 572219 [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+