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 77948 [empty string] [empty string] N COSMIC_SAPPHIRE 0 477220 [empty string]
2 FIERCE_MAGENTA 77949 [empty string] [empty string] N FIERCE_MAGENTA 0 477226 [empty string]
3 FIJI 77950 [empty string] [empty string] N FIJI 0 477232 [empty string]
4 MAUI_BLUE 77951 [empty string] [empty string] N MAUI_BLUE 0 477244 [empty string]
5 NEBULA_NAVY 77952 [empty string] [empty string] N NEBULA_NAVY 0 477250 [empty string]
6 PULSAR_PURPLE 77953 [empty string] [empty string] N PULSAR_PURPLE 0 477256 [empty string]
7 PURIST_BLUE 77954 [empty string] [empty string] N PURIST_BLUE 0 477262 [empty string]
8 PURPLE_HORIZON 77955 [empty string] [empty string] N PURPLE_HORIZON 0 477268 [empty string]
9 QUSAR_PINK 77956 [empty string] [empty string] N QUSAR_PINK 0 477274 [empty string]
10 BLACK/FIERY 77957 [empty string] [empty string] N BLACK/FIERY 0 159313 [empty string]
11 BLUE_LAGOON/COBALT 77958 [empty string] [empty string] N BLUE_LAGOON/COBALT 0 159314 [empty string]
12 CARBON/RED 77959 [empty string] [empty string] N CARBON/RED 0 159315 [empty string]
13 DPUPW 77960 [empty string] [empty string] N DPUPW 0 159316 [empty string]
14 EPKHW 77961 [empty string] [empty string] N EPKHW 0 159317 [empty string]
15 FIRECRACKER/IRIS 77962 [empty string] [empty string] N FIRECRACKER/IRIS 0 159318 [empty string]
16 GRAPHITE/REFLECTOR 77963 [empty string] [empty string] N GRAPHITE/REFLECTOR 0 159319 [empty string]
17 GRAY/ELECTRIC_GREEN 77964 [empty string] [empty string] N GRAY/ELECTRIC_GREEN 0 159320 [empty string]
18 HBLRF 77965 [empty string] [empty string] N HBLRF 0 159321 [empty string]
19 LAVENDER/MELON 77966 [empty string] [empty string] N LAVENDER/MELON 0 159322 [empty string]
20 OLYMPIAN_BLUE/ORANGE 77967 [empty string] [empty string] N OLYMPIAN_BLUE/ORANGE 0 159323 [empty string]
21 PINK/AQUA 77968 [empty string] [empty string] N PINK/AQUA 0 159324 [empty string]
22 PPBLG 77969 [empty string] [empty string] N PPBLG 0 159325 [empty string]
23 REFLECTOR/AQUA 77970 [empty string] [empty string] N REFLECTOR/AQUA 0 159326 [empty string]
24 WHITE/DEEP_PINK 77971 [empty string] [empty string] N WHITE/DEEP_PINK 0 159327 [empty string]
25 WHITE/REFLECTOR 77972 [empty string] [empty string] N WHITE/REFLECTOR 0 159328 [empty string]
26 BLACK 77973 [empty string] [empty string] N BLACK 46 441597 [empty string]
27 CORAL 77974 [empty string] [empty string] N CORAL 0 441603 [empty string]
28 GRAY 77975 [empty string] [empty string] N GRAY 12 441609 [empty string]
29 HIBISCUS 77976 [empty string] [empty string] N HIBISCUS 0 477238 [empty string]
30 RUBY 77977 [empty string] [empty string] N RUBY 0 441615 [empty string]
31 SAPPHIRE 77978 [empty string] [empty string] N SAPPHIRE 0 441621 [empty string]
32 WHITE 77979 [empty string] [empty string] N WHITE 0 441627 [empty string]
33 WHITE/BLACK 77980 [empty string] [empty string] N WHITE/BLACK 0 159329 [empty string]
34 HEATHER_ROSE 77981 [empty string] [empty string] N HEATHER_ROSE 0 535351 [empty string]
35 FRENCH_NAVY 77982 [empty string] [empty string] N FRENCH_NAVY 0 535357 [empty string]
36 IRONE_ORE 77983 [empty string] [empty string] N IRONE_ORE 0 535496 [empty string]
37 IRON_ORE 77984 [empty string] [empty string] N IRON_ORE 0 535502 [empty string]
38 MORNING_MIST 77985 [empty string] [empty string] N MORNING_MIST 0 536730 [empty string]
39 POLYCHROME_PINK 77986 [empty string] [empty string] N POLYCHROME_PINK 1 546493 [empty string]
40 PURPLE_NITRO 77987 [empty string] [empty string] N PURPLE_NITRO 0 546499 [empty string]
41 NIGHT_VISION 77988 [empty string] [empty string] N NIGHT_VISION 0 546505 [empty string]
42 BLUSH 77989 [empty string] [empty string] N BLUSH 3 562448 [empty string]
43 DEEP_OCEAN 77990 [empty string] [empty string] N DEEP_OCEAN 5 562454 [empty string]
44 AL_AQUA 77991 [empty string] [empty string] N AL_AQUA 0 563063 [empty string]
45 GO_GRAY 77992 [empty string] [empty string] N GO_GRAY 13 582690 [empty string]
46 PULSE_PURPLE 77993 [empty string] [empty string] N PULSE_PURPLE 4 582696 [empty string]
47 BOUNCE_BLACK 77994 [empty string] [empty string] N BOUNCE_BLACK 39 582702 [empty string]
48 BLUE_GLASS 77995 [empty string] [empty string] N BLUE_GLASS 0 585808 [empty string]
49 LIGHTENING 77996 [empty string] [empty string] N LIGHTENING 5 595597 [empty string]
50 BOOST_BLUE 77997 [empty string] [empty string] N BOOST_BLUE 5 595603 [empty string]
51 PROPULSION_PINK 77998 [empty string] [empty string] N PROPULSION_PINK 0 595609 [empty string]
52 LILAC_MUAVE 77999 [empty string] [empty string] N LILAC_MUAVE 35 604987 [empty string]
53 MOSS_GREEN 78000 [empty string] [empty string] N MOSS_GREEN 26 604993 [empty string]
54 SEA_ICE 78001 [empty string] [empty string] N SEA_ICE 7 609173 [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 12922
XS S M L XL XXL
Free shipping on all orders $50+