Feetures Elite Light Cushion Tab

Style: E500

Brand: feetures

$15.99

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX NON_INVT ORIGATTR1 QOH SKU_ID SORT_ORDER
1 FREEDOM_BLUE 60354 [empty string] [empty string] N FREEDOM_BLUE 1 524930 [empty string]
2 ARUBA_BLUE/CORAL 60355 [empty string] [empty string] N ARUBA_BLUE/CORAL 0 159194 [empty string]
3 ASTEROID_GREY 60356 [empty string] [empty string] N ASTEROID_GREY 0 477148 [empty string]
4 ATLANTIS/LAVA 60357 [empty string] [empty string] N ATLANTIS/LAVA 0 159195 [empty string]
5 AURORA_BLUE 60358 [empty string] [empty string] N AURORA_BLUE 0 477154 [empty string]
6 BBLRF 60359 [empty string] [empty string] N BBLRF 0 159196 [empty string]
7 BLACK/PACIFIC_BLUE 60360 [empty string] [empty string] N BLACK/PACIFIC_BLUE 0 159197 [empty string]
8 BLACK/REFLECTOR 60361 [empty string] [empty string] N BLACK/REFLECTOR 0 159198 [empty string]
9 CAMELLIA/VIOLET 60362 [empty string] [empty string] N CAMELLIA/VIOLET 0 159199 [empty string]
10 CAPRI/PINK_POP 60363 [empty string] [empty string] N CAPRI/PINK_POP 0 159200 [empty string]
11 COBALT/LAVA 60364 [empty string] [empty string] N COBALT/LAVA 0 159201 [empty string]
12 CORAL/DEEP_PINK 60365 [empty string] [empty string] N CORAL/DEEP_PINK 0 159202 [empty string]
13 COSMIC_SAPPHIRE 60366 [empty string] [empty string] N COSMIC_SAPPHIRE 3 477160 [empty string]
14 DEEP_PINK/ARUBA_BLUE 60367 [empty string] [empty string] N DEEP_PINK/ARUBA_BLUE 0 159203 [empty string]
15 FIERCE_MAGENTA 60368 [empty string] [empty string] N FIERCE_MAGENTA 11 477172 [empty string]
16 FIERY 60369 [empty string] [empty string] N FIERY 0 159204 [empty string]
17 FIJI 60370 [empty string] [empty string] N FIJI 0 477178 [empty string]
18 FUSCHIA_POP 60371 [empty string] [empty string] N FUSCHIA_POP 0 159205 [empty string]
19 FUSCHIA_REFLECTOR 60372 [empty string] [empty string] N FUSCHIA_REFLECTOR 0 159206 [empty string]
20 NAVY/REFLECTOR 60373 [empty string] [empty string] N NAVY/REFLECTOR 0 159207 [empty string]
21 NEBULA_NAVY 60374 [empty string] [empty string] N NEBULA_NAVY 0 477190 [empty string]
22 ORCHID/BLUE_LAGOON 60375 [empty string] [empty string] N ORCHID/BLUE_LAGOON 0 159208 [empty string]
23 PBLRF 60376 [empty string] [empty string] N PBLRF 0 159209 [empty string]
24 POWER_PURPLE 60377 [empty string] [empty string] N POWER_PURPLE 0 159210 [empty string]
25 PULSAR_PURPLE 60378 [empty string] [empty string] N PULSAR_PURPLE 0 477196 [empty string]
26 PURIST_BLUE 60379 [empty string] [empty string] N PURIST_BLUE 1 477202 [empty string]
27 PURPLE_HORIZON 60380 [empty string] [empty string] N PURPLE_HORIZON 0 477208 [empty string]
28 QUSAR_PINK 60381 [empty string] [empty string] N QUSAR_PINK 0 477214 [empty string]
29 SUNRISE_PINK_POP 60382 [empty string] [empty string] N SUNRISE_PINK_POP 0 159211 [empty string]
30 SUNRISE_PLUM 60383 [empty string] [empty string] N SUNRISE_PLUM 0 159212 [empty string]
31 SUNRISE_REFLECTOR 60384 [empty string] [empty string] N SUNRISE_REFLECTOR 0 159213 [empty string]
32 ULTRAVIOLET/CORAL 60385 [empty string] [empty string] N ULTRAVIOLET/CORAL 0 159214 [empty string]
33 VIOLA/LAVA 60386 [empty string] [empty string] N VIOLA/LAVA 0 159215 [empty string]
34 VOLT/CARBON 60387 [empty string] [empty string] N VOLT/CARBON 0 159216 [empty string]
35 BLACK 60388 [empty string] [empty string] N BLACK 48 159217 [empty string]
36 BLACK/BLUE 60389 [empty string] [empty string] N BLACK/BLUE 0 159218 [empty string]
37 CORAL 60390 [empty string] [empty string] N CORAL 0 441567 [empty string]
38 EVERGREEN 60391 [empty string] [empty string] N EVERGREEN 1 477166 [empty string]
39 GRAPHITE/BLACK 60392 [empty string] [empty string] N GRAPHITE/BLACK 0 159219 [empty string]
40 GRAY 60393 [empty string] [empty string] N GRAY 59 441573 [empty string]
41 HIBISCUS 60394 [empty string] [empty string] N HIBISCUS 0 477184 [empty string]
42 RUBY 60395 [empty string] [empty string] N RUBY 0 441579 [empty string]
43 SAPPHIRE 60396 [empty string] [empty string] N SAPPHIRE 0 441585 [empty string]
44 SKY 60397 [empty string] [empty string] N SKY 0 159220 [empty string]
45 WHITE 60398 [empty string] [empty string] N WHITE 37 441591 [empty string]
46 WHITE/BLACK 60399 [empty string] [empty string] N WHITE/BLACK 0 159221 [empty string]
47 HEATHER_ROSE 60400 [empty string] [empty string] N HEATHER_ROSE 20 535363 [empty string]
48 SOFT_MOSS 60401 [empty string] [empty string] N SOFT_MOSS 24 535369 [empty string]
49 FENCH_NAVY 60402 [empty string] [empty string] N FENCH_NAVY 60 535375 [empty string]
50 BLUE_MOON 60403 [empty string] [empty string] N BLUE_MOON 14 535426 [empty string]
51 PURPLE_ADDICT 60404 [empty string] [empty string] N PURPLE_ADDICT 24 535432 [empty string]
52 IRON_ORE 60405 [empty string] [empty string] N IRON_ORE 8 535484 [empty string]
53 SUMMER_MARINE 60406 [empty string] [empty string] N SUMMER_MARINE 0 535490 [empty string]
54 MORNING_MIST 60407 [empty string] [empty string] N MORNING_MIST 0 536724 [empty string]
55 RUN_RUDOLPH 60408 [empty string] [empty string] N RUN_RUDOLPH 11 537410 [empty string]
56 BRICKYARD_GRAY 60409 [empty string] [empty string] N BRICKYARD_GRAY 5 545310 [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) 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+