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 76374 [empty string] [empty string] N FREEDOM_BLUE 0 524930 [empty string]
2 ARUBA_BLUE/CORAL 76375 [empty string] [empty string] N ARUBA_BLUE/CORAL 0 159194 [empty string]
3 ASTEROID_GREY 76376 [empty string] [empty string] N ASTEROID_GREY 0 477148 [empty string]
4 ATLANTIS/LAVA 76377 [empty string] [empty string] N ATLANTIS/LAVA 0 159195 [empty string]
5 AURORA_BLUE 76378 [empty string] [empty string] N AURORA_BLUE 0 477154 [empty string]
6 BBLRF 76379 [empty string] [empty string] N BBLRF 0 159196 [empty string]
7 BLACK/PACIFIC_BLUE 76380 [empty string] [empty string] N BLACK/PACIFIC_BLUE 0 159197 [empty string]
8 BLACK/REFLECTOR 76381 [empty string] [empty string] N BLACK/REFLECTOR 0 159198 [empty string]
9 CAMELLIA/VIOLET 76382 [empty string] [empty string] N CAMELLIA/VIOLET 0 159199 [empty string]
10 CAPRI/PINK_POP 76383 [empty string] [empty string] N CAPRI/PINK_POP 0 159200 [empty string]
11 COBALT/LAVA 76384 [empty string] [empty string] N COBALT/LAVA 0 159201 [empty string]
12 CORAL/DEEP_PINK 76385 [empty string] [empty string] N CORAL/DEEP_PINK 0 159202 [empty string]
13 COSMIC_SAPPHIRE 76386 [empty string] [empty string] N COSMIC_SAPPHIRE 0 477160 [empty string]
14 DEEP_PINK/ARUBA_BLUE 76387 [empty string] [empty string] N DEEP_PINK/ARUBA_BLUE 0 159203 [empty string]
15 FIERCE_MAGENTA 76388 [empty string] [empty string] N FIERCE_MAGENTA 0 477172 [empty string]
16 FIERY 76389 [empty string] [empty string] N FIERY 0 159204 [empty string]
17 FIJI 76390 [empty string] [empty string] N FIJI 0 477178 [empty string]
18 FUSCHIA_POP 76391 [empty string] [empty string] N FUSCHIA_POP 0 159205 [empty string]
19 FUSCHIA_REFLECTOR 76392 [empty string] [empty string] N FUSCHIA_REFLECTOR 0 159206 [empty string]
20 NAVY/REFLECTOR 76393 [empty string] [empty string] N NAVY/REFLECTOR 0 159207 [empty string]
21 NEBULA_NAVY 76394 [empty string] [empty string] N NEBULA_NAVY 0 477190 [empty string]
22 ORCHID/BLUE_LAGOON 76395 [empty string] [empty string] N ORCHID/BLUE_LAGOON 0 159208 [empty string]
23 PBLRF 76396 [empty string] [empty string] N PBLRF 0 159209 [empty string]
24 POWER_PURPLE 76397 [empty string] [empty string] N POWER_PURPLE 0 159210 [empty string]
25 PULSAR_PURPLE 76398 [empty string] [empty string] N PULSAR_PURPLE 0 477196 [empty string]
26 PURIST_BLUE 76399 [empty string] [empty string] N PURIST_BLUE 0 477202 [empty string]
27 PURPLE_HORIZON 76400 [empty string] [empty string] N PURPLE_HORIZON 0 477208 [empty string]
28 QUSAR_PINK 76401 [empty string] [empty string] N QUSAR_PINK 0 477214 [empty string]
29 SUNRISE_PINK_POP 76402 [empty string] [empty string] N SUNRISE_PINK_POP 0 159211 [empty string]
30 SUNRISE_PLUM 76403 [empty string] [empty string] N SUNRISE_PLUM 0 159212 [empty string]
31 SUNRISE_REFLECTOR 76404 [empty string] [empty string] N SUNRISE_REFLECTOR 0 159213 [empty string]
32 ULTRAVIOLET/CORAL 76405 [empty string] [empty string] N ULTRAVIOLET/CORAL 0 159214 [empty string]
33 VIOLA/LAVA 76406 [empty string] [empty string] N VIOLA/LAVA 0 159215 [empty string]
34 VOLT/CARBON 76407 [empty string] [empty string] N VOLT/CARBON 0 159216 [empty string]
35 BLACK 76408 [empty string] [empty string] N BLACK 56 159217 [empty string]
36 BLACK/BLUE 76409 [empty string] [empty string] N BLACK/BLUE 0 159218 [empty string]
37 CORAL 76410 [empty string] [empty string] N CORAL 0 441567 [empty string]
38 EVERGREEN 76411 [empty string] [empty string] N EVERGREEN 0 477166 [empty string]
39 GRAPHITE/BLACK 76412 [empty string] [empty string] N GRAPHITE/BLACK 0 159219 [empty string]
40 GRAY 76413 [empty string] [empty string] N GRAY 52 441573 [empty string]
41 HIBISCUS 76414 [empty string] [empty string] N HIBISCUS 0 477184 [empty string]
42 RUBY 76415 [empty string] [empty string] N RUBY 0 441579 [empty string]
43 SAPPHIRE 76416 [empty string] [empty string] N SAPPHIRE 0 441585 [empty string]
44 SKY 76417 [empty string] [empty string] N SKY 0 159220 [empty string]
45 WHITE 76418 [empty string] [empty string] N WHITE 38 441591 [empty string]
46 WHITE/BLACK 76419 [empty string] [empty string] N WHITE/BLACK 0 159221 [empty string]
47 HEATHER_ROSE 76420 [empty string] [empty string] N HEATHER_ROSE 0 535363 [empty string]
48 SOFT_MOSS 76421 [empty string] [empty string] N SOFT_MOSS 0 535369 [empty string]
49 FENCH_NAVY 76422 [empty string] [empty string] N FENCH_NAVY 0 535375 [empty string]
50 BLUE_MOON 76423 [empty string] [empty string] N BLUE_MOON 0 535426 [empty string]
51 PURPLE_ADDICT 76424 [empty string] [empty string] N PURPLE_ADDICT 0 535432 [empty string]
52 IRON_ORE 76425 [empty string] [empty string] N IRON_ORE 0 535484 [empty string]
53 SUMMER_MARINE 76426 [empty string] [empty string] N SUMMER_MARINE 0 535490 [empty string]
54 MORNING_MIST 76427 [empty string] [empty string] N MORNING_MIST 0 536724 [empty string]
55 RUN_RUDOLPH 76428 [empty string] [empty string] N RUN_RUDOLPH 0 537410 [empty string]
56 BRICKYARD_GRAY 76429 [empty string] [empty string] N BRICKYARD_GRAY 0 545310 [empty string]
57 POLYCHROME_PINK 76430 [empty string] [empty string] N POLYCHROME_PINK 0 546475 [empty string]
58 PURPLE_NITRO 76431 [empty string] [empty string] N PURPLE_NITRO 0 546481 [empty string]
59 NIGHT_VISION 76432 [empty string] [empty string] N NIGHT_VISION 0 546487 [empty string]
60 USA_Blue 76433 [empty string] [empty string] N USA_Blue 0 551466 [empty string]
61 BLUSH 76434 [empty string] [empty string] N BLUSH 1 562430 [empty string]
62 BLUE_GLASS 76435 [empty string] [empty string] N BLUE_GLASS 0 562436 [empty string]
63 DEEP_OCEAN 76436 [empty string] [empty string] N DEEP_OCEAN 4 562442 [empty string]
64 SMOKY_QUARTZ 76437 [empty string] [empty string] N SMOKY_QUARTZ 1 563045 [empty string]
65 AL_AQUA 76438 [empty string] [empty string] N AL_AQUA 0 563051 [empty string]
66 OCEANIC 76439 [empty string] [empty string] N OCEANIC 7 563057 [empty string]
67 NEON_MINT 76440 [empty string] [empty string] N NEON_MINT 0 576392 [empty string]
68 ELECTRIC_PEACH 76441 [empty string] [empty string] N ELECTRIC_PEACH 0 576398 [empty string]
69 BERRY 76442 [empty string] [empty string] N BERRY 21 577985 [empty string]
70 ATLANTIC_BLUE 76443 [empty string] [empty string] N ATLANTIC_BLUE 0 577991 [empty string]
71 MISTLE_TOE_GREEN 76444 [empty string] [empty string] N MISTLE_TOE_GREEN 1 578566 [empty string]
72 GO_GRAY 76445 [empty string] [empty string] N GO_GRAY 18 582672 [empty string]
73 PULSE_PURPLE 76446 [empty string] [empty string] N PULSE_PURPLE 36 582678 [empty string]
74 BOUNCE_BLACK 76447 [empty string] [empty string] N BOUNCE_BLACK 46 582684 [empty string]
75 MARITIME_NAVY 76448 [empty string] [empty string] N MARITIME_NAVY 0 585796 [empty string]
76 PURPLE_ORCHID 76449 [empty string] [empty string] N PURPLE_ORCHID 0 585802 [empty string]
77 2022_USA 76450 [empty string] [empty string] N 2022_USA 36 594377 [empty string]
78 LIGHTNING 76451 [empty string] [empty string] N LIGHTNING 8 594539 [empty string]
79 RACING RED 76452 [empty string] [empty string] N RACING RED 11 594545 [empty string]
80 PROPOLUSION_PINK 76453 [empty string] [empty string] N PROPOLUSION_PINK 3 595562 [empty string]
81 BOOST_BLUE 76454 [empty string] [empty string] N BOOST_BLUE 1 595568 [empty string]
82 LILAC_MUAVE 76455 [empty string] [empty string] N LILAC_MUAVE 62 604957 [empty string]
83 SEA_ICE 76456 [empty string] [empty string] N SEA_ICE 42 604963 [empty string]
84 MOSS_GREEN 76457 [empty string] [empty string] N MOSS_GREEN 66 604969 [empty string]
85 GEO_PRINT_BLUE 76458 [empty string] [empty string] N GEO_PRINT_BLUE 0 604975 [empty string]
86 GEO_PRINT_PURPLE 76459 [empty string] [empty string] N GEO_PRINT_PURPLE 0 604981 [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) GROUP BY b.attr1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 12920
XS S M L XL XXL
Free shipping on all orders $50+