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
80361
[empty string]
[empty string]
N
DOWN_TO_FIESTA
0
529149
[empty string]
2
PABST_OCLOCK
80362
[empty string]
[empty string]
N
PABST_OCLOCK
0
533010
[empty string]
3
PBR_EYE_CANDY
80363
[empty string]
[empty string]
N
PBR_EYE_CANDY
0
533011
[empty string]
4
PIBBERMOUFLAGE
80364
[empty string]
[empty string]
N
PIBBERMOUFLAGE
0
533012
[empty string]
5
FLAMINGOS_BOOZE
80365
[empty string]
[empty string]
N
FLAMINGOS_BOOZE
2
534032
[empty string]
6
BECKYS_BACHELORETTE
80366
[empty string]
[empty string]
N
BECKYS_BACHELORETTE
0
534033
[empty string]
7
PUMPKIN_SPICE_NIGHT
80367
[empty string]
[empty string]
N
PUMPKIN_SPICE_NIGHT
0
535152
[empty string]
8
CAPED_CRUSADER_SUN
80368
[empty string]
[empty string]
N
CAPED_CRUSADER_SUN
0
535394
[empty string]
9
POW_BAM_THANK_YOU
80369
[empty string]
[empty string]
N
POW_BAM_THANK_YOU
0
535395
[empty string]
10
PHOENIX_BLOODY_MARY
80370
[empty string]
[empty string]
N
PHOENIX_BLOODY_MARY
15
536640
[empty string]
11
PROFESSIONAL_RESPAWN
80371
[empty string]
[empty string]
N
PROFESSIONAL_RESPAWN
1
539774
[empty string]
12
SIDE_SCROLL_EYE_ROLL
80372
[empty string]
[empty string]
N
SIDE_SCROLL_EYE_ROLL
1
539775
[empty string]
13
WE_HAD_LIGHTS_FIRST
80373
[empty string]
[empty string]
N
WE_HAD_LIGHTS_FIRST
0
539776
[empty string]
14
NAKATOMI_TOWER
80374
[empty string]
[empty string]
N
NAKATOMI_TOWER
0
539777
[empty string]
15
UNION_JACK_FLASH
80375
[empty string]
[empty string]
N
UNION_JACK_FLASH
0
540295
[empty string]
16
COLD_ENGLISH_BLOOD
80376
[empty string]
[empty string]
N
COLD_ENGLISH_BLOOD
0
540296
[empty string]
17
TONGUING_YOU_62
80377
[empty string]
[empty string]
N
TONGUING_YOU_62
0
540297
[empty string]
18
WHAT_WOULD_KEITH_DO
80378
[empty string]
[empty string]
N
WHAT_WOULD_KEITH_DO
0
540298
[empty string]
19
INSERT_COIN_CONTINUE
80379
[empty string]
[empty string]
N
INSERT_COIN_CONTINUE
0
540299
[empty string]
20
WAKKA_WAKKA_WAKKA
80380
[empty string]
[empty string]
N
WAKKA_WAKKA_WAKKA
4
542243
[empty string]
21
PABST_ME_A_BEER
80381
[empty string]
[empty string]
N
PABST_ME_A_BEER
0
542806
[empty string]
22
SUNNIES_SPRINKLES
80382
[empty string]
[empty string]
N
SUNNIES_SPRINKLES
0
542807
[empty string]
23
ITS_TUESDAY_SOMEWHER
80383
[empty string]
[empty string]
N
ITS_TUESDAY_SOMEWHER
0
542808
[empty string]
24
PASSION_OF_THE_CRUST
80384
[empty string]
[empty string]
N
PASSION_OF_THE_CRUST
0
542809
[empty string]
25
DARK_KNIGHT_CLUBBIN
80385
[empty string]
[empty string]
N
DARK_KNIGHT_CLUBBIN
0
550453
[empty string]
26
GLAMAZON_GODDESS
80386
[empty string]
[empty string]
N
GLAMAZON_GODDESS
0
550454
[empty string]
27
JOKES_ON_YOU
80387
[empty string]
[empty string]
N
JOKES_ON_YOU
0
550455
[empty string]
28
WELCOME_NEIGHBORHOOD
80388
[empty string]
[empty string]
N
WELCOME_NEIGHBORHOOD
0
550456
[empty string]
29
JUSTICE_AND_GRACE
80389
[empty string]
[empty string]
N
JUSTICE_AND_GRACE
0
550457
[empty string]
30
NEW_DISGUISE_WHO_DIS
80390
[empty string]
[empty string]
N
NEW_DISGUISE_WHO_DIS
0
550458
[empty string]
31
FLAMINGOITE_AURA
80391
[empty string]
[empty string]
N
FLAMINGOITE_AURA
0
554502
[empty string]
32
CITRINE_MIMOSA_DREAM
80392
[empty string]
[empty string]
N
CITRINE_MIMOSA_DREAM
0
554503
[empty string]
33
ZEBRA_JASPER_COACH
80393
[empty string]
[empty string]
N
ZEBRA_JASPER_COACH
0
554504
[empty string]
34
DONT_FLOCK_FLAMINGO
80394
[empty string]
[empty string]
N
DONT_FLOCK_FLAMINGO
0
556115
[empty string]
35
THE_GANGS_ALL_QUEER
80395
[empty string]
[empty string]
N
THE_GANGS_ALL_QUEER
0
556116
[empty string]
36
The Eh Team
80396
[empty string]
[empty string]
N
The Eh Team
0
557386
[empty string]
37
SCREW_METRIC_SYSTEM
80397
[empty string]
[empty string]
N
SCREW_METRIC_SYSTEM
0
557387
[empty string]
38
BAD_AND_BAMBOOZY
80398
[empty string]
[empty string]
N
BAD_AND_BAMBOOZY
0
559850
[empty string]
39
GRPE_APE_MISTAKE
80399
[empty string]
[empty string]
N
GRPE_APE_MISTAKE
0
559851
[empty string]
40
TROPICAL_TUMMY
80400
[empty string]
[empty string]
N
TROPICAL_TUMMY
0
559852
[empty string]
41
SIRENS_BOOTY_CALL
80401
[empty string]
[empty string]
N
SIRENS_BOOTY_CALL
0
559853
[empty string]
42
YOU_HAD_ME_AT_DUNKIN
80402
[empty string]
[empty string]
N
YOU_HAD_ME_AT_DUNKIN
0
560728
[empty string]
43
KING_OF_THE_TROPICS
80403
[empty string]
[empty string]
N
KING_OF_THE_TROPICS
0
563075
[empty string]
44
TOURIST_TRAP_TABLOID
80404
[empty string]
[empty string]
N
TOURIST_TRAP_TABLOID
0
563076
[empty string]
45
ELECTRIC_DINOTOPIA
80405
[empty string]
[empty string]
N
ELECTRIC_DINOTOPIA
5
566302
[empty string]
46
BACK_9_BLACKOUT
80406
[empty string]
[empty string]
N
BACK_9_BLACKOUT
0
566799
[empty string]
47
THREE_PARTS_TEE
80407
[empty string]
[empty string]
N
THREE_PARTS_TEE
0
567225
[empty string]
48
SQUAWK_SQUAWK_MFLOCK
80408
[empty string]
[empty string]
N
SQUAWK_SQUAWK_MFLOCK
0
567407
[empty string]
49
CARL_SINGLE_FLMINGLE
80409
[empty string]
[empty string]
N
CARL_SINGLE_FLMINGLE
0
567408
[empty string]
50
DONT_SNAKE_MY_WAVE
80410
[empty string]
[empty string]
N
DONT_SNAKE_MY_WAVE
0
568369
[empty string]
51
SELLS_HOUSE/BUYS_VAN
80411
[empty string]
[empty string]
N
SELLS_HOUSE/BUYS_VAN
0
568370
[empty string]
52
NOT_YOUR_BRO_BRAH
80412
[empty string]
[empty string]
N
NOT_YOUR_BRO_BRAH
0
568371
[empty string]
53
RADIOACTIVE_SPECTRAL
80413
[empty string]
[empty string]
N
RADIOACTIVE_SPECTRAL
0
572219
[empty string]
54
LOST_IN_TRANSITION
80414
[empty string]
[empty string]
N
LOST_IN_TRANSITION
0
582850
[empty string]
55
TALK_CELTIC_TO_ME
80415
[empty string]
[empty string]
N
TALK_CELTIC_TO_ME
0
589118
[empty string]
56
APPOLLOGIZE_FOR_NOTH
80416
[empty string]
[empty string]
N
APPOLLOGIZE_FOR_NOTH
0
592363
[empty string]
57
DIONYSUS_ORGY
80417
[empty string]
[empty string]
N
DIONYSUS_ORGY
0
592364
[empty string]
58
BEACH_PLEASE
80418
[empty string]
[empty string]
N
BEACH_PLEASE
-1
593305
[empty string]
59
THESE_SHADES_TRASH
80419
[empty string]
[empty string]
N
THESE_SHADES_TRASH
0
594490
[empty string]
60
I_DO_TO_OPEN_BAR
80420
[empty string]
[empty string]
N
I_DO_TO_OPEN_BAR
0
594823
[empty string]
61
THANKS_ITS_A_RENTAL
80421
[empty string]
[empty string]
N
THANKS_ITS_A_RENTAL
0
594824
[empty string]
62
PRIDE_NO_PREJUDICE
80422
[empty string]
[empty string]
N
PRIDE_NO_PREJUDICE
0
595268
[empty string]
63
MUD_WRESTLING
80423
[empty string]
[empty string]
N
MUD_WRESTLING
0
596060
[empty string]
64
ARTEMIS_IDENTITY
80424
[empty string]
[empty string]
N
ARTEMIS_IDENTITY
0
596061
[empty string]
65
GET_CANUCKED_UP
80425
[empty string]
[empty string]
N
GET_CANUCKED_UP
6
597352
[empty string]
66
HAM_CURED_CRAMPS
80426
[empty string]
[empty string]
N
HAM_CURED_CRAMPS
0
597353
[empty string]
67
DR_4_R_E_SHOTS
80427
[empty string]
[empty string]
N
DR_4_R_E_SHOTS
5
597354
[empty string]
68
FOUNDING_FATHER
80428
[empty string]
[empty string]
N
FOUNDING_FATHER
84
598738
[empty string]
69
CHEETAHS_ALWAYS_WIN
80429
[empty string]
[empty string]
N
CHEETAHS_ALWAYS_WIN
7
601539
[empty string]
70
BIFROST_BRIDGE
80430
[empty string]
[empty string]
N
BIFROST_BRIDGE
0
602383
[empty string]
71
MIGHTY_MJOLNIR
80431
[empty string]
[empty string]
N
MIGHTY_MJOLNIR
0
602384
[empty string]
72
LOVE_AND_THUNDER
80432
[empty string]
[empty string]
N
LOVE_AND_THUNDER
0
602385
[empty string]
73
IN_DOG_WE_TRUST
80433
[empty string]
[empty string]
N
IN_DOG_WE_TRUST
0
603110
[empty string]
74
GRAND_CANYON
80434
[empty string]
[empty string]
N
GRAND_CANYON
0
603111
[empty string]
75
REDWOOD
80435
[empty string]
[empty string]
N
REDWOOD
0
603112
[empty string]
76
HOT_ALIEN_SUMMER
80436
[empty string]
[empty string]
N
HOT_ALIEN_SUMMER
3
604418
[empty string]
77
GAZPACHO_NO_BRAKES
80437
[empty string]
[empty string]
N
GAZPACHO_NO_BRAKES
17
605442
[empty string]
78
NO_IDEA_HOW_DID_THAT
80438
[empty string]
[empty string]
N
NO_IDEA_HOW_DID_THAT
0
605555
[empty string]
79
INITIATE_GOD_MODE
80439
[empty string]
[empty string]
N
INITIATE_GOD_MODE
0
605556
[empty string]
80
SEE_YOU_DIGITAL_HELL
80440
[empty string]
[empty string]
N
SEE_YOU_DIGITAL_HELL
7
605557
[empty string]
81
NEVER_GET_RECIPE
80441
[empty string]
[empty string]
N
NEVER_GET_RECIPE
24
614148
[empty string]
82
SILVERBACK_SQUAT
80442
[empty string]
[empty string]
N
SILVERBACK_SQUAT
0
619166
[empty string]
CACHED
false
EXECUTIONTIME
16
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,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS