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

Currently Filtered by

Category

Balls

Refine Search

  GO
Brand

Champion Sports(45)

Color(s)

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

Brown(8)

White(7)

Red(6)

Yellow(4)

Orange(4)

White/Black(2)

Yellow/Green/Blue/Red(1)

Optic Yellow(1)

Diameter

8 1/2"(6)

6"(4)

7"(3)

8"(2)

22"(2)

9"(2)

5"(2)

10"(2)

27 3/4"(1)

29"(1)

8 1/2"- 9"(1)

5 1/2"(1)

6"; 8 1/2"; 10"; 13"(1)

30"(1)

8"- 8 1/4"(1)

7 1/4"-7 1/2"(1)

29 1/2"(1)

12"(1)

20 3/4"(1)

42 cm(1)

53 cm(1)

4"(1)

28 1/2"(1)

6 1/2"(1)

Base Color

Gray(1)

Manufacturer Part Number

VTB(1)

VTBS(1)

VR4(1)

VIPER5(1)

VIPER3(1)

VIPER4(1)

EDU705191(1)

HUB1444(1)

MASCFBF(1)

MASCFBS(1)

MASB85O(1)

MASB7(1)

MASB10O(1)

VB2(1)

UPGSET1(1)

RXD8SET(1)

SB1020(1)

RXD7SET(1)

RXD6SET(1)

RFB2(1)

RFB3(1)

SB1030(1)

SB1040(1)

SRB4(1)

SRB5(1)

SQVSET(1)

SFC(1)

SBSET(1)

MASF101BR(1)

MASF301BR(1)

MASSR5W(1)

MAST810(1)

MASSR4W(1)

MASPG812Y(1)

MASPG812P(1)

MASPG812R(1)

SLT500(1)

SLT525(1)

SWT01001(1)

SWT01014(1)

SLT875(1)

SLT750(1)

SLT526(1)

MASPG812O(1)

MASPG812G(1)

MASGYM24(1)

MASGYM34(1)

MASFBY85(1)

MASFBY7(1)

MASFBY4(1)

MASGYM40(1)

MASHP4(1)

MASPG6R(1)

MASPG812B(1)

MASPG16R(1)

MASPG13R(1)

MASPG10R(1)

RD7(1)

RD4(1)

CHSRBB1(1)

CHSRBB2(1)

CHSPG85YL(1)

CHSPG85RD(1)

CHSPG85OR(1)

CHSPG85PR(1)

CHSRBB5(1)

CHSRD4(1)

CHSRFB3(1)

CHSRXD6SET(1)

CHSRFB1(1)

CHSRD85(1)

CHSRD7(1)

CHSPG85GN(1)

CHSPG85BL(1)

CHSFP53(1)

CHSFP65(1)

CHSFP42(1)

CHSFFC(1)

CHSDTBSET(1)

CHSHD4(1)

CHSHD85(1)

CHSPG6RD(1)

CHSPG7RD(1)

CHSPG16RD(1)

CHSPG13RD(1)

CHSPG10RD(1)

CHSSFC(1)

CHSSRB3(1)

PGSET(1)

PLBB(1)

PG85(1)

PG7RD(1)

PG5RD(1)

PG6RD(1)

PLSB(1)

PP42(1)

RBB1(1)

RBB4(1)

PX85SET(1)

PX10SET(1)

PP53(1)

PG10(1)

FP75(1)

CHSVR4(1)

CHSVTB(1)

CHSVFC(1)

CHSSRB5(1)

CHSSRB4(1)

BCHX(1)

BFC(1)

FFC(1)

FP53(1)

CF300(1)

CF100(1)

BX7(1)

CHSBFC(1)

Country of Origin

CN(17)

ID(8)

TW(7)

TH(5)

IT(4)

SE(3)

US(1)

Material(s)

Rubber Cover(8)

Two-Ply Nylon-Wound(7)

Composite Synthetic Leather/Rubber(5)

Rubber(3)

Coated Foam(3)

Plastic(3)

Polyurethane/Synthetic Rubber(3)

Foam; Rhino Skin(2)

Foam(2)

Italian Resin(2)

Pro Laminated Rubber(1)

Cordley Composite(1)

Rhino Skin(1)

Rhino Skin Polymer(1)

Seat Material

Italian Resin(2)

PVC(1)

Base Material

PVC(1)

Caster/Glide/Wheel

Four 2" swivel casters.(1)

Weight Capacity (text)

Supports up to 200 lbs.(3)

Seat Height Maximum

75 cm(1)

53 cm(1)

62 cm(1)

Seat/Back Color

Yellow(1)

Blue(1)

Gray(1)

Overall Height Maximum

75 cm(1)

53 cm(1)

74 cm(1)

Recommended Applications

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

Back Width Maximum

50 cm(1)

Back Height Maximum

74 cm(1)

Seat Diameter

75 cm(1)

53 cm(1)

50 cm(1)

Regulation Size

Playground(4)

No. 5(2)

No. 4(2)

No. 7(2)

Official(2)

Official Size(2)

Official Junior Size(1)

Official Intermediate(1)

No. 3(1)

Intermediate(1)

Junior Size(1)

No. 6(1)

#3(1)

Junior(1)

Back Material

PVC(1)

Arms Included

No(3)

Price Range

$0-$99.99(111)

$100-$199.99(5)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2017-2018 Office Solutions & Innovations, Inc., All Rights Reserved