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

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

 
Enforcer Flying Insect Killer
Enforcer 16

Please login to Add Item in Favorites.
Raid Wasp/Hornet Killer Spray
Raid 668006

Please login to Add Item in Favorites.
HON Brigade 5-Shelf Steel Bookcase
HON 72

Please login to Add Item in Favorites.
HON Brigade 6-Shelf Steel Bookcase
HON 82

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

Please login to Add Item in Favorites.
Xerox Waste Cartridge
Xerox 10801504

FREE Shipping

Please login to Add Item in Favorites.
Impact Products Dual Vendor Hygiene Dispenser Convenience Pak
Impact 25160273

FREE Shipping

Please login to Add Item in Favorites.
HON Circulate Tailored Loveseat
HON 87211

Please login to Add Item in Favorites.
Raid Flying Insect Spray
Raid 300816

Please login to Add Item in Favorites.
Xerox 008R13061 Waste Toner Bottle
Xerox 00813061

FREE Shipping

Please login to Add Item in Favorites.
ZOLL Medical AED Plus Defibrillator Pediatric Electrodes
ZOLL 8900081001

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.
Canon E40 Original Toner Cartridge
Canon 40

FREE Shipping

Please login to Add Item in Favorites.
Raid Ant/Roach Killer Spray
Raid 669798

Please login to Add Item in Favorites.
Dymo LabelMaker AC Adapter
DYMO 40077

Please login to Add Item in Favorites.