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

Currently Filtered by

Category

Stands

Refine Search
  GO
 
Brand

Safco(18)

Champion Sports(5)

Kantek(4)

Vertiflex(3)

Fellowes(2)

Master(1)

 
For Use With

Laptops Up to 14"(1)

 
Series Name

Fellowes Breyta(2)

 
Country of Origin

CN(17)

TW(12)

US(4)

 
Width

9.25"(1)

 
Depth

10.55"(1)

 
Color(s)

Black(15)

Gray(4)

White(3)

Black/Silver(2)

Cherry/White/Black(2)

White/Charcoal Gray(2)

Platinum(1)

Mahogany(1)

Cherry/Black(1)

Medium Oak/Black(1)

Matte Gray(1)

 
Material(s)

Steel(7)

Plastic(7)

Laminated Engineered Wood; Steel(4)

Laminated Engineered Wood; Polycarbonate; Steel(3)

ABS(2)

Laminated Engineered Wood; Powder-Coated Steel; Steel(2)

Laminated Engineered Wood; Steel; Steel Mesh(2)

Metal Wire; Steel(2)

Heavy-Gauge Static-Dissipating Steel(1)

Furniture-Grade Particleboard(1)

PVC-Laminated Engineered Wood; Steel(1)

Melamine; Steel(1)

 
Overall Width

20"(4)

21.5"(2)

21"(2)

19"(2)

28"(2)

26.25"(2)

17"(2)

23"(1)

17.8"(1)

20.25"(1)

26.5"(1)

12"(1)

20.5"(1)

25"(1)

15.25"(1)

32"(1)

29.5"(1)

23.5"(1)

11"(1)

24"(1)

25.5"(1)

25.3"(1)

 
Overall Depth

13.25"(4)

16"(4)

20"(3)

17.88"(2)

28"(2)

17.5"(2)

21"(2)

16.5"(2)

19.75"(1)

17.8"(1)

20.5"(1)

22.5"(1)

23"(1)

15"(1)

17.25"(1)

24.5"(1)

25.5"(1)

15.8"(1)

 
Caster/Glide/Wheel

Hooded Twin-Wheel(11)

Twin-Wheel(2)

Four Twin-Wheel Casters (2 Locking)(1)

 
Weight Capacity

8.8 lbs(1)

33 lbs(1)

 
Shelf Capacity (Weight)

Top: 100 lb; Second from Top & Bottom: 50 lb(1)

 
Door Quantity

0(21)

2(3)

1(1)

 
Shelf Thickness

Top: 0.75"; Second from Top: 0.5"; Bottom: 1"(2)

Top: 0.75"; Second from Top: 0.75"; Bottom: 1.75"(1)

Top: 0.75"; Bottom: 1"(1)

0.75"(1)

 
Handle Quantity

0(25)

 
Number of Drawers

0(22)

1(5)

2(1)

 
Shelf Depth

1.75"(1)

18"(1)

 
Number of Wheels

4(25)

0(1)

 
Workstation Type

Mobile Workstation; Traditional Desk/Table(2)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander