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

Currently Filtered by

Category

Compact And Student Desks

Refine Search

  GO
 
Brand

Safco(7)

Lorell(3)

Early Childhood Resources(2)

MooreCo(1)

Berries(1)

 
Color

Navy(1)

 
Recycled

Yes(1)

 
Packaged Quantity

1 Each(10)

2 / Carton(4)

 
Assembly Required

Yes(10)

No(4)

 
Limited Warranty

Lifetime(7)

10 Year(4)

5 Year(1)

 
Weight (Approximate)

56 lb(1)

40 lb(1)

33 lb(1)

38 lb(1)

53 lb(1)

 
Chair/Seat Type

Student Chair(1)

 
Maximum Seat Height

19"(1)

 
Base Shape

Four-legged(1)

 
Dimensions

50" Height(4)

42" Height(3)

45.75" Height(1)

30.50" Height(1)

30" Height(1)

31" Height(1)

 
Number of Legs

4(5)

 
Table Top Shape

Rectangle(11)

 
Edge Style

Round(1)

 
Table Top Width

24"(3)

28"(2)

57.50"(2)

48"(2)

31.25"(1)

18"(1)

36"(1)

 
Base Included

Yes(12)

 
Table Top Thickness

0.63"(3)

0.75"(2)

1.13"(1)

 
Base Style

Four Leg(3)

Two Leg(1)

Criss-cross(1)

 
Table Top Depth

24"(7)

18"(3)

20"(2)

 
Arm Color

Medium Oak(1)

 
Manufacturer Part Number

90082(1)

ELR-24101(1)

ELR-24103(1)

6310JCS000(1)

99893(1)

99914(1)

99915(1)

1201BE(1)

1202BE(1)

1207BE(1)

1956BH(1)

1956WL(1)

1957BH(1)

1957WL(1)

 
Country of Origin

United States(7)

Taiwan(4)

China(3)

 
Material

Steel(3)

Metal(2)

Laminate(2)

Polypropylene(2)

Plastic(1)

 
Height

30"(1)

 
Width

29.5"(1)

 
Depth

20"(1)

 
Color/Finish

Black(4)

White(2)

Cherry(1)

Laminated(1)

Rich Cherry(1)

Powder Coated(1)

Navy(1)

 
Frame Material

Tubular Steel(2)

Powder Coated Steel(1)

Steel(1)

 
Base Material

Steel(6)

 
Height Adjustment

38" to 50"(4)

26" to 42" of Tabletop(2)

18" to 29"(1)

22" to 30" of Work Surface(1)

26" to 42" of Desk(1)

 
Top Material

Medium Density Fiberboard (MDF)(3)

Laminate(1)

Kydex(1)

Fiberboard(1)

 
Frame Color/Finish

Black(4)

Powder Coated(3)

 
 
 
 
 

© 2020-2021 Bayshore Office Products, Inc., All Rights Reserved