SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, 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_38` 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 ('460')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=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 `pinfo`.`sku` LIKE '%Balls' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Balls' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Balls' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Balls"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Balls"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Balls"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Balls"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Balls' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Balls',`category_4` ='Balls') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Balls,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Balls', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Balls

Refine Search

  GO
 
Brand

Champion Sports(47)

 
Color(s)

Yellow(9)

Blue; Green; Orange; Purple; Red; Yellow(9)

White(6)

Red(6)

Brown(5)

Orange(3)

Blue(2)

White/Black(2)

Yellow/Green/Blue/Red(1)

Optic Yellow(1)

Green(1)

Purple(1)

 
Diameter

8 1/2"(6)

8.5"(5)

7"(3)

9"(3)

8"(2)

5"(2)

12"(2)

22"(2)

53 cm(2)

5.5"(1)

30"(1)

6"; 8.5"; 10"; 13"(1)

7.25"-7.5"(1)

8.5"- 9"(1)

8"- 8.25"(1)

6 1/2"(1)

7 1/2"(1)

6.5"(1)

6"(1)

65 cm(1)

75 cm(1)

20.75"(1)

42 cm(1)

4"(1)

29.5"(1)

10"(1)

 
Base Color

Gray(1)

 
Manufacturer Part Number

SB1020(1)

SB4(1)

SBSET(1)

SFC(1)

RXD7SET(1)

RS85SET(1)

RD4(1)

RD7(1)

RFB2(1)

RS65SET(1)

SQSBSET(1)

SQVSET(1)

VIPER4(1)

VIPER5(1)

VTB(1)

VTBS(1)

VIPER3(1)

VFC(1)

SRB4(1)

SRB5(1)

UPGSET1(1)

VB2(1)

RBB1(1)

PX85SET(1)

FP53(1)

FP65(1)

FP75(1)

PG10(1)

FFC(1)

CF300(1)

BCHX(1)

BFC(1)

BX7(1)

CF100(1)

PG5RD(1)

PG7RD(1)

PLBB(1)

PLSB(1)

PP42(1)

PP53(1)

PGSET(1)

PG85YL(1)

PG85(1)

PG85BL(1)

PG85GN(1)

PG85PR(1)

BB3(1)

 
Country of Origin

CN(24)

TW(10)

TH(5)

IT(5)

SE(3)

 
Material(s)

Two-Ply Nylon-Wound(10)

Coated Foam(8)

Italian Resin(5)

Rubber Cover(5)

Polyurethane/Synthetic Rubber(3)

Plastic(3)

Composite Synthetic Leather/Rubber(3)

Foam(2)

Rubber(2)

Pro Laminated Rubber(1)

Cordley Composite(1)

Foam; Rhino Skin(1)

Rhino Skin Polymer(1)

Rhino Skin(1)

 
Seat Material

PVC(1)

 
Seat Color

Gray(1)

 
Base Material

PVC(1)

 
Caster/Glide/Wheel

Four 2" Swivel Casters(1)

 
Weight Capacity (text)

Supports up to 200 lbs.(1)

 
Seat Height Maximum

62 cm(1)

 
Overall Height Maximum

74 cm(1)

 
Recommended Applications

General Office & Task; Breakroom & Hospitality; Education; Healthcare(1)

 
Back Width Maximum

50 cm(1)

 
Back Height Maximum

74 cm(1)

 
Seat Glide Mechanism

No(1)

 
Integral Lumbar Support

No(1)

 
Seat Diameter

50 cm(1)

 
Asynchronous Control

No(1)

 
Variable Synchro-Tilt

No(1)

 
Posture Lock

No(1)

 
Regulation Size

Playground(4)

Official(3)

No. 5(2)

Official Size(2)

No. 4(2)

No. 7(2)

No. 3(1)

Junior Size(1)

#3(1)

Intermediate(1)

 
Synchronized Knee Tilt

No(1)

 
Back Material

PVC(1)

 
Back Color

Gray(1)

 
Arms Included

No(1)

 
Pneumatic Seat Height Adjustment

No(1)

 
Tilt Tension/Tilt Lock

No(1)

 
Back Height Adjustment

No(1)

 
Dual-Action Tilt

No(1)

 
Knee Tilt

No(1)

 
Dual-Clutch Posture Control

No(1)

 
Multi-Task Control

No(1)

 
 
 

© 2019-2020 NBJ Form & Function Inc. , All Rights Reserved