SELECT `pinfo`.`sku`,`pinfo`.`vendor`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('4833')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN MATCH(`desc_short`) AGAINST ('SplintsandSupport' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+SplintsandSupport' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"SplintsandSupport"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"SplintsandSupport"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"SplintsandSupport"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"SplintsandSupport"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+SplintsandSupport' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='SplintsandSupport',`category_4` ='SplintsandSupport') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'SplintsandSupport,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('SplintsandSupport', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Splints And Support

Refine Search

  GO
Color

Black|000000(21)

Blue|0000FF(19)

Beige|F5F5DC(13)

White|FFFFFF(7)

Red|FF0000(7)

Pink|FFC0CB(5)

Yellow|FFFF00(2)

Tan|D2B48C(2)

beige|F5F5DC(1)

black|000000(1)

Navy|000080(1)

pink|FFC0CB(1)

Gray|808080(1)

blue|0000FF(1)

Scarlet|FD0E35(1)

Royal(1)

Green|008000(1)

Orange|FFA500(1)

Purple|800080(1)

Maroon|B03060(1)

Height

2.00(64)

0.13(59)

1.00(38)

0.08(36)

0.50(33)

3.00(22)

0.31(19)

0.25(16)

0.06(15)

5.00(11)

6.81(11)

999.99(11)

2.50(9)

0.16(9)

0.10(8)

7.00(8)

5.50(8)

0.09(6)

0.98(6)

4.75(6)

11.50(6)

7.75(5)

6.75(5)

6.50(5)

3.54(4)

8.00(4)

4.53(4)

4.00(4)

0.39(4)

8.50(4)

4.50(4)

4.72(4)

0.17(3)

3.50(3)

0.66(3)

13.63(3)

6.63(2)

0.38(2)

6.88(2)

2.48(2)

5.51(2)

6.25(2)

3.18(2)

6.00(2)

10.50(2)

2.36(2)

1.18(2)

12.70(1)

0.75(1)

10.75(1)

5.25(1)

4.76(1)

8.13(1)

9.88(1)

6.04(1)

4.54(1)

16.00(1)

7.32(1)

0.79(1)

1.90(1)

2.54(1)

6.10(1)

3.82(1)

Width

17.72(268)

4.00(94)

3.00(80)

8.00(64)

23.62(44)

5.00(36)

6.50(34)

4.50(30)

999.99(22)

5.75(22)

6.00(14)

5.51(12)

1.77(12)

3.50(12)

6.25(10)

4.33(8)

7.09(8)

7.48(8)

13.00(8)

8.50(8)

7.87(8)

9.25(8)

7.68(8)

6.38(8)

6.30(8)

7.00(8)

11.00(6)

3.75(6)

1.00(6)

5.91(4)

5.12(4)

10.63(4)

9.06(4)

6.10(4)

11.42(4)

2.13(4)

10.75(4)

3.63(4)

9.75(4)

2.00(4)

2.63(4)

8.78(4)

5.31(4)

4.25(4)

9.45(4)

11.02(4)

4.53(4)

4.75(4)

3.35(4)

3.18(4)

4.13(4)

3.27(4)

5.50(4)

6.02(4)

2.25(2)

2.56(2)

7.63(2)

12.00(2)

14.00(2)

6.60(2)

21.00(2)

4.54(2)

6.04(2)

7.88(2)

1.90(2)

7.32(2)

5.25(2)

3.82(2)

4.76(2)

2.54(2)

3.88(2)

3.90(2)

Size

18" x 24" x 1/8"(42)

18" x 24" x 1/12"(38)

1/12"(18)

X-Large(16)

Large(16)

Medium(16)

18" x 24" x 1/16"(14)

18" x 24" x 3/32"(14)

XX-Large(14)

1.5" x 10 yd(11)

Universal(9)

2" x 5.5 yds(9)

24" x 36" x 1/8"(8)

24" x 36" x 3/16"(6)

1/8"(6)

1/16"(6)

large 7-9"(6)

small 6-7"(5)

x-small 5-6.5"(5)

medium 6.5-8"(5)

x-large 8.5-10"(4)

medium(4)

2" x 34 yds(4)

small(4)

large(4)

14" x 13"(3)

10.75" x 3"(2)

1.5" x 7.5 yd(2)

10.75" x 4.75"(2)

Small(2)

1" x 5.5 yds(2)

3" x 5.5 yds(2)

18" x 13"(1)

2.75" x 30 yd(1)

3" x 4.5 ft(1)

3" x 2.3 ft(1)

2" x 15 yd(1)

1.5" x 12.5 yd(1)

1.5" x 15 yd(1)

2" x 5 yd(1)

3" x 5 yd(1)

2" x 7.5 yd(1)

3" x 7.5 yd(1)

Length

23.62(134)

8.00(53)

3.00(45)

12.00(24)

35.43(22)

11.50(19)

7.00(15)

11.13(11)

10.00(7)

16.00(7)

12.25(7)

7.87(6)

11.00(6)

18.11(6)

14.00(6)

9.00(5)

13.78(4)

7.09(4)

8.86(4)

12.50(4)

9.50(4)

17.00(4)

11.61(4)

9.45(4)

5.50(3)

3.38(3)

6.00(3)

13.39(2)

17.52(2)

16.34(2)

13.98(2)

11.81(2)

2.25(2)

2.00(2)

12.75(2)

4.75(2)

1.25(2)

2.63(2)

2.13(2)

14.96(2)

2.88(2)

10.63(2)

12.01(2)

8.27(2)

13.00(2)

3.27(2)

14.50(2)

11.22(2)

7.50(2)

10.25(2)

13.75(2)

10.50(2)

4.33(2)

3.35(2)

8.66(2)

6.10(2)

9.25(2)

9.84(2)

14.17(2)

5.71(2)

4.53(2)

5.51(2)

13.58(2)

0.50(1)

8.25(1)

18.00(1)

0.75(1)

29.00(1)

24.00(1)

1.75(1)

1.63(1)

6.50(1)

1.60(1)

12.38(1)

2.56(1)

Weight

1.00(158)

0.50(56)

2.00(54)

4.53(11)

3.00(11)

5.20(9)

1.30(9)

1.26(8)

4.00(8)

5.03(8)

0.20(5)

0.22(5)

0.40(5)

8.38(4)

1.17(4)

0.15(4)

0.86(4)

0.49(4)

1.87(4)

1.01(4)

0.42(3)

0.33(3)

2.36(3)

5.00(3)

0.46(3)

0.11(3)

9.44(3)

0.24(3)

9.35(3)

4.76(3)

1.81(3)

1.12(3)

1.08(3)

6.92(3)

0.30(3)

1.46(3)

2.34(3)

0.31(3)

6.70(2)

1.32(2)

4.78(2)

2.40(2)

9.55(2)

6.00(2)

7.43(2)

19.05(2)

2.38(2)

0.71(2)

0.35(2)

1.74(2)

0.66(2)

1.50(2)

17.46(2)

2.31(2)

6.25(2)

0.93(2)

3.37(2)

1.34(2)

1.39(2)

4.06(2)

4.32(2)

2.09(2)

6.13(2)

4.37(2)

1.68(2)

6.79(2)

0.29(2)

24.52(2)

0.53(2)

1.83(2)

0.73(1)

2.91(1)

1.57(1)

6.17(1)

1.54(1)

6.26(1)

1.19(1)

6.83(1)

2.62(1)

2.63(1)

2.72(1)

2.06(1)

6.85(1)

0.91(1)

0.23(1)

0.01(1)

40.00(1)

0.06(1)

2.08(1)

0.96(1)

17.64(1)

4.41(1)

19.14(1)

9.52(1)

7.34(1)

9.57(1)

0.52(1)

6.74(1)

6.11(1)

9.59(1)

9.26(1)

0.09(1)

0.13(1)

0.04(1)

0.07(1)

0.02(1)

0.44(1)

0.18(1)

0.26(1)

0.99(1)

0.68(1)

0.37(1)

16.76(1)

4.19(1)

5.42(1)

4.70(1)

5.84(1)

52.00(1)

31.00(1)

9.33(1)

7.52(1)

8.73(1)

2.18(1)

22.05(1)

5.51(1)

0.55(1)

0.82(1)

1.21(1)

4.85(1)

3.17(1)

0.79(1)

7.32(1)

5.86(1)

3.42(1)

6.28(1)

1.59(1)

4.92(1)

1.23(1)

8.82(1)

2.20(1)

5.82(1)

5.38(1)

0.51(1)

0.84(1)

0.60(1)

4.67(1)

9.00(1)

9.08(1)

2.27(1)

7.50(1)

13.00(1)

1.52(1)

Capacity

10 oz(3)

4 oz(2)

10 ct(1)

8 oz(1)

Gallon(1)

Body Part

large lymphatic(1)

calf and arch(1)

shoulder, right(1)

medium, lymphatic(1)

small, lymphatic(1)

neck(1)

ankle(1)

shoulder, left(1)

full knee(1)

upper back (postural)(1)

upper knee(1)

hip(1)

lower back(1)

groin(1)

hamstring(1)

elbow(1)

wrist(1)


large(1)

medium(1)

small(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved