Home gear Feetures! Elite Max Cushion No Show Tab Sock

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
array
1 12923
XS S M L XL XXL

Shipping

We offer free standard shipping on all orders $50+ and a flat rate on all orders under that amount. Expedited shipping is available in checkout for a shipping premium. 

Returns

Any unworn product can be returned for a full refund within 90 days. We do not offer free return shipping except in cases of defective items. These can be returned for a full refund within 90 days at no expense to you. Please contact us with any inquiries.

Returns can be mailed to:
Runners Plus
8970 Kingsridge Dr.
Dayton, OH 45458

Free shipping on orders of $50+.
Sign in
Your Account (0)