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
array
1 12920
XS S M L XL XXL
Free shipping on orders of $50+.