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

We're sorry, there were no matches for "Ganging-Bracket" on our site.

Search Tips

Please try searching for different keywords that describe the item you're looking for.

  • Descriptive Keyword(s) - example: "Copy Paper Letter"
  • Product Name (full or partial) - example: "Boise Fireworx Copy Paper"
  • Stock Number (full or partial) - example: "UNV21200"
  • Manufacturer Name or Abbreviation - example: "HP"

Continue Shopping

  • Order by Item Number
  • Browse Our Products

Need Help? Contact us at 800-214-0028 or email Customer Service at [email protected].

 
Medline Mobile Aneroid Sphygmomanometer
Medline 9407

FREE Shipping

Please login to Add Item in Favorites.
HON Brigade 3-Shelf Steel Bookcase
HON 42

Please login to Add Item in Favorites.
Canon GPR-56 Toner Bottle Cartridge
Canon, Inc 0998003

FREE Shipping

Please login to Add Item in Favorites.
RMC Naturelle Tampons
Naturelle 25176488

FREE Shipping

Please login to Add Item in Favorites.
Brother Business Smart Pro MFC-J6530DW Multifunction Printer - Color - Inkjet - Duplex
Brother 6530

Please login to Add Item in Favorites.
Fellowes AeraMax 290/300/DX95 Air Purifiers Carbon Filters
AeraMax 9324201

Please login to Add Item in Favorites.
Brother TN110BK Original Toner Cartridge
Brother 110

Please login to Add Item in Favorites.
Canon GPR-15 Original Toner Cartridge
Canon 15

FREE Shipping

Please login to Add Item in Favorites.
Impact Products Dual Vendor Hygiene Dispenser
Impact 25160100

FREE Shipping

Please login to Add Item in Favorites.
Canon GPR-56 Toner Bottle Cartridge
Canon, Inc 1000003

FREE Shipping

Please login to Add Item in Favorites.
ZOLL Medical AED Plus Defibrillator
ZOLL 800000400001

FREE Shipping

Please login to Add Item in Favorites.
Impact Products Naturelle Maxi Pads
Naturelle 25130973

FREE Shipping

Please login to Add Item in Favorites.
Epson FX-2190II 9-pin Dot Matrix Printer
Epson 1138201

FREE Shipping

Please login to Add Item in Favorites.
QuickFit Landscape Round Ring View Binder for Spreadsheets
QuickFit 95011

FREE Shipping

Please login to Add Item in Favorites.
Medline Elite Auto Digital Blood Pressure Monitor
Medline 3001

FREE Shipping

Please login to Add Item in Favorites.