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 8 529148 [empty string]
2 BROWN_BEER 56619 [empty string] [empty string] BROWN_BEER 11 477393 [empty string]
3 CARLS_IDIOT_COUSIN 56621 [empty string] [empty string] CARLS_IDIOT_COUSIN 1 523959 [empty string]
4 DONKEY_GOGGLES 56626 [empty string] [empty string] DONKEY_GOGGLES 4 523846 [empty string]
5 EMPIRE_DID_NOTHING_W 56627 [empty string] [empty string] EMPIRE_DID_NOTHING_W 3 525050 [empty string]
6 FALKORS_FEVER_DREAM 56628 [empty string] [empty string] FALKORS_FEVER_DREAM 7 523847 [empty string]
7 FLAMINGO_BLUE/BLACK 56630 [empty string] [empty string] FLAMINGO_BLUE/BLACK 2 477396 [empty string]
8 GREY/CHROME 56647 [empty string] [empty string] GREY/CHROME 1 160694 [empty string]
9 ICED_BY_YETIS 56650 [empty string] [empty string] ICED_BY_YETIS 8 525051 [empty string]
10 LGBTQ_AF 56652 [empty string] [empty string] LGBTQ_AF 15 523844 [empty string]
11 LIME/GREEN/YELLOW 56655 [empty string] [empty string] LIME/GREEN/YELLOW 5 518861 [empty string]
12 MAROON/ROSE 56656 [empty string] [empty string] MAROON/ROSE 1 477406 [empty string]
13 MICK_AND_KEITHS 56657 [empty string] [empty string] MICK_AND_KEITHS 19 523848 [empty string]
14 NAVY/GOLD 56658 [empty string] [empty string] NAVY/GOLD 3 477407 [empty string]
15 NESSYS_MIDNIGHT_ORGY 56659 [empty string] [empty string] NESSYS_MIDNIGHT_ORGY 5 523849 [empty string]
16 CHARLIE_COULDNT_HACK 56660 [empty string] [empty string] CHARLIE_COULDNT_HACK 1 525822 [empty string]
17 FRANKS_LLAMA_LAND 56661 [empty string] [empty string] FRANKS_LLAMA_LAND 3 525823 [empty string]
18 GARDENING_KRAKEN 56662 [empty string] [empty string] GARDENING_KRAKEN 7 525824 [empty string]
19 GOING_TO_VALHALLA 56663 [empty string] [empty string] GOING_TO_VALHALLA 4 525825 [empty string]
20 A_GINGERS_SOUL 56664 [empty string] [empty string] A_GINGERS_SOUL 16 523845 [empty string]
21 BLACK/AMBER 56665 [empty string] [empty string] BLACK/AMBER 2 477379 [empty string]
22 BLUE_DONUT 56678 [empty string] [empty string] BLUE_DONUT 42 477390 [empty string]
23 BOSLEYS_BASSET_HOUND 56680 [empty string] [empty string] BOSLEYS_BASSET_HOUND 1 525049 [empty string]
24 BLACK_CHOCOLATE 56682 [empty string] [empty string] BLACK_CHOCOLATE 6 477389 [empty string]
25 RED/GOLD/GOLD 56692 [empty string] [empty string] RED/GOLD/GOLD 1 518864 [empty string]
26 RED_HAMBURGER 56694 [empty string] [empty string] RED_HAMBURGER 2 477412 [empty string]
27 SUNBATH_WITH_WIZARDS 56697 [empty string] [empty string] SUNBATH_WITH_WIZARDS 9 523850 [empty string]
28 SWEDISH_MEATBALL 56698 [empty string] [empty string] SWEDISH_MEATBALL 2 523851 [empty string]
29 THEFUTUREISNEON 56702 [empty string] [empty string] THEFUTUREISNEON 30 523542 [empty string]
30 VINCENTS_ABSINTHE 56703 [empty string] [empty string] VINCENTS_ABSINTHE 11 523852 [empty string]
31 WHISKEY_SHOTS 56704 [empty string] [empty string] WHISKEY_SHOTS 11 523853 [empty string]
32 WHITE/ROSE 56713 [empty string] [empty string] WHITE/ROSE 4 441695 [empty string]
CACHED false
EXECUTIONTIME 5
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 HAVING sum(e.qoh+e.qc) > 0 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 13195
Free shipping on orders $50+