Goodr OG Running Sunglasses

Style: OGRS

Brand: goodr

$25.00

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX NON_INVT ORIGATTR1 QOH SKU_ID SORT_ORDER
1 NoColor 56618 [empty string] [empty string] N NoColor 8 529148 [empty string]
2 BROWN_BEER 56619 [empty string] [empty string] N BROWN_BEER 11 477393 [empty string]
3 CAN_I_TIKI_YOUR_FNCY 56620 [empty string] [empty string] N CAN_I_TIKI_YOUR_FNCY 0 523544 [empty string]
4 CARLS_IDIOT_COUSIN 56621 [empty string] [empty string] N CARLS_IDIOT_COUSIN 1 523959 [empty string]
5 CLEAR/PURPLE 56622 [empty string] [empty string] N CLEAR/PURPLE 1 441689 [empty string]
6 CREAM/PURPLE 56623 [empty string] [empty string] N CREAM/PURPLE 0 160688 [empty string]
7 DARK_PURPLE/VIOLET 56624 [empty string] [empty string] N DARK_PURPLE/VIOLET 0 477394 [empty string]
8 DKPLP 56625 [empty string] [empty string] N DKPLP 0 477395 [empty string]
9 DONKEY_GOGGLES 56626 [empty string] [empty string] N DONKEY_GOGGLES 4 523846 [empty string]
10 EMPIRE_DID_NOTHING_W 56627 [empty string] [empty string] N EMPIRE_DID_NOTHING_W 6 525050 [empty string]
11 FALKORS_FEVER_DREAM 56628 [empty string] [empty string] N FALKORS_FEVER_DREAM 5 523847 [empty string]
12 FLAMINGO/TEAL 56629 [empty string] [empty string] N FLAMINGO/TEAL 0 160689 [empty string]
13 FLAMINGO_BLUE/BLACK 56630 [empty string] [empty string] N FLAMINGO_BLUE/BLACK 3 477396 [empty string]
14 FLBWL 56631 [empty string] [empty string] N FLBWL 0 477397 [empty string]
15 FLLBP 56632 [empty string] [empty string] N FLLBP 0 477398 [empty string]
16 FLORAL_BLACK/BLACK 56633 [empty string] [empty string] N FLORAL_BLACK/BLACK 0 477399 [empty string]
17 FLORAL_GREEN/ORANGE 56634 [empty string] [empty string] N FLORAL_GREEN/ORANGE 0 477400 [empty string]
18 FLORAL_MAROON/MAROON 56635 [empty string] [empty string] N FLORAL_MAROON/MAROON 0 477401 [empty string]
19 FLORAL_WHITE/GOLD 56636 [empty string] [empty string] N FLORAL_WHITE/GOLD 0 477402 [empty string]
20 FLWPW 56637 [empty string] [empty string] N FLWPW 0 477403 [empty string]
21 GIVE_EM_THE_BIRD 56638 [empty string] [empty string] N GIVE_EM_THE_BIRD 0 523960 [empty string]
22 GNGGY 56639 [empty string] [empty string] N GNGGY 1 518859 [empty string]
23 GOLDEN_LASSO_GLASSOS 56640 [empty string] [empty string] N GOLDEN_LASSO_GLASSOS 0 523543 [empty string]
24 GREEN/BLUE 56641 [empty string] [empty string] N GREEN/BLUE 0 441690 [empty string]
25 GREEN/GOLD 56642 [empty string] [empty string] N GREEN/GOLD 0 160690 [empty string]
26 GREEN/GREEN 56643 [empty string] [empty string] N GREEN/GREEN 0 160691 [empty string]
27 GREEN/ROSE 56644 [empty string] [empty string] N GREEN/ROSE 0 160692 [empty string]
28 GREEN/TEAL 56645 [empty string] [empty string] N GREEN/TEAL 0 160693 [empty string]
29 GREEN_TACO 56646 [empty string] [empty string] N GREEN_TACO 0 477404 [empty string]
30 GREY/CHROME 56647 [empty string] [empty string] N GREY/CHROME 0 160694 [empty string]
31 HOUND/BROWN 56648 [empty string] [empty string] N HOUND/BROWN 0 441691 [empty string]
32 ICE_BLUE/ICE_BLUE 56649 [empty string] [empty string] N ICE_BLUE/ICE_BLUE 0 518860 [empty string]
33 ICED_BY_YETIS 56650 [empty string] [empty string] N ICED_BY_YETIS 14 525051 [empty string]
34 LBLB 56651 [empty string] [empty string] N LBLB 0 477405 [empty string]
35 LGBTQ_AF 56652 [empty string] [empty string] N LGBTQ_AF 0 523844 [empty string]
36 LIGHT_BLUE/BLACK 56653 [empty string] [empty string] N LIGHT_BLUE/BLACK 0 441692 [empty string]
37 LIGHT_BLUE/BLUE 56654 [empty string] [empty string] N LIGHT_BLUE/BLUE 0 160695 [empty string]
38 LIME/GREEN/YELLOW 56655 [empty string] [empty string] N LIME/GREEN/YELLOW 5 518861 [empty string]
39 MAROON/ROSE 56656 [empty string] [empty string] N MAROON/ROSE 1 477406 [empty string]
40 MICK_AND_KEITHS 56657 [empty string] [empty string] N MICK_AND_KEITHS 18 523848 [empty string]
41 NAVY/GOLD 56658 [empty string] [empty string] N NAVY/GOLD 0 477407 [empty string]
42 NESSYS_MIDNIGHT_ORGY 56659 [empty string] [empty string] N NESSYS_MIDNIGHT_ORGY 12 523849 [empty string]
43 CHARLIE_COULDNT_HACK 56660 [empty string] [empty string] N CHARLIE_COULDNT_HACK 0 525822 [empty string]
44 FRANKS_LLAMA_LAND 56661 [empty string] [empty string] N FRANKS_LLAMA_LAND 0 525823 [empty string]
45 GARDENING_KRAKEN 56662 [empty string] [empty string] N GARDENING_KRAKEN 16 525824 [empty string]
46 GOING_TO_VALHALLA 56663 [empty string] [empty string] N GOING_TO_VALHALLA 6 525825 [empty string]
47 A_GINGERS_SOUL 56664 [empty string] [empty string] N A_GINGERS_SOUL 12 523845 [empty string]
48 BLACK/AMBER 56665 [empty string] [empty string] N BLACK/AMBER 0 477379 [empty string]
49 BLACK/BLUE/BLUE 56666 [empty string] [empty string] N BLACK/BLUE/BLUE 0 477381 [empty string]
50 BLACK/CHROME/CHROME 56667 [empty string] [empty string] N BLACK/CHROME/CHROME 0 477382 [empty string]
51 BLACK/CLEAR 56668 [empty string] [empty string] N BLACK/CLEAR 0 160684 [empty string]
52 BLACK/GOLD/BLACK 56669 [empty string] [empty string] N BLACK/GOLD/BLACK 0 518858 [empty string]
53 BLACK/GOLD/GOLD 56670 [empty string] [empty string] N BLACK/GOLD/GOLD 0 477383 [empty string]
54 BLACK/GREEN/GREEN 56671 [empty string] [empty string] N BLACK/GREEN/GREEN 0 477384 [empty string]
55 BLACK/PEACH/PEACH 56672 [empty string] [empty string] N BLACK/PEACH/PEACH 0 477385 [empty string]
56 BLACK/PINK/PINK 56673 [empty string] [empty string] N BLACK/PINK/PINK 0 477386 [empty string]
57 BLACK/PURPLE/PURPLE 56674 [empty string] [empty string] N BLACK/PURPLE/PURPLE 0 477387 [empty string]
58 BLUE/BLUE 56675 [empty string] [empty string] N BLUE/BLUE 0 160686 [empty string]
59 BLUE/GOLD 56676 [empty string] [empty string] N BLUE/GOLD 0 160687 [empty string]
60 BLUE/LIGHT_BLUE 56677 [empty string] [empty string] N BLUE/LIGHT_BLUE 0 441687 [empty string]
61 BLUE_DONUT 56678 [empty string] [empty string] N BLUE_DONUT 34 477390 [empty string]
62 BLUE_GREEN/BLACK 56679 [empty string] [empty string] N BLUE_GREEN/BLACK 0 477391 [empty string]
63 BOSLEYS_BASSET_HOUND 56680 [empty string] [empty string] N BOSLEYS_BASSET_HOUND 4 525049 [empty string]
64 BLACK/TEAL 56681 [empty string] [empty string] N BLACK/TEAL 0 160685 [empty string]
65 BLACK_CHOCOLATE 56682 [empty string] [empty string] N BLACK_CHOCOLATE 5 477389 [empty string]
66 BROWN/CLEAR/BROWN 56683 [empty string] [empty string] N BROWN/CLEAR/BROWN 0 477392 [empty string]
67 ORANGE/ORANGE 56684 [empty string] [empty string] N ORANGE/ORANGE 0 477408 [empty string]
68 PARTY_LIKE_ITS_1984 56685 [empty string] [empty string] N PARTY_LIKE_ITS_1984 0 523545 [empty string]
69 PURPLE/GOLD 56686 [empty string] [empty string] N PURPLE/GOLD 0 160696 [empty string]
70 PURPLE/ORANGE 56687 [empty string] [empty string] N PURPLE/ORANGE 0 441693 [empty string]
71 PURPLE/PINK/VIOLET 56688 [empty string] [empty string] N PURPLE/PINK/VIOLET 0 518863 [empty string]
72 PURPLE/PURPLE 56689 [empty string] [empty string] N PURPLE/PURPLE 0 160697 [empty string]
73 PURPLE/PURPLE/TEAL 56690 [empty string] [empty string] N PURPLE/PURPLE/TEAL 0 160698 [empty string]
74 PURPLE/RAINBOW 56691 [empty string] [empty string] N PURPLE/RAINBOW 0 477409 [empty string]
75 RED/GOLD/GOLD 56692 [empty string] [empty string] N RED/GOLD/GOLD 0 518864 [empty string]
76 RED/WHITE/GREEN 56693 [empty string] [empty string] N RED/WHITE/GREEN 0 477411 [empty string]
77 RED_HAMBURGER 56694 [empty string] [empty string] N RED_HAMBURGER 0 477412 [empty string]
78 SORRY_NOT_SORRY 56695 [empty string] [empty string] N SORRY_NOT_SORRY 0 525052 [empty string]
79 SUCK_IT_KING_GEORGE 56696 [empty string] [empty string] N SUCK_IT_KING_GEORGE 0 525048 [empty string]
80 SUNBATH_WITH_WIZARDS 56697 [empty string] [empty string] N SUNBATH_WITH_WIZARDS 12 523850 [empty string]
81 SWEDISH_MEATBALL 56698 [empty string] [empty string] N SWEDISH_MEATBALL 7 523851 [empty string]
82 TARGR 56699 [empty string] [empty string] N TARGR 0 477413 [empty string]
83 TEAL/PURPLE 56700 [empty string] [empty string] N TEAL/PURPLE 0 160699 [empty string]
84 TEAL/TEAL 56701 [empty string] [empty string] N TEAL/TEAL 0 160700 [empty string]
85 THEFUTUREISNEON 56702 [empty string] [empty string] N THEFUTUREISNEON 22 523542 [empty string]
86 VINCENTS_ABSINTHE 56703 [empty string] [empty string] N VINCENTS_ABSINTHE 11 523852 [empty string]
87 WHISKEY_SHOTS 56704 [empty string] [empty string] N WHISKEY_SHOTS 20 523853 [empty string]
88 WHITE/BLUE/DARK_BLUE 56705 [empty string] [empty string] N WHITE/BLUE/DARK_BLUE 0 477414 [empty string]
89 WHITE/BLUE/ORANGE 56706 [empty string] [empty string] N WHITE/BLUE/ORANGE 0 477415 [empty string]
90 WHITE/GOLD 56707 [empty string] [empty string] N WHITE/GOLD 0 477416 [empty string]
91 WHITE/GREEN 56708 [empty string] [empty string] N WHITE/GREEN 0 160701 [empty string]
92 WHITE/GREEN/RED 56709 [empty string] [empty string] N WHITE/GREEN/RED 0 477417 [empty string]
93 WHITE/PURPLE 56710 [empty string] [empty string] N WHITE/PURPLE 0 160702 [empty string]
94 WHITE/RED/GREEN 56711 [empty string] [empty string] N WHITE/RED/GREEN 0 441694 [empty string]
95 WHITE/RED/YELLOW 56712 [empty string] [empty string] N WHITE/RED/YELLOW 0 477418 [empty string]
96 WHITE/ROSE 56713 [empty string] [empty string] N WHITE/ROSE 6 441695 [empty string]
97 WHITE/YELLOW 56714 [empty string] [empty string] N WHITE/YELLOW 0 160703 [empty string]
98 WHITE_ICE_CREAM 56715 [empty string] [empty string] N WHITE_ICE_CREAM 0 477419 [empty string]
99 WODKB 56716 [empty string] [empty string] N WODKB 0 477420 [empty string]
100 WRPGR 56717 [empty string] [empty string] N WRPGR 0 477421 [empty string]
101 YELLOW/CLEAR_YELLOW 56718 [empty string] [empty string] N YELLOW/CLEAR_YELLOW 0 160704 [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 13195
Free shipping on all orders $50+