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 76829 [empty string] [empty string] N DOWN_TO_FIESTA 0 529149 [empty string]
2 PABST_OCLOCK 76830 [empty string] [empty string] N PABST_OCLOCK 0 533010 [empty string]
3 PBR_EYE_CANDY 76831 [empty string] [empty string] N PBR_EYE_CANDY 0 533011 [empty string]
4 PIBBERMOUFLAGE 76832 [empty string] [empty string] N PIBBERMOUFLAGE 0 533012 [empty string]
5 FLAMINGOS_BOOZE 76833 [empty string] [empty string] N FLAMINGOS_BOOZE 1 534032 [empty string]
6 BECKYS_BACHELORETTE 76834 [empty string] [empty string] N BECKYS_BACHELORETTE 0 534033 [empty string]
7 PUMPKIN_SPICE_NIGHT 76835 [empty string] [empty string] N PUMPKIN_SPICE_NIGHT 0 535152 [empty string]
8 CAPED_CRUSADER_SUN 76836 [empty string] [empty string] N CAPED_CRUSADER_SUN 0 535394 [empty string]
9 POW_BAM_THANK_YOU 76837 [empty string] [empty string] N POW_BAM_THANK_YOU 0 535395 [empty string]
10 PHOENIX_BLOODY_MARY 76838 [empty string] [empty string] N PHOENIX_BLOODY_MARY 15 536640 [empty string]
11 PROFESSIONAL_RESPAWN 76839 [empty string] [empty string] N PROFESSIONAL_RESPAWN 1 539774 [empty string]
12 SIDE_SCROLL_EYE_ROLL 76840 [empty string] [empty string] N SIDE_SCROLL_EYE_ROLL 3 539775 [empty string]
13 WE_HAD_LIGHTS_FIRST 76841 [empty string] [empty string] N WE_HAD_LIGHTS_FIRST 0 539776 [empty string]
14 NAKATOMI_TOWER 76842 [empty string] [empty string] N NAKATOMI_TOWER 0 539777 [empty string]
15 UNION_JACK_FLASH 76843 [empty string] [empty string] N UNION_JACK_FLASH 0 540295 [empty string]
16 COLD_ENGLISH_BLOOD 76844 [empty string] [empty string] N COLD_ENGLISH_BLOOD 0 540296 [empty string]
17 TONGUING_YOU_62 76845 [empty string] [empty string] N TONGUING_YOU_62 0 540297 [empty string]
18 WHAT_WOULD_KEITH_DO 76846 [empty string] [empty string] N WHAT_WOULD_KEITH_DO 0 540298 [empty string]
19 INSERT_COIN_CONTINUE 76847 [empty string] [empty string] N INSERT_COIN_CONTINUE 0 540299 [empty string]
20 WAKKA_WAKKA_WAKKA 76848 [empty string] [empty string] N WAKKA_WAKKA_WAKKA 0 542243 [empty string]
21 PABST_ME_A_BEER 76849 [empty string] [empty string] N PABST_ME_A_BEER 0 542806 [empty string]
22 SUNNIES_SPRINKLES 76850 [empty string] [empty string] N SUNNIES_SPRINKLES 0 542807 [empty string]
23 ITS_TUESDAY_SOMEWHER 76851 [empty string] [empty string] N ITS_TUESDAY_SOMEWHER 0 542808 [empty string]
24 PASSION_OF_THE_CRUST 76852 [empty string] [empty string] N PASSION_OF_THE_CRUST 0 542809 [empty string]
25 DARK_KNIGHT_CLUBBIN 76853 [empty string] [empty string] N DARK_KNIGHT_CLUBBIN 0 550453 [empty string]
26 GLAMAZON_GODDESS 76854 [empty string] [empty string] N GLAMAZON_GODDESS 0 550454 [empty string]
27 JOKES_ON_YOU 76855 [empty string] [empty string] N JOKES_ON_YOU 0 550455 [empty string]
28 WELCOME_NEIGHBORHOOD 76856 [empty string] [empty string] N WELCOME_NEIGHBORHOOD 0 550456 [empty string]
29 JUSTICE_AND_GRACE 76857 [empty string] [empty string] N JUSTICE_AND_GRACE 0 550457 [empty string]
30 NEW_DISGUISE_WHO_DIS 76858 [empty string] [empty string] N NEW_DISGUISE_WHO_DIS 0 550458 [empty string]
31 FLAMINGOITE_AURA 76859 [empty string] [empty string] N FLAMINGOITE_AURA 0 554502 [empty string]
32 CITRINE_MIMOSA_DREAM 76860 [empty string] [empty string] N CITRINE_MIMOSA_DREAM 0 554503 [empty string]
33 ZEBRA_JASPER_COACH 76861 [empty string] [empty string] N ZEBRA_JASPER_COACH 0 554504 [empty string]
34 DONT_FLOCK_FLAMINGO 76862 [empty string] [empty string] N DONT_FLOCK_FLAMINGO 0 556115 [empty string]
35 THE_GANGS_ALL_QUEER 76863 [empty string] [empty string] N THE_GANGS_ALL_QUEER 0 556116 [empty string]
36 The Eh Team 76864 [empty string] [empty string] N The Eh Team 0 557386 [empty string]
37 SCREW_METRIC_SYSTEM 76865 [empty string] [empty string] N SCREW_METRIC_SYSTEM 0 557387 [empty string]
38 BAD_AND_BAMBOOZY 76866 [empty string] [empty string] N BAD_AND_BAMBOOZY 0 559850 [empty string]
39 GRPE_APE_MISTAKE 76867 [empty string] [empty string] N GRPE_APE_MISTAKE 0 559851 [empty string]
40 TROPICAL_TUMMY 76868 [empty string] [empty string] N TROPICAL_TUMMY 0 559852 [empty string]
41 SIRENS_BOOTY_CALL 76869 [empty string] [empty string] N SIRENS_BOOTY_CALL 0 559853 [empty string]
42 YOU_HAD_ME_AT_DUNKIN 76870 [empty string] [empty string] N YOU_HAD_ME_AT_DUNKIN 0 560728 [empty string]
43 KING_OF_THE_TROPICS 76871 [empty string] [empty string] N KING_OF_THE_TROPICS 0 563075 [empty string]
44 TOURIST_TRAP_TABLOID 76872 [empty string] [empty string] N TOURIST_TRAP_TABLOID 0 563076 [empty string]
45 ELECTRIC_DINOTOPIA 76873 [empty string] [empty string] N ELECTRIC_DINOTOPIA 2 566302 [empty string]
46 BACK_9_BLACKOUT 76874 [empty string] [empty string] N BACK_9_BLACKOUT -1 566799 [empty string]
47 THREE_PARTS_TEE 76875 [empty string] [empty string] N THREE_PARTS_TEE 0 567225 [empty string]
48 SQUAWK_SQUAWK_MFLOCK 76876 [empty string] [empty string] N SQUAWK_SQUAWK_MFLOCK 0 567407 [empty string]
49 CARL_SINGLE_FLMINGLE 76877 [empty string] [empty string] N CARL_SINGLE_FLMINGLE 0 567408 [empty string]
50 DONT_SNAKE_MY_WAVE 76878 [empty string] [empty string] N DONT_SNAKE_MY_WAVE 0 568369 [empty string]
51 SELLS_HOUSE/BUYS_VAN 76879 [empty string] [empty string] N SELLS_HOUSE/BUYS_VAN 0 568370 [empty string]
52 NOT_YOUR_BRO_BRAH 76880 [empty string] [empty string] N NOT_YOUR_BRO_BRAH 0 568371 [empty string]
53 RADIOACTIVE_SPECTRAL 76881 [empty string] [empty string] N RADIOACTIVE_SPECTRAL 0 572219 [empty string]
54 LOST_IN_TRANSITION 76882 [empty string] [empty string] N LOST_IN_TRANSITION 0 582850 [empty string]
55 TALK_CELTIC_TO_ME 76883 [empty string] [empty string] N TALK_CELTIC_TO_ME 1 589118 [empty string]
56 APPOLLOGIZE_FOR_NOTH 76884 [empty string] [empty string] N APPOLLOGIZE_FOR_NOTH 0 592363 [empty string]
57 DIONYSUS_ORGY 76885 [empty string] [empty string] N DIONYSUS_ORGY 6 592364 [empty string]
58 BEACH_PLEASE 76886 [empty string] [empty string] N BEACH_PLEASE -1 593305 [empty string]
59 THESE_SHADES_TRASH 76887 [empty string] [empty string] N THESE_SHADES_TRASH 0 594490 [empty string]
60 I_DO_TO_OPEN_BAR 76888 [empty string] [empty string] N I_DO_TO_OPEN_BAR 0 594823 [empty string]
61 THANKS_ITS_A_RENTAL 76889 [empty string] [empty string] N THANKS_ITS_A_RENTAL 6 594824 [empty string]
62 PRIDE_NO_PREJUDICE 76890 [empty string] [empty string] N PRIDE_NO_PREJUDICE 3 595268 [empty string]
63 MUD_WRESTLING 76891 [empty string] [empty string] N MUD_WRESTLING 0 596060 [empty string]
64 ARTEMIS_IDENTITY 76892 [empty string] [empty string] N ARTEMIS_IDENTITY 1 596061 [empty string]
65 GET_CANUCKED_UP 76893 [empty string] [empty string] N GET_CANUCKED_UP 7 597352 [empty string]
66 HAM_CURED_CRAMPS 76894 [empty string] [empty string] N HAM_CURED_CRAMPS 0 597353 [empty string]
67 DR_4_R_E_SHOTS 76895 [empty string] [empty string] N DR_4_R_E_SHOTS 6 597354 [empty string]
68 FOUNDING_FATHER 76896 [empty string] [empty string] N FOUNDING_FATHER 90 598738 [empty string]
69 CHEETAHS_ALWAYS_WIN 76897 [empty string] [empty string] N CHEETAHS_ALWAYS_WIN 14 601539 [empty string]
70 BIFROST_BRIDGE 76898 [empty string] [empty string] N BIFROST_BRIDGE 0 602383 [empty string]
71 MIGHTY_MJOLNIR 76899 [empty string] [empty string] N MIGHTY_MJOLNIR 0 602384 [empty string]
72 LOVE_AND_THUNDER 76900 [empty string] [empty string] N LOVE_AND_THUNDER 0 602385 [empty string]
73 IN_DOG_WE_TRUST 76901 [empty string] [empty string] N IN_DOG_WE_TRUST 0 603110 [empty string]
74 GRAND_CANYON 76902 [empty string] [empty string] N GRAND_CANYON 0 603111 [empty string]
75 REDWOOD 76903 [empty string] [empty string] N REDWOOD 0 603112 [empty string]
76 HOT_ALIEN_SUMMER 76904 [empty string] [empty string] N HOT_ALIEN_SUMMER 8 604418 [empty string]
77 GAZPACHO_NO_BRAKES 76905 [empty string] [empty string] N GAZPACHO_NO_BRAKES 18 605442 [empty string]
78 NO_IDEA_HOW_DID_THAT 76906 [empty string] [empty string] N NO_IDEA_HOW_DID_THAT 7 605555 [empty string]
79 INITIATE_GOD_MODE 76907 [empty string] [empty string] N INITIATE_GOD_MODE 8 605556 [empty string]
80 SEE_YOU_DIGITAL_HELL 76908 [empty string] [empty string] N SEE_YOU_DIGITAL_HELL 13 605557 [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+