Feetures Elite Light Cushion Tab
Style: E500
Brand: feetures
$18.00
query
RESULTSET
query
ATTR1
ATTR1_ENTRY_ID
FAM
HEX
NON_INVT
ORIGATTR1
QOH
SKU_ID
SORT_ORDER
1
FREEDOM_BLUE
81447
[empty string]
[empty string]
N
FREEDOM_BLUE
0
524930
[empty string]
2
ARUBA_BLUE/CORAL
81448
[empty string]
[empty string]
N
ARUBA_BLUE/CORAL
0
159194
[empty string]
3
ASTEROID_GREY
81449
[empty string]
[empty string]
N
ASTEROID_GREY
0
477148
[empty string]
4
ATLANTIS/LAVA
81450
[empty string]
[empty string]
N
ATLANTIS/LAVA
0
159195
[empty string]
5
AURORA_BLUE
81451
[empty string]
[empty string]
N
AURORA_BLUE
0
477154
[empty string]
6
BBLRF
81452
[empty string]
[empty string]
N
BBLRF
0
159196
[empty string]
7
BLACK/PACIFIC_BLUE
81453
[empty string]
[empty string]
N
BLACK/PACIFIC_BLUE
0
159197
[empty string]
8
BLACK/REFLECTOR
81454
[empty string]
[empty string]
N
BLACK/REFLECTOR
0
159198
[empty string]
9
CAMELLIA/VIOLET
81455
[empty string]
[empty string]
N
CAMELLIA/VIOLET
0
159199
[empty string]
10
CAPRI/PINK_POP
81456
[empty string]
[empty string]
N
CAPRI/PINK_POP
0
159200
[empty string]
11
COBALT/LAVA
81457
[empty string]
[empty string]
N
COBALT/LAVA
0
159201
[empty string]
12
CORAL/DEEP_PINK
81458
[empty string]
[empty string]
N
CORAL/DEEP_PINK
0
159202
[empty string]
13
COSMIC_SAPPHIRE
81459
[empty string]
[empty string]
N
COSMIC_SAPPHIRE
0
477160
[empty string]
14
DEEP_PINK/ARUBA_BLUE
81460
[empty string]
[empty string]
N
DEEP_PINK/ARUBA_BLUE
0
159203
[empty string]
15
FIERCE_MAGENTA
81461
[empty string]
[empty string]
N
FIERCE_MAGENTA
0
477172
[empty string]
16
FIERY
81462
[empty string]
[empty string]
N
FIERY
0
159204
[empty string]
17
FIJI
81463
[empty string]
[empty string]
N
FIJI
0
477178
[empty string]
18
FUSCHIA_POP
81464
[empty string]
[empty string]
N
FUSCHIA_POP
0
159205
[empty string]
19
FUSCHIA_REFLECTOR
81465
[empty string]
[empty string]
N
FUSCHIA_REFLECTOR
0
159206
[empty string]
20
NAVY/REFLECTOR
81466
[empty string]
[empty string]
N
NAVY/REFLECTOR
0
159207
[empty string]
21
NEBULA_NAVY
81467
[empty string]
[empty string]
N
NEBULA_NAVY
0
477190
[empty string]
22
ORCHID/BLUE_LAGOON
81468
[empty string]
[empty string]
N
ORCHID/BLUE_LAGOON
0
159208
[empty string]
23
PBLRF
81469
[empty string]
[empty string]
N
PBLRF
0
159209
[empty string]
24
POWER_PURPLE
81470
[empty string]
[empty string]
N
POWER_PURPLE
0
159210
[empty string]
25
PULSAR_PURPLE
81471
[empty string]
[empty string]
N
PULSAR_PURPLE
0
477196
[empty string]
26
PURIST_BLUE
81472
[empty string]
[empty string]
N
PURIST_BLUE
0
477202
[empty string]
27
PURPLE_HORIZON
81473
[empty string]
[empty string]
N
PURPLE_HORIZON
0
477208
[empty string]
28
QUSAR_PINK
81474
[empty string]
[empty string]
N
QUSAR_PINK
0
477214
[empty string]
29
SUNRISE_PINK_POP
81475
[empty string]
[empty string]
N
SUNRISE_PINK_POP
0
159211
[empty string]
30
SUNRISE_PLUM
81476
[empty string]
[empty string]
N
SUNRISE_PLUM
0
159212
[empty string]
31
SUNRISE_REFLECTOR
81477
[empty string]
[empty string]
N
SUNRISE_REFLECTOR
0
159213
[empty string]
32
ULTRAVIOLET/CORAL
81478
[empty string]
[empty string]
N
ULTRAVIOLET/CORAL
0
159214
[empty string]
33
VIOLA/LAVA
81479
[empty string]
[empty string]
N
VIOLA/LAVA
0
159215
[empty string]
34
VOLT/CARBON
81480
[empty string]
[empty string]
N
VOLT/CARBON
0
159216
[empty string]
35
BLACK
81481
[empty string]
[empty string]
N
BLACK
83
159217
[empty string]
36
BLACK/BLUE
81482
[empty string]
[empty string]
N
BLACK/BLUE
0
159218
[empty string]
37
CORAL
81483
[empty string]
[empty string]
N
CORAL
0
441567
[empty string]
38
EVERGREEN
81484
[empty string]
[empty string]
N
EVERGREEN
0
477166
[empty string]
39
GRAPHITE/BLACK
81485
[empty string]
[empty string]
N
GRAPHITE/BLACK
0
159219
[empty string]
40
GRAY
81486
[empty string]
[empty string]
N
GRAY
97
441573
[empty string]
41
HIBISCUS
81487
[empty string]
[empty string]
N
HIBISCUS
0
477184
[empty string]
42
RUBY
81488
[empty string]
[empty string]
N
RUBY
0
441579
[empty string]
43
SAPPHIRE
81489
[empty string]
[empty string]
N
SAPPHIRE
0
441585
[empty string]
44
SKY
81490
[empty string]
[empty string]
N
SKY
0
159220
[empty string]
45
WHITE
81491
[empty string]
[empty string]
N
WHITE
53
441591
[empty string]
46
WHITE/BLACK
81492
[empty string]
[empty string]
N
WHITE/BLACK
0
159221
[empty string]
47
HEATHER_ROSE
81493
[empty string]
[empty string]
N
HEATHER_ROSE
0
535363
[empty string]
48
SOFT_MOSS
81494
[empty string]
[empty string]
N
SOFT_MOSS
0
535369
[empty string]
49
FENCH_NAVY
81495
[empty string]
[empty string]
N
FENCH_NAVY
0
535375
[empty string]
50
BLUE_MOON
81496
[empty string]
[empty string]
N
BLUE_MOON
0
535426
[empty string]
51
PURPLE_ADDICT
81497
[empty string]
[empty string]
N
PURPLE_ADDICT
0
535432
[empty string]
52
IRON_ORE
81498
[empty string]
[empty string]
N
IRON_ORE
0
535484
[empty string]
53
SUMMER_MARINE
81499
[empty string]
[empty string]
N
SUMMER_MARINE
0
535490
[empty string]
54
MORNING_MIST
81500
[empty string]
[empty string]
N
MORNING_MIST
0
536724
[empty string]
55
RUN_RUDOLPH
81501
[empty string]
[empty string]
N
RUN_RUDOLPH
0
537410
[empty string]
56
BRICKYARD_GRAY
81502
[empty string]
[empty string]
N
BRICKYARD_GRAY
0
545310
[empty string]
57
POLYCHROME_PINK
81503
[empty string]
[empty string]
N
POLYCHROME_PINK
0
546475
[empty string]
58
PURPLE_NITRO
81504
[empty string]
[empty string]
N
PURPLE_NITRO
0
546481
[empty string]
59
NIGHT_VISION
81505
[empty string]
[empty string]
N
NIGHT_VISION
0
546487
[empty string]
60
USA_Blue
81506
[empty string]
[empty string]
N
USA_Blue
0
551466
[empty string]
61
BLUSH
81507
[empty string]
[empty string]
N
BLUSH
0
562430
[empty string]
62
BLUE_GLASS
81508
[empty string]
[empty string]
N
BLUE_GLASS
0
562436
[empty string]
63
DEEP_OCEAN
81509
[empty string]
[empty string]
N
DEEP_OCEAN
4
562442
[empty string]
64
SMOKY_QUARTZ
81510
[empty string]
[empty string]
N
SMOKY_QUARTZ
0
563045
[empty string]
65
AL_AQUA
81511
[empty string]
[empty string]
N
AL_AQUA
0
563051
[empty string]
66
OCEANIC
81512
[empty string]
[empty string]
N
OCEANIC
6
563057
[empty string]
67
NEON_MINT
81513
[empty string]
[empty string]
N
NEON_MINT
0
576392
[empty string]
68
ELECTRIC_PEACH
81514
[empty string]
[empty string]
N
ELECTRIC_PEACH
6
576398
[empty string]
69
BERRY
81515
[empty string]
[empty string]
N
BERRY
12
577985
[empty string]
70
ATLANTIC_BLUE
81516
[empty string]
[empty string]
N
ATLANTIC_BLUE
0
577991
[empty string]
71
MISTLE_TOE_GREEN
81517
[empty string]
[empty string]
N
MISTLE_TOE_GREEN
0
578566
[empty string]
72
GO_GRAY
81518
[empty string]
[empty string]
N
GO_GRAY
5
582672
[empty string]
73
PULSE_PURPLE
81519
[empty string]
[empty string]
N
PULSE_PURPLE
11
582678
[empty string]
74
BOUNCE_BLACK
81520
[empty string]
[empty string]
N
BOUNCE_BLACK
32
582684
[empty string]
75
MARITIME_NAVY
81521
[empty string]
[empty string]
N
MARITIME_NAVY
0
585796
[empty string]
76
PURPLE_ORCHID
81522
[empty string]
[empty string]
N
PURPLE_ORCHID
0
585802
[empty string]
77
2022_USA
81523
[empty string]
[empty string]
N
2022_USA
22
594377
[empty string]
78
LIGHTNING
81524
[empty string]
[empty string]
N
LIGHTNING
4
594539
[empty string]
79
RACING RED
81525
[empty string]
[empty string]
N
RACING RED
7
594545
[empty string]
80
PROPOLUSION_PINK
81526
[empty string]
[empty string]
N
PROPOLUSION_PINK
0
595562
[empty string]
81
BOOST_BLUE
81527
[empty string]
[empty string]
N
BOOST_BLUE
1
595568
[empty string]
82
LILAC_MUAVE
81528
[empty string]
[empty string]
N
LILAC_MUAVE
62
604957
[empty string]
83
SEA_ICE
81529
[empty string]
[empty string]
N
SEA_ICE
38
604963
[empty string]
84
MOSS_GREEN
81530
[empty string]
[empty string]
N
MOSS_GREEN
71
604969
[empty string]
85
GEO_PRINT_BLUE
81531
[empty string]
[empty string]
N
GEO_PRINT_BLUE
12
604975
[empty string]
86
GEO_PRINT_PURPLE
81532
[empty string]
[empty string]
N
GEO_PRINT_PURPLE
7
604981
[empty string]
87
GINGERBREAD_MAN
81533
[empty string]
[empty string]
N
GINGERBREAD_MAN
13
613136
[empty string]
88
POP_OFF_PEACH
81534
[empty string]
[empty string]
N
POP_OFF_PEACH
35
622376
[empty string]
89
PUSH_THRU_PINK
81535
[empty string]
[empty string]
N
PUSH_THRU_PINK
38
622382
[empty string]
90
BUST_OUT_BLACK
81536
[empty string]
[empty string]
N
BUST_OUT_BLACK
42
622388
[empty string]
91
DARK_CHERRY
81537
[empty string]
[empty string]
N
DARK_CHERRY
6
623591
[empty string]
92
BLACK_NEON
81538
[empty string]
[empty string]
N
BLACK_NEON
6
623597
[empty string]
CACHED
false
EXECUTIONTIME
31
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