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 ('3392')) 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 ('TherapyAndExercise' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+TherapyAndExercise' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"TherapyAndExercise"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"TherapyAndExercise"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"TherapyAndExercise"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"TherapyAndExercise"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+TherapyAndExercise' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='TherapyAndExercise',`category_4` ='TherapyAndExercise') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'TherapyAndExercise,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('TherapyAndExercise', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Therapy And Exercise

Refine Search

  GO
Brand

BODY SOLID(4)

Color

Red|FF0000(23)

Blue|0000FF(22)

Black|000000(21)

yellow, red, green, blue, black|FFFF00(21)

Green|008000(19)

Yellow|FFFF00(19)

blue|0000FF(12)

Tan|D2B48C(11)

yellow|FFFF00(10)

red|FF0000(7)

white|FFFFFF(6)

tan, yellow, red, green, blue, black, silver, gold|D2B48C(6)

black|000000(5)

pink|FFC0CB(5)

lime|BFFF00(5)

tan tricot|D2B48C(5)

silver|C0C0C0(5)

forest green|228B22(5)

tan, yellow, red, green, blue, black|D2B48C(4)

Silver|C0C0C0(3)

tan-black|D2B48C(3)

green|008000(3)

Gold|A57C00(3)

Orange|FFA500(2)

Purple|800080(2)

Yellow/Green|9ACD32(1)

Purple, Red, Orange|800080(1)

Red/Blue|FF0000(1)

red, green, blue, black|FF0000(1)

Beige|F5F5DC(1)

Height

1.00(177)

0.25(69)

2.00(64)

0.20(61)

3.00(57)

0.50(38)

9.00(30)

10.00(29)

3.50(28)

7.00(27)

0.40(24)

4.00(23)

6.00(21)

5.00(20)

2.25(16)

0.75(16)

8.00(14)

14.00(12)

2.75(11)

3.20(11)

15.00(10)

1.50(9)

36.00(8)

2.50(7)

15.50(7)

1.75(6)

12.00(6)

16.00(6)

58.00(6)

33.86(5)

29.53(4)

35.00(4)

34.65(4)

19.69(4)

57.00(4)

15.25(4)

32.00(4)

22.00(3)

67.00(3)

20.00(3)

21.00(3)

21.65(3)

7.50(3)

24.00(2)

2.80(2)

5.50(2)

51.00(2)

39.00(2)

13.75(2)

18.50(2)

17.50(2)

11.00(2)

5.75(2)

3.25(2)

5.60(2)

52.00(2)

1.25(1)

4.60(1)

0.63(1)

0.88(1)

27.75(1)

9.50(1)

14.25(1)

1.60(1)

28.40(1)

5.25(1)

3.75(1)

53.00(1)

55.00(1)

19.00(1)

22.80(1)

8.50(1)

10.50(1)

23.60(1)

70.00(1)

26.00(1)

38.00(1)

48.00(1)

0.10(1)

41.00(1)

68.00(1)

56.00(1)

50.00(1)

4.50(1)

Width

3.00(166)

2.00(152)

5.00(148)

6.00(104)

14.00(102)

10.00(98)

12.00(82)

3.50(82)

7.00(78)

8.00(76)

4.00(62)

11.00(58)

13.00(40)

5.50(32)

18.00(32)

24.00(28)

15.00(24)

22.00(24)

3.20(24)

4.50(22)

9.00(22)

7.50(22)

21.00(20)

1.00(20)

31.50(18)

0.75(16)

20.75(14)

23.00(14)

17.32(14)

2.50(12)

0.40(12)

17.00(12)

30.00(12)

1.50(10)

19.69(10)

27.00(10)

16.00(10)

8.50(10)

28.00(10)

21.65(8)

20.00(8)

14.75(8)

10.63(8)

35.00(8)

26.50(8)

25.00(6)

17.50(6)

48.00(6)

36.00(6)

12.50(6)

3.75(6)

9.50(6)

60.00(4)

2.60(4)

10.75(4)

13.25(4)

78.00(4)

1.20(4)

6.75(4)

32.00(4)

0.88(2)

2.75(2)

0.63(2)

1.25(2)

22.60(2)

18.50(2)

26.75(2)

40.90(2)

38.00(2)

1.38(2)

26.00(2)

1.75(2)

2.40(2)

Size

14"(16)

2"(16)

7"(14)

24"(7)

36"(7)

Large(7)

Medium(7)

Small(7)

2 x 3.5"(5)

20" x 24"(4)

84" x 35" x 57"(4)

11" x 14"(3)

6" x 23"(3)

10" x 12"(3)

15" x 24"(3)

cervical 23" x 8"(2)

x-large 11" x 21"(2)

3"x5"(2)

half size 7.5" x 11"(2)

1.5 x 2.5"(2)

5" x 12"(2)

6.5" x 12.5"(2)

5" x 15"(2)

3.5" x 5.5"(2)

standard - 11" x 14"(2)

10" x 11"(2)

11" x 17"(2)

medium(2)

78" x 32" x 56"(2)

5" x 24"(2)

small - 4" x 6"(2)

78" x 28" x 67"(2)

57" x 30" x 51"(2)

half size - 5" x 10"(2)

10" x 18"(2)

2.0"(2)

back - 8" x 11"(2)

10" x 20"(2)

10" x 24"(2)

x-large 12" x 15"(2)

1.75" x 3.75"(2)

3" x 11"(2)

5.5" x 7.5"(2)

3" x 8"(2)

11" x 21"(2)

3"(2)

Small - 12" x 15"(2)

12" x 5"(2)

Large - 12" x 24"(2)

1 Size(2)

6" x 36"(2)

10" x 13.5"(2)

7" x 11"(2)

5" x 10"(2)

6" x 21"(2)

8" x 14"(2)

6.5" x 11"(2)

5" x 6"(2)

12.5" x 18.5"(2)

9" x 18" with 3" x 27"(1)

10" x 3.5" with 3" x 27" and 3" x 14"(1)

12" x 16" with 3" x 27"(1)

small(1)

6" x 12" with 3" x 27"(1)

7" x 24"(1)

5.5" x 12" with 3" x 27"(1)

14" x 18" with 3" x 27"(1)

finger(1)

large(1)

10" x 13"(1)

9" x 24"(1)

3x5x9 inch(1)

21" x 10"(1)

2" x 5.5 yds(1)

2"x5"(1)

regular (14 to 16" neck)(1)

large (17 to 18" neck)(1)

18"(1)

wide (19 to 21" neck)(1)

2.75"(1)

1.375"(1)

5x13x9 inch(1)

7x7x30 inch(1)

9" x 12" with 3" x 27"(1)

6x6x24 inch(1)

6x13x24 inch(1)

2"x4"(1)

8x13x16 inch(1)

x-large(1)

42" x 21" x 53"(1)

1.25"(1)

2" x 4"(1)

1.5" x 2.5"(1)

2.5" x 24"(1)

medium (14"x14")(1)

small (7"x15")(1)

5 cm(1)

10 cm(1)

2.25 x 2.5"(1)

6" x 60"(1)

6" x 48"(1)

2.5" x 36"(1)

2.5" x 18"(1)

large (14"x27")(1)

2.5" x 48"(1)

4" x 18"(1)

4" x 60"(1)

4" x 48"(1)

4" x 36"(1)

2 cm(1)

14" x 14"(1)

Medium - 18" X 14"(1)

26" X 14"(1)

4" x 6"(1)

6" x 9"(1)

Mini - 19" X 7"(1)

26" x 14"(1)

16" x 12"(1)

Mini - 19" x 7"(1)

Medium - 18" x 14"(1)

94" x 18" x 38"(1)

42" x 21" x 41"(1)

x-light(1)

16.25" x 15"(1)

14" x 18"(1)

light(1)

heavy(1)

23"x20"(1)

70" x 22" x 68"(1)

84" x 32" x 70"(1)

6" x 24" with 3" x 27" belt and 2" x 8"(1)

Shape

Rectangle(5)

round(4)

Oval(4)

Square(4)

Round(3)

square(3)

rectangle(1)

Length

12.00(72)

2.00(57)

3.00(54)

7.00(53)

10.00(50)

6.00(37)

8.00(37)

14.00(34)

13.00(31)

5.00(29)

15.00(28)

4.00(24)

5.50(23)

11.00(22)

18.00(21)

3.50(20)

24.00(19)

7.50(19)

5.25(17)

22.00(15)

1.00(14)

2.50(12)

3.20(12)

9.00(11)

0.75(11)

34.00(11)

8.50(9)

16.00(9)

11.50(9)

4.50(9)

33.00(8)

19.02(7)

20.00(7)

7.25(7)

36.00(6)

23.00(5)

22.64(5)

84.00(5)

6.50(5)

78.00(4)

26.00(4)

32.09(4)

33.50(4)

13.98(4)

19.00(4)

15.25(4)

1.50(4)

42.00(4)

57.00(3)

3.70(3)

38.00(3)

28.00(3)

15.50(2)

12.90(2)

1.75(2)

8.88(2)

4.70(2)

25.00(2)

77.00(2)

14.50(2)

17.00(2)

48.00(2)

21.00(2)

2.75(1)

8.25(1)

4.25(1)

0.88(1)

9.25(1)

44.00(1)

1.38(1)

30.00(1)

0.63(1)

7.20(1)

10.50(1)

17.50(1)

1.25(1)

2.25(1)

4.75(1)

16.50(1)

13.75(1)

51.25(1)

34.40(1)

30.70(1)

54.00(1)

31.00(1)

43.00(1)

70.00(1)

94.00(1)

58.00(1)

61.00(1)

16.25(1)

63.00(1)

60.00(1)

68.00(1)

Scent

Wintergreen(5)

Rose blossom(5)

Fragrance-Free(5)

Peach(5)

Citrus(5)

Lavender(5)

Weight

1.00(174)

2.00(146)

0.50(90)

0.30(69)

3.00(63)

4.00(56)

5.00(31)

10.00(28)

0.20(24)

4.70(20)

16.00(18)

8.00(15)

38.00(13)

15.00(12)

6.50(12)

6.00(11)

7.00(11)

30.00(10)

42.00(10)

24.00(9)

23.00(9)

0.70(8)

22.00(8)

0.10(8)

20.00(7)

11.00(6)

0.40(6)

12.00(5)

14.00(5)

19.00(5)

18.00(4)

80.00(4)

25.00(4)

27.00(4)

93.00(4)

160.00(3)

35.00(3)

13.00(3)

275.00(2)

31.00(2)

50.00(2)

280.00(2)

40.00(2)

37.00(2)

48.00(2)

150.00(2)

54.00(2)

26.00(2)

70.00(2)

230.00(2)

39.00(2)

1.87(2)

2.50(1)

186.00(1)

113.00(1)

140.00(1)

159.00(1)

3.50(1)

0.02(1)

5.95(1)

69.00(1)

1.20(1)

100.00(1)

106.00(1)

9.00(1)

32.00(1)

55.00(1)

60.00(1)

41.00(1)

190.00(1)

49.00(1)

28.00(1)

36.00(1)

0.60(1)

43.00(1)

107.00(1)

17.00(1)

21.00(1)

87.00(1)

47.00(1)

1.50(1)

11.50(1)

240.00(1)

269.00(1)

145.00(1)

185.00(1)

146.00(1)

353.00(1)

446.00(1)

206.00(1)

293.00(1)

305.00(1)

437.00(1)

400.00(1)

Capacity

12-Pack(5)

24-Pack(4)

8-Pack(4)

4-Pack(4)

6-Pack(3)

6 lb(2)

9.5 oz(1)

35 oz(1)

11 lb(1)

4 oz(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved