Feetures Elite Ultra Light No Show Tab

Style: E550

Brand: feetures

$15.99

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SKU_ID SORT_ORDER
1 COSMIC_SAPPHIRE 58600 [empty string] [empty string] COSMIC_SAPPHIRE 2 477220 [empty string]
2 FIERCE_MAGENTA 58601 [empty string] [empty string] FIERCE_MAGENTA 10 477226 [empty string]
3 FIJI 58602 [empty string] [empty string] FIJI 0 477232 [empty string]
4 MAUI_BLUE 58603 [empty string] [empty string] MAUI_BLUE 0 477244 [empty string]
5 NEBULA_NAVY 58604 [empty string] [empty string] NEBULA_NAVY 0 477250 [empty string]
6 PULSAR_PURPLE 58605 [empty string] [empty string] PULSAR_PURPLE 0 477256 [empty string]
7 PURIST_BLUE 58606 [empty string] [empty string] PURIST_BLUE 5 477262 [empty string]
8 PURPLE_HORIZON 58607 [empty string] [empty string] PURPLE_HORIZON 0 477268 [empty string]
9 QUSAR_PINK 58608 [empty string] [empty string] QUSAR_PINK 0 477274 [empty string]
10 BLACK/FIERY 58609 [empty string] [empty string] BLACK/FIERY 0 159313 [empty string]
11 BLUE_LAGOON/COBALT 58610 [empty string] [empty string] BLUE_LAGOON/COBALT 0 159314 [empty string]
12 CARBON/RED 58611 [empty string] [empty string] CARBON/RED 0 159315 [empty string]
13 DPUPW 58612 [empty string] [empty string] DPUPW 0 159316 [empty string]
14 EPKHW 58613 [empty string] [empty string] EPKHW 0 159317 [empty string]
15 FIRECRACKER/IRIS 58614 [empty string] [empty string] FIRECRACKER/IRIS 0 159318 [empty string]
16 GRAPHITE/REFLECTOR 58615 [empty string] [empty string] GRAPHITE/REFLECTOR 0 159319 [empty string]
17 GRAY/ELECTRIC_GREEN 58616 [empty string] [empty string] GRAY/ELECTRIC_GREEN 0 159320 [empty string]
18 HBLRF 58617 [empty string] [empty string] HBLRF 0 159321 [empty string]
19 LAVENDER/MELON 58618 [empty string] [empty string] LAVENDER/MELON 0 159322 [empty string]
20 OLYMPIAN_BLUE/ORANGE 58619 [empty string] [empty string] OLYMPIAN_BLUE/ORANGE 0 159323 [empty string]
21 PINK/AQUA 58620 [empty string] [empty string] PINK/AQUA 0 159324 [empty string]
22 PPBLG 58621 [empty string] [empty string] PPBLG 0 159325 [empty string]
23 REFLECTOR/AQUA 58622 [empty string] [empty string] REFLECTOR/AQUA 0 159326 [empty string]
24 WHITE/DEEP_PINK 58623 [empty string] [empty string] WHITE/DEEP_PINK 0 159327 [empty string]
25 WHITE/REFLECTOR 58624 [empty string] [empty string] WHITE/REFLECTOR 0 159328 [empty string]
26 BLACK 58625 [empty string] [empty string] BLACK 1 441597 [empty string]
27 CORAL 58626 [empty string] [empty string] CORAL 0 441603 [empty string]
28 GRAY 58627 [empty string] [empty string] GRAY 32 441609 [empty string]
29 HIBISCUS 58628 [empty string] [empty string] HIBISCUS 0 477238 [empty string]
30 RUBY 58629 [empty string] [empty string] RUBY 0 441615 [empty string]
31 SAPPHIRE 58630 [empty string] [empty string] SAPPHIRE 0 441621 [empty string]
32 WHITE 58631 [empty string] [empty string] WHITE 1 441627 [empty string]
33 WHITE/BLACK 58632 [empty string] [empty string] WHITE/BLACK 0 159329 [empty string]
34 HEATHER_ROSE 58633 [empty string] [empty string] HEATHER_ROSE 24 535351 [empty string]
35 FRENCH_NAVY 58634 [empty string] [empty string] FRENCH_NAVY 26 535357 [empty string]
36 IRONE_ORE 58635 [empty string] [empty string] IRONE_ORE 0 535496 [empty string]
37 IRON_ORE 58636 [empty string] [empty string] IRON_ORE 11 535502 [empty string]
38 MORNING_MIST 58637 [empty string] [empty string] MORNING_MIST 0 536730 [empty string]
CACHED false
EXECUTIONTIME 0
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 12922
XS S M L XL XXL
Free shipping on orders $50+