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

We're sorry, there were no matches for "Drive-Cleaners" 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].

 
Epson FX-2190II 9-pin Dot Matrix Printer
Epson 1138201

FREE Shipping

Please login to Add Item in Favorites.
Monarch Plastic Label Scraper
Monarch 925130

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

Please login to Add Item in Favorites.
Elite Image Remanufactured Toner Cartridge - Alternative for Canon (E40)
Elite Image 75052

Please login to Add Item in Favorites.
Learning Resources Storage Pocket Organization Station
Learning Resources 2255

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.
Fellowes AeraMax 290/300/DX95 Air Purifiers True HEPA Filter
AeraMax 9287201

FREE Shipping

Please login to Add Item in Favorites.
HON Instigate Mesh Back Stacking Chair
HON 50810

FREE Shipping

Please login to Add Item in Favorites.
Flipside Deluxe Chart Stand/DryErase Tablet Set
Flipside Products 30503

FREE Shipping

Please login to Add Item in Favorites.
Brother Genuine Innobella LC105M Super High Yield Magenta Ink Cartridge
Brother 105

FREE Shipping

Please login to Add Item in Favorites.
Jonti-Craft SideKick Mobile Storage Seat
Jonti-Craft 3769

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.
Genuine Joe Air Freshener Dispenser System
Genuine Joe 99659

Please login to Add Item in Favorites.
Medline Wall-mount Aneroid Sphygmomanometer
Medline 9400

FREE Shipping

Please login to Add Item in Favorites.
Pacon Dry Erase Activity Pocket Chart
Pacon 20410

FREE Shipping

Please login to Add Item in Favorites.