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 ((`desc_short` like 'binding machines' OR `desc_long` like 'binding machines' OR `desc_title` like 'binding machines' OR `keywords` like 'binding machines' OR `category_1` like 'binding machines' OR `category_2` like 'binding machines' OR `category_3` like 'binding machines' OR `category_4` like 'binding machines' OR `manufacturer_name` like 'binding machines' OR `color` like 'binding machines') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>binding>bindings)+(>machines>machines)' IN BOOLEAN MODE) or (`pinfo`.`sku` like '%binding machines%' OR `pinfo`.`sku` like '%bindingmachines%' OR (FIND_IN_SET('binding machines', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('binding machines', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('binding machines', REPLACE(`keywords`,';', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'binding machines' ELSE `pinfo`.`desc_title` like 'binding machines' END))) 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 ('binding +machines' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+binding +machines' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"binding machines"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"binding machines"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"binding machines"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"binding machines"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+binding +machines' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='machines',`category_4` ='machines') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'machines,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('machines', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Binding Machines

Refine Search

  GO
Category Filter

Binding Systems Covers(44)

Binding Machines(19)

Binding Spines(13)

Sheet Protectors(1)

Brand

GBC(40)

Fellowes(34)

Swingline GBC(2)

PM Company(1)

Color

Black(1)

Recycled

No(1)

Color(s)

Black(17)

White(4)

Gray(3)

Metallic Gray(3)

Blue(1)

Clear(1)

Platinum/Graphite(1)

Charcoal/Silver(1)

Charcoal(1)

Size

11 x 8.5(29)

11.25 x 8.75(14)

11 x 8 1/2(1)

Binding Size Standard

Letter(1)

A4(1)

Maximum Binding Sheet Capacity

225(1)

Maximum Punching Sheet Capacity

12(1)

Product Name

CombBind C12 Binding Machine(1)

Special Features

Square Corners(15)

Round Corners(14)

30-Sheet Capacity-1/8" diameter.(2)

Manual(2)

60-Sheet Capacity-1/4" diameter.(2)

180-Sheet Capacity-3/4" diameter.(1)

120-Sheet Capacity-1/2" diameter.(1)

240-Sheet Capacity-1" diameter.(1)

Leather Look(1)

Clear View(1)

90-Sheet Capacity-3/8" diameter.(1)

Manual +500-Punches up to 25 sheets at a time.(1)

Electric-Effortless operation - just push the button to punch up to 28 sheets at a time.(1)

Electric-Effortless operation - just push the button to punch up to 20 sheets at a time.(1)

Manual-Punches up to 20 sheets at a time.(1)

15-Sheet Capacity-1/16" diameter.(1)

Electric-Effortless operation - just push the button to punch up to 25 sheets at a time.(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved