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

Currently Filtered by

Category

Computer Desks And Mobile Workstations

Refine Search

  GO
 
Brand

Safco(23)

Alera(4)

Linea Italia(2)

Union & Scale(1)

 
Packaged Quantity

1 Each(1)

 
Assembly Required

Yes(1)

 
Limited Warranty

Lifetime(1)

 
Weight (Approximate)

63 lb(1)

 
For Use With

Alera Sedina Series and Valencia Series Components(4)

Safco Mood Collection(1)

 
Base Included

Yes(1)

 
Series Name

Alera Valencia Series(4)

Safco Eastwinds Series(3)

Safco Eastwinds(3)

Linea Italia Kompass(2)

Safco Empire(2)

Safco Muv(2)

Safco Ultimate Computer Gaming Desk(2)

Safco Alphabetter(1)

Safco Mood(1)

Safco Scoot(1)

Safco Xpressions(1)

Safco Verve(1)

 
Country of Origin

CN(23)

TW(3)

MX(2)

US(1)

China(1)

 
Height

42"(1)

 
Width

47.25"(1)

 
Depth

31.75"(1)

 
Base Material

Steel(22)

Laminate(6)

Stainless Steel(1)

Metal(1)

 
Caster/Glide/Wheel

Four Dual-Wheel Casters (Two Locking)(5)

Four Hooded Casters (Two Locking)(4)

Four Glides(4)

Four Casters(3)

Four 2" Casters (Two Locking)(3)

Three 2" Locking Casters(2)

Four Leveling Glides(2)

Five Casters (Two Locking)(2)

Four Locking Casters(2)

 
Edge Detail Profile

Straight(7)

3 mm Protective Edge Band(4)

Rounded Corner; Beveled Edge(2)

 
Weight Capacity

200 lb(3)

75 lb(2)

90 lb(1)

110 lb(1)

 
Pedestal Types

Full-Height(1)

Stationary Freestanding(1)

 
Pedestal Count

0(27)

2(1)

1(1)

 
Number of Drawers

0(29)

 
Shelf Depth

16"(4)

11.75"(2)

13"(2)

8"(1)

7.8"(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved