Feetures! Elite Max Cushion No Show Tab Sock
Style: EC500
Brand: feetures
$18.00
query
RESULTSET
query
ATTR1
ATTR1_ENTRY_ID
FAM
HEX
NON_INVT
ORIGATTR1
QOH
SKU_ID
SORT_ORDER
1
MAUI_BLUE
81598
[empty string]
[empty string]
N
MAUI_BLUE
0
477316
[empty string]
2
NEBULA_NAVY
81599
[empty string]
[empty string]
N
NEBULA_NAVY
0
477322
[empty string]
3
NIGHT_SKY
81600
[empty string]
[empty string]
N
NIGHT_SKY
0
477328
[empty string]
4
PULSAR_PURPLE
81601
[empty string]
[empty string]
N
PULSAR_PURPLE
0
477334
[empty string]
5
QUSAR_PINK
81602
[empty string]
[empty string]
N
QUSAR_PINK
0
477340
[empty string]
6
ATLANTIS/FUSCHIA
81603
[empty string]
[empty string]
N
ATLANTIS/FUSCHIA
0
159420
[empty string]
7
BERRY/LAVA
81604
[empty string]
[empty string]
N
BERRY/LAVA
0
159421
[empty string]
8
ASTEROID_GREY
81605
[empty string]
[empty string]
N
ASTEROID_GREY
0
477280
[empty string]
9
AURORA_BLUE
81606
[empty string]
[empty string]
N
AURORA_BLUE
0
477286
[empty string]
10
COSMIC_SAPPHIRE
81607
[empty string]
[empty string]
N
COSMIC_SAPPHIRE
0
477292
[empty string]
11
FIERCE_MAGENTA
81608
[empty string]
[empty string]
N
FIERCE_MAGENTA
0
477298
[empty string]
12
FIJI
81609
[empty string]
[empty string]
N
FIJI
0
477304
[empty string]
13
BLACK/REFLECTOR
81610
[empty string]
[empty string]
N
BLACK/REFLECTOR
0
159422
[empty string]
14
BRIGHT_BLUE/LAVA
81611
[empty string]
[empty string]
N
BRIGHT_BLUE/LAVA
0
159423
[empty string]
15
HBEP
81612
[empty string]
[empty string]
N
HBEP
0
159425
[empty string]
16
HGYRF
81613
[empty string]
[empty string]
N
HGYRF
0
159426
[empty string]
17
IRIS/HAWAIIAN_BLUE
81614
[empty string]
[empty string]
N
IRIS/HAWAIIAN_BLUE
0
159427
[empty string]
18
JURASSIC/BLUE_LAGOON
81615
[empty string]
[empty string]
N
JURASSIC/BLUE_LAGOON
0
159428
[empty string]
19
MINT/CAPRI
81616
[empty string]
[empty string]
N
MINT/CAPRI
0
159429
[empty string]
20
NAVY/BERMUDA_BLUE
81617
[empty string]
[empty string]
N
NAVY/BERMUDA_BLUE
0
159430
[empty string]
21
POWER_PURPLE
81618
[empty string]
[empty string]
N
POWER_PURPLE
0
159431
[empty string]
22
FUSCHIA_POP
81619
[empty string]
[empty string]
N
FUSCHIA_POP
0
159424
[empty string]
23
TRUE_BLUE
81620
[empty string]
[empty string]
N
TRUE_BLUE
0
159432
[empty string]
24
WISTERIA/REFLECTOR
81621
[empty string]
[empty string]
N
WISTERIA/REFLECTOR
0
159433
[empty string]
25
BLACK
81622
[empty string]
[empty string]
N
BLACK
114
159434
[empty string]
26
CORAL
81623
[empty string]
[empty string]
N
CORAL
0
441633
[empty string]
27
EMERALD
81624
[empty string]
[empty string]
N
EMERALD
0
441639
[empty string]
28
GREY
81625
[empty string]
[empty string]
N
GREY
109
159435
[empty string]
29
HIBISCUS
81626
[empty string]
[empty string]
N
HIBISCUS
0
477310
[empty string]
30
RUBY
81627
[empty string]
[empty string]
N
RUBY
0
441645
[empty string]
31
SAPPHIRE
81628
[empty string]
[empty string]
N
SAPPHIRE
0
441651
[empty string]
32
WHITE
81629
[empty string]
[empty string]
N
WHITE
99
159436
[empty string]
33
WHITE/BLACK
81630
[empty string]
[empty string]
N
WHITE/BLACK
0
159437
[empty string]
34
HEATHER_ROSE
81631
[empty string]
[empty string]
N
HEATHER_ROSE
0
535381
[empty string]
35
SOFT_MOSS
81632
[empty string]
[empty string]
N
SOFT_MOSS
0
535387
[empty string]
36
FRENCH_NAVY
81633
[empty string]
[empty string]
N
FRENCH_NAVY
0
535393
[empty string]
37
BLUE_MOON
81634
[empty string]
[empty string]
N
BLUE_MOON
0
535438
[empty string]
38
PURPLE_ADDICT
81635
[empty string]
[empty string]
N
PURPLE_ADDICT
0
535444
[empty string]
39
SUMMER_MARINE
81636
[empty string]
[empty string]
N
SUMMER_MARINE
0
535472
[empty string]
40
IRON_ORE
81637
[empty string]
[empty string]
N
IRON_ORE
0
535478
[empty string]
41
MORNING_MIST
81638
[empty string]
[empty string]
N
MORNING_MIST
0
536736
[empty string]
42
BRICKYARD_GRAY
81639
[empty string]
[empty string]
N
BRICKYARD_GRAY
0
545328
[empty string]
43
POLYCHROME_PINK
81640
[empty string]
[empty string]
N
POLYCHROME_PINK
0
546511
[empty string]
44
PURPLE_NITRO
81641
[empty string]
[empty string]
N
PURPLE_NITRO
0
546517
[empty string]
45
NIGHT_VISION
81642
[empty string]
[empty string]
N
NIGHT_VISION
0
546523
[empty string]
46
BLUSH
81643
[empty string]
[empty string]
N
BLUSH
0
562412
[empty string]
47
BLUE_GLASS
81644
[empty string]
[empty string]
N
BLUE_GLASS
0
562418
[empty string]
48
DEEP_OCEAN
81645
[empty string]
[empty string]
N
DEEP_OCEAN
0
562424
[empty string]
49
SMOKY_QUARTZ
81646
[empty string]
[empty string]
N
SMOKY_QUARTZ
0
563069
[empty string]
50
GO_GRAY
81647
[empty string]
[empty string]
N
GO_GRAY
0
582642
[empty string]
51
PULSE_PURPLE
81648
[empty string]
[empty string]
N
PULSE_PURPLE
5
582648
[empty string]
52
RACING_RED
81649
[empty string]
[empty string]
N
RACING_RED
9
582654
[empty string]
53
MARITIME_NAVY
81650
[empty string]
[empty string]
N
MARITIME_NAVY
0
585814
[empty string]
54
2022_USA
81651
[empty string]
[empty string]
N
2022_USA
0
594383
[empty string]
55
GLOWING_GRAY
81652
[empty string]
[empty string]
N
GLOWING_GRAY
0
594551
[empty string]
56
PROPULSION_PINK
81653
[empty string]
[empty string]
N
PROPULSION_PINK
0
595574
[empty string]
57
LIGHTENING
81654
[empty string]
[empty string]
N
LIGHTENING
5
595580
[empty string]
58
BOOST_BLUE
81655
[empty string]
[empty string]
N
BOOST_BLUE
2
595615
[empty string]
59
BOUNCE_BLACK
81656
[empty string]
[empty string]
N
BOUNCE_BLACK
2
603096
[empty string]
60
LILAC_MUAVE
81657
[empty string]
[empty string]
N
LILAC_MUAVE
60
604933
[empty string]
61
SEA_ICE
81658
[empty string]
[empty string]
N
SEA_ICE
31
604939
[empty string]
62
MOSS_GREEN
81659
[empty string]
[empty string]
N
MOSS_GREEN
64
604999
[empty string]
63
POP_OFF_PEACH
81660
[empty string]
[empty string]
N
POP_OFF_PEACH
23
622324
[empty string]
64
PUSH_THRU_PINK
81661
[empty string]
[empty string]
N
PUSH_THRU_PINK
39
622330
[empty string]
65
BUST_OUT_BLACK
81662
[empty string]
[empty string]
N
BUST_OUT_BLACK
44
622336
[empty string]
66
ELECTRIC_PEACH
81663
[empty string]
[empty string]
N
ELECTRIC_PEACH
12
623615
[empty string]
CACHED
false
EXECUTIONTIME
15
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