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_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`category_name` LIKE "Exam Tables") AND `pinfo`.`status` IN ('active','discontinued') 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 '%ExamTable' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('ExamTable' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ExamTable' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ExamTable"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ExamTable"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ExamTable"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ExamTable"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ExamTable' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Exam-Table',`category_4` ='Exam-Table') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Exam-Table%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Exam-Table', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Exam Tables

Refine Search

  GO
Brand

Hausmann(7)

Color

Silver(1)

Slate Blue(1)

Black(1)

Manufacturer Part Number

91(1)

97(1)

4423SP(1)

4416SP(1)

3400(1)

4002027BE(1)

15(1)

Material

Steel(2)

Base Material

Steel(1)

Width

18"(1)

Height

10"(1)

Color/Finish

Laminated(2)

Slate Blue(2)

Oak(1)

Top Material

Vinyl(2)

Urethane Foam(1)

Frame Material

Steel(1)

Maximum Load Capacity

350 lb(2)

600 lb(1)

Height Adjustment

55" to 71"(1)

54" to 72" of Table(1)

Number of Drawers

5(2)

Frame Color/Finish

Walnut(1)

Country of Origin

United States(6)

China(1)

Price Range

$0-$499.99(4)

$500-$999.99(1)

$2000-$2499.99(1)

$2500-$2999.99(1)

To  GO

 
 
1%
Searching for your Best Results.....
loading results
 

© 2019-2020 JD Office Products, All Rights Reserved