Feetures! Elite Max Cushion No Show Tab Sock

Style: EC500

Brand: feetures

$15.99

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SKU_ID SORT_ORDER
1 MAUI_BLUE 58638 [empty string] [empty string] MAUI_BLUE 0 477316 [empty string]
2 NEBULA_NAVY 58639 [empty string] [empty string] NEBULA_NAVY 0 477322 [empty string]
3 NIGHT_SKY 58640 [empty string] [empty string] NIGHT_SKY 0 477328 [empty string]
4 PULSAR_PURPLE 58641 [empty string] [empty string] PULSAR_PURPLE 0 477334 [empty string]
5 QUSAR_PINK 58642 [empty string] [empty string] QUSAR_PINK 0 477340 [empty string]
6 ATLANTIS/FUSCHIA 58643 [empty string] [empty string] ATLANTIS/FUSCHIA 0 159420 [empty string]
7 BERRY/LAVA 58644 [empty string] [empty string] BERRY/LAVA 0 159421 [empty string]
8 ASTEROID_GREY 58645 [empty string] [empty string] ASTEROID_GREY 0 477280 [empty string]
9 AURORA_BLUE 58646 [empty string] [empty string] AURORA_BLUE 0 477286 [empty string]
10 COSMIC_SAPPHIRE 58647 [empty string] [empty string] COSMIC_SAPPHIRE 12 477292 [empty string]
11 FIERCE_MAGENTA 58648 [empty string] [empty string] FIERCE_MAGENTA 17 477298 [empty string]
12 FIJI 58649 [empty string] [empty string] FIJI 0 477304 [empty string]
13 BLACK/REFLECTOR 58650 [empty string] [empty string] BLACK/REFLECTOR 0 159422 [empty string]
14 BRIGHT_BLUE/LAVA 58651 [empty string] [empty string] BRIGHT_BLUE/LAVA 0 159423 [empty string]
15 HBEP 58652 [empty string] [empty string] HBEP 0 159425 [empty string]
16 HGYRF 58653 [empty string] [empty string] HGYRF 0 159426 [empty string]
17 IRIS/HAWAIIAN_BLUE 58654 [empty string] [empty string] IRIS/HAWAIIAN_BLUE 0 159427 [empty string]
18 JURASSIC/BLUE_LAGOON 58655 [empty string] [empty string] JURASSIC/BLUE_LAGOON 0 159428 [empty string]
19 MINT/CAPRI 58656 [empty string] [empty string] MINT/CAPRI 0 159429 [empty string]
20 NAVY/BERMUDA_BLUE 58657 [empty string] [empty string] NAVY/BERMUDA_BLUE 0 159430 [empty string]
21 POWER_PURPLE 58658 [empty string] [empty string] POWER_PURPLE 0 159431 [empty string]
22 FUSCHIA_POP 58659 [empty string] [empty string] FUSCHIA_POP 0 159424 [empty string]
23 TRUE_BLUE 58660 [empty string] [empty string] TRUE_BLUE 0 159432 [empty string]
24 WISTERIA/REFLECTOR 58661 [empty string] [empty string] WISTERIA/REFLECTOR 0 159433 [empty string]
25 BLACK 58662 [empty string] [empty string] BLACK 58 159434 [empty string]
26 CORAL 58663 [empty string] [empty string] CORAL 0 441633 [empty string]
27 EMERALD 58664 [empty string] [empty string] EMERALD 0 441639 [empty string]
28 GREY 58665 [empty string] [empty string] GREY 59 159435 [empty string]
29 HIBISCUS 58666 [empty string] [empty string] HIBISCUS 0 477310 [empty string]
30 RUBY 58667 [empty string] [empty string] RUBY 0 441645 [empty string]
31 SAPPHIRE 58668 [empty string] [empty string] SAPPHIRE 0 441651 [empty string]
32 WHITE 58669 [empty string] [empty string] WHITE 50 159436 [empty string]
33 WHITE/BLACK 58670 [empty string] [empty string] WHITE/BLACK 0 159437 [empty string]
34 HEATHER_ROSE 58671 [empty string] [empty string] HEATHER_ROSE 30 535381 [empty string]
35 SOFT_MOSS 58672 [empty string] [empty string] SOFT_MOSS 30 535387 [empty string]
36 FRENCH_NAVY 58673 [empty string] [empty string] FRENCH_NAVY 48 535393 [empty string]
37 BLUE_MOON 58674 [empty string] [empty string] BLUE_MOON 0 535438 [empty string]
38 PURPLE_ADDICT 58675 [empty string] [empty string] PURPLE_ADDICT 0 535444 [empty string]
39 SUMMER_MARINE 58676 [empty string] [empty string] SUMMER_MARINE 4 535472 [empty string]
40 IRON_ORE 58677 [empty string] [empty string] IRON_ORE 14 535478 [empty string]
41 MORNING_MIST 58678 [empty string] [empty string] MORNING_MIST 6 536736 [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 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 12923
XS S M L XL XXL
Free shipping on orders $50+