Feetures Elite Ultra Light No Show Tab

Style: E550

Brand: feetures

$18.00

query
RESULTSET
query
  ATTR1 ATTR1_ENTRY_ID FAM HEX NON_INVT ORIGATTR1 QOH SKU_ID SORT_ORDER
1 COSMIC_SAPPHIRE 81539 [empty string] [empty string] N COSMIC_SAPPHIRE 0 477220 [empty string]
2 FIERCE_MAGENTA 81540 [empty string] [empty string] N FIERCE_MAGENTA 0 477226 [empty string]
3 FIJI 81541 [empty string] [empty string] N FIJI 0 477232 [empty string]
4 MAUI_BLUE 81542 [empty string] [empty string] N MAUI_BLUE 0 477244 [empty string]
5 NEBULA_NAVY 81543 [empty string] [empty string] N NEBULA_NAVY 0 477250 [empty string]
6 PULSAR_PURPLE 81544 [empty string] [empty string] N PULSAR_PURPLE 0 477256 [empty string]
7 PURIST_BLUE 81545 [empty string] [empty string] N PURIST_BLUE 0 477262 [empty string]
8 PURPLE_HORIZON 81546 [empty string] [empty string] N PURPLE_HORIZON 0 477268 [empty string]
9 QUSAR_PINK 81547 [empty string] [empty string] N QUSAR_PINK 0 477274 [empty string]
10 BLACK/FIERY 81548 [empty string] [empty string] N BLACK/FIERY 0 159313 [empty string]
11 BLUE_LAGOON/COBALT 81549 [empty string] [empty string] N BLUE_LAGOON/COBALT 0 159314 [empty string]
12 CARBON/RED 81550 [empty string] [empty string] N CARBON/RED 0 159315 [empty string]
13 DPUPW 81551 [empty string] [empty string] N DPUPW 0 159316 [empty string]
14 EPKHW 81552 [empty string] [empty string] N EPKHW 0 159317 [empty string]
15 FIRECRACKER/IRIS 81553 [empty string] [empty string] N FIRECRACKER/IRIS 0 159318 [empty string]
16 GRAPHITE/REFLECTOR 81554 [empty string] [empty string] N GRAPHITE/REFLECTOR 0 159319 [empty string]
17 GRAY/ELECTRIC_GREEN 81555 [empty string] [empty string] N GRAY/ELECTRIC_GREEN 0 159320 [empty string]
18 HBLRF 81556 [empty string] [empty string] N HBLRF 0 159321 [empty string]
19 LAVENDER/MELON 81557 [empty string] [empty string] N LAVENDER/MELON 0 159322 [empty string]
20 OLYMPIAN_BLUE/ORANGE 81558 [empty string] [empty string] N OLYMPIAN_BLUE/ORANGE 0 159323 [empty string]
21 PINK/AQUA 81559 [empty string] [empty string] N PINK/AQUA 0 159324 [empty string]
22 PPBLG 81560 [empty string] [empty string] N PPBLG 0 159325 [empty string]
23 REFLECTOR/AQUA 81561 [empty string] [empty string] N REFLECTOR/AQUA 0 159326 [empty string]
24 WHITE/DEEP_PINK 81562 [empty string] [empty string] N WHITE/DEEP_PINK 0 159327 [empty string]
25 WHITE/REFLECTOR 81563 [empty string] [empty string] N WHITE/REFLECTOR 0 159328 [empty string]
26 BLACK 81564 [empty string] [empty string] N BLACK 43 441597 [empty string]
27 CORAL 81565 [empty string] [empty string] N CORAL 0 441603 [empty string]
28 GRAY 81566 [empty string] [empty string] N GRAY 33 441609 [empty string]
29 HIBISCUS 81567 [empty string] [empty string] N HIBISCUS 0 477238 [empty string]
30 RUBY 81568 [empty string] [empty string] N RUBY 0 441615 [empty string]
31 SAPPHIRE 81569 [empty string] [empty string] N SAPPHIRE 0 441621 [empty string]
32 WHITE 81570 [empty string] [empty string] N WHITE 0 441627 [empty string]
33 WHITE/BLACK 81571 [empty string] [empty string] N WHITE/BLACK 0 159329 [empty string]
34 HEATHER_ROSE 81572 [empty string] [empty string] N HEATHER_ROSE 0 535351 [empty string]
35 FRENCH_NAVY 81573 [empty string] [empty string] N FRENCH_NAVY 0 535357 [empty string]
36 IRONE_ORE 81574 [empty string] [empty string] N IRONE_ORE 0 535496 [empty string]
37 IRON_ORE 81575 [empty string] [empty string] N IRON_ORE 0 535502 [empty string]
38 MORNING_MIST 81576 [empty string] [empty string] N MORNING_MIST 0 536730 [empty string]
39 POLYCHROME_PINK 81577 [empty string] [empty string] N POLYCHROME_PINK 0 546493 [empty string]
40 PURPLE_NITRO 81578 [empty string] [empty string] N PURPLE_NITRO 0 546499 [empty string]
41 NIGHT_VISION 81579 [empty string] [empty string] N NIGHT_VISION 0 546505 [empty string]
42 BLUSH 81580 [empty string] [empty string] N BLUSH 2 562448 [empty string]
43 DEEP_OCEAN 81581 [empty string] [empty string] N DEEP_OCEAN 5 562454 [empty string]
44 AL_AQUA 81582 [empty string] [empty string] N AL_AQUA 0 563063 [empty string]
45 GO_GRAY 81583 [empty string] [empty string] N GO_GRAY 6 582690 [empty string]
46 PULSE_PURPLE 81584 [empty string] [empty string] N PULSE_PURPLE 1 582696 [empty string]
47 BOUNCE_BLACK 81585 [empty string] [empty string] N BOUNCE_BLACK 24 582702 [empty string]
48 BLUE_GLASS 81586 [empty string] [empty string] N BLUE_GLASS 0 585808 [empty string]
49 LIGHTENING 81587 [empty string] [empty string] N LIGHTENING 1 595597 [empty string]
50 BOOST_BLUE 81588 [empty string] [empty string] N BOOST_BLUE 3 595603 [empty string]
51 PROPULSION_PINK 81589 [empty string] [empty string] N PROPULSION_PINK 0 595609 [empty string]
52 LILAC_MUAVE 81590 [empty string] [empty string] N LILAC_MUAVE 35 604987 [empty string]
53 MOSS_GREEN 81591 [empty string] [empty string] N MOSS_GREEN 26 604993 [empty string]
54 SEA_ICE 81592 [empty string] [empty string] N SEA_ICE 7 609173 [empty string]
55 POP_OFF_PEACH 81593 [empty string] [empty string] N POP_OFF_PEACH 12 622354 [empty string]
56 PUSH_THRU_PINK 81594 [empty string] [empty string] N PUSH_THRU_PINK 24 622360 [empty string]
57 BUST_OUT_BLACK 81595 [empty string] [empty string] N BUST_OUT_BLACK 30 622366 [empty string]
58 ELECTRIC_PEACH 81596 [empty string] [empty string] N ELECTRIC_PEACH 3 623603 [empty string]
59 DARK_CHERRY 81597 [empty string] [empty string] N DARK_CHERRY 6 623609 [empty string]
CACHED false
EXECUTIONTIME 78
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 12922
XS S M L XL XXL
Free shipping on orders of $50+.