Goodr OG Running Sunglasses

Style: OGRS

Brand: goodr

$25.00

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