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

Currently Filtered by

Category

Exam Tables

Refine Search

  GO
 
Brand

Hausmann(7)

Lorell(3)

 
Color

Black(1)

Slate Blue(1)

Silver(1)

 
Packaged Quantity

1 Each(10)

 
Assembly Required

No(6)

Yes(4)

 
Limited Warranty

3 Year(7)

5 Year(3)

 
Weight (Approximate)

7 lb(1)

5 lb(1)

 
Compatibility

Hausmann Maximum Value Exam Table

(3)

 
Dimensions

45" Height(1)

31" Height(1)

33" Height x 19.50" Width x 17" Depth(1)

33" Height(1)

35.50" Diameter(1)

 
Number of Casters

4(1)

 
Number of Legs

4(1)

 
Table Top Shape

Round(2)

Rectangle(1)

 
Edge Style

Banded(3)

 
Table Top Width

30"(2)

72"(1)

26"(1)

 
Base Included

Yes(4)

No(2)

 
Table Top Thickness

1"(2)

2"(1)

 
Base Style

Four Leg(1)

Round(1)

 
Table Top Length

15"(1)

27"(1)

33"(1)

 
Table Top Diameter

35.50"(2)

 
Manufacturer Part Number

15(1)

3400(1)

4002027BE(1)

4416SP(1)

4423SP(1)

91(1)

97(1)

59657(1)

59658(1)

59659(1)

 
Country of Origin

United States(6)

China(4)

 
Material

Steel(2)

 
Height

10"(1)

 
Width

18"(1)

 
Color/Finish

Laminated(2)

Slate Blue(2)

Oak(1)

 
Maximum Load Capacity

350 lb(2)

600 lb(1)

 
Frame Material

Steel(1)

 
Base Material

Steel(1)

Powder Coated Steel(1)

 
Height Adjustment

54" to 72" of Table(1)

55" to 71"(1)

 
Top Material

Vinyl(2)

Urethane Foam(1)

 
Number of Drawers

5(2)

 
Frame Color/Finish

Walnut(1)

 
 
 

© 2020-2021 Legal Name, All Rights Reserved