Feetures Elite Light Cushion Tab

Style: E500

Brand: feetures

$15.99

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SKU_ID SORT_ORDER
1 FREEDOM_BLUE 58768 [empty string] [empty string] FREEDOM_BLUE 14 524930 [empty string]
2 ARUBA_BLUE/CORAL 58769 [empty string] [empty string] ARUBA_BLUE/CORAL 0 159194 [empty string]
3 ASTEROID_GREY 58770 [empty string] [empty string] ASTEROID_GREY 0 477148 [empty string]
4 ATLANTIS/LAVA 58771 [empty string] [empty string] ATLANTIS/LAVA 0 159195 [empty string]
5 AURORA_BLUE 58772 [empty string] [empty string] AURORA_BLUE 0 477154 [empty string]
6 BBLRF 58773 [empty string] [empty string] BBLRF 0 159196 [empty string]
7 BLACK/PACIFIC_BLUE 58774 [empty string] [empty string] BLACK/PACIFIC_BLUE 0 159197 [empty string]
8 BLACK/REFLECTOR 58775 [empty string] [empty string] BLACK/REFLECTOR 0 159198 [empty string]
9 CAMELLIA/VIOLET 58776 [empty string] [empty string] CAMELLIA/VIOLET 0 159199 [empty string]
10 CAPRI/PINK_POP 58777 [empty string] [empty string] CAPRI/PINK_POP 0 159200 [empty string]
11 COBALT/LAVA 58778 [empty string] [empty string] COBALT/LAVA 0 159201 [empty string]
12 CORAL/DEEP_PINK 58779 [empty string] [empty string] CORAL/DEEP_PINK 0 159202 [empty string]
13 COSMIC_SAPPHIRE 58780 [empty string] [empty string] COSMIC_SAPPHIRE 14 477160 [empty string]
14 DEEP_PINK/ARUBA_BLUE 58781 [empty string] [empty string] DEEP_PINK/ARUBA_BLUE 0 159203 [empty string]
15 FIERCE_MAGENTA 58782 [empty string] [empty string] FIERCE_MAGENTA 16 477172 [empty string]
16 FIERY 58783 [empty string] [empty string] FIERY 0 159204 [empty string]
17 FIJI 58784 [empty string] [empty string] FIJI 0 477178 [empty string]
18 FUSCHIA_POP 58785 [empty string] [empty string] FUSCHIA_POP 0 159205 [empty string]
19 FUSCHIA_REFLECTOR 58786 [empty string] [empty string] FUSCHIA_REFLECTOR 0 159206 [empty string]
20 NAVY/REFLECTOR 58787 [empty string] [empty string] NAVY/REFLECTOR 0 159207 [empty string]
21 NEBULA_NAVY 58788 [empty string] [empty string] NEBULA_NAVY 0 477190 [empty string]
22 ORCHID/BLUE_LAGOON 58789 [empty string] [empty string] ORCHID/BLUE_LAGOON 0 159208 [empty string]
23 PBLRF 58790 [empty string] [empty string] PBLRF 0 159209 [empty string]
24 POWER_PURPLE 58791 [empty string] [empty string] POWER_PURPLE 0 159210 [empty string]
25 PULSAR_PURPLE 58792 [empty string] [empty string] PULSAR_PURPLE 0 477196 [empty string]
26 PURIST_BLUE 58793 [empty string] [empty string] PURIST_BLUE 9 477202 [empty string]
27 PURPLE_HORIZON 58794 [empty string] [empty string] PURPLE_HORIZON 0 477208 [empty string]
28 QUSAR_PINK 58795 [empty string] [empty string] QUSAR_PINK 0 477214 [empty string]
29 SUNRISE_PINK_POP 58796 [empty string] [empty string] SUNRISE_PINK_POP 0 159211 [empty string]
30 SUNRISE_PLUM 58797 [empty string] [empty string] SUNRISE_PLUM 0 159212 [empty string]
31 SUNRISE_REFLECTOR 58798 [empty string] [empty string] SUNRISE_REFLECTOR 0 159213 [empty string]
32 ULTRAVIOLET/CORAL 58799 [empty string] [empty string] ULTRAVIOLET/CORAL 0 159214 [empty string]
33 VIOLA/LAVA 58800 [empty string] [empty string] VIOLA/LAVA 0 159215 [empty string]
34 VOLT/CARBON 58801 [empty string] [empty string] VOLT/CARBON 0 159216 [empty string]
35 BLACK 58802 [empty string] [empty string] BLACK 66 159217 [empty string]
36 BLACK/BLUE 58803 [empty string] [empty string] BLACK/BLUE 0 159218 [empty string]
37 CORAL 58804 [empty string] [empty string] CORAL 0 441567 [empty string]
38 EVERGREEN 58805 [empty string] [empty string] EVERGREEN 1 477166 [empty string]
39 GRAPHITE/BLACK 58806 [empty string] [empty string] GRAPHITE/BLACK 0 159219 [empty string]
40 GRAY 58807 [empty string] [empty string] GRAY 56 441573 [empty string]
41 HIBISCUS 58808 [empty string] [empty string] HIBISCUS 0 477184 [empty string]
42 RUBY 58809 [empty string] [empty string] RUBY 0 441579 [empty string]
43 SAPPHIRE 58810 [empty string] [empty string] SAPPHIRE 0 441585 [empty string]
44 SKY 58811 [empty string] [empty string] SKY 0 159220 [empty string]
45 WHITE 58812 [empty string] [empty string] WHITE 39 441591 [empty string]
46 WHITE/BLACK 58813 [empty string] [empty string] WHITE/BLACK 0 159221 [empty string]
47 HEATHER_ROSE 58814 [empty string] [empty string] HEATHER_ROSE 30 535363 [empty string]
48 SOFT_MOSS 58815 [empty string] [empty string] SOFT_MOSS 24 535369 [empty string]
49 FENCH_NAVY 58816 [empty string] [empty string] FENCH_NAVY 48 535375 [empty string]
50 BLUE_MOON 58817 [empty string] [empty string] BLUE_MOON 0 535426 [empty string]
51 PURPLE_ADDICT 58818 [empty string] [empty string] PURPLE_ADDICT 0 535432 [empty string]
52 IRON_ORE 58819 [empty string] [empty string] IRON_ORE 24 535484 [empty string]
53 SUMMER_MARINE 58820 [empty string] [empty string] SUMMER_MARINE 3 535490 [empty string]
54 MORNING_MIST 58821 [empty string] [empty string] MORNING_MIST 0 536724 [empty string]
55 RUN_RUDOLPH 58822 [empty string] [empty string] RUN_RUDOLPH 0 537410 [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 12920
XS S M L XL XXL
Free shipping on orders $50+