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

Currently Filtered by

Category

Management Mid Back Chairs

Refine Search

  GO
 
Brand

Lorell(41)

HON(9)

Boss(1)

La-Z-Boy(1)

 
Color

Black(21)

Brown(2)

Beige(2)

Buff(2)

White(1)

Stratus(1)

Apple Green(1)

Green(1)

Blue(1)

Ocean(1)

Silver(1)

 
Recycled

No(48)

Yes(4)

 
Height

40.5"(20)

41.8"(4)

43"(4)

42.5"(3)

43.5"(2)

45"(2)

44"(2)

39.8"(2)

41"(2)

38.8"(1)

45.5"(1)

46"(1)

23.4"(1)

39.6"(1)

42"(1)

40"(1)

 
Depth

23.5"(19)

28.8"(4)

26.5"(3)

27"(3)

28.5"(2)

25.6"(2)

24.8"(2)

28"(2)

25"(1)

25.4"(1)

26.3"(1)

32.5"(1)

24"(1)

39.3"(1)

20.1"(1)

22.9"(1)

29"(1)

34.5"(1)

26"(1)

 
Manufacturer Part Number

B9476BK(1)

86205007(1)

85563(1)

86201(1)

86201007(1)

86201008(1)

86201009(1)

8620101(1)

86201010(1)

8620102(1)

8620103(1)

8620104(1)

86209(1)

69519(1)

86209007(1)

86209008(1)

86209009(1)

8620901(1)

86209010(1)

8620902(1)

8620903(1)

8620904(1)

86802(1)

86904(1)

84589(1)

63287(1)

VL103SB11(1)

20978(1)

VL161SB11(1)

VL171SB11(1)

VL601VA10(1)

2092CU10T(1)

2092CU19T(1)

2192NSR11(1)

LWIM2ACU10(1)

LWU2ACU10(1)

20017(1)

20977(1)

40203(1)

62623(1)

40204(1)

42172(1)

42173(1)

42181(1)

54857(1)

59503(1)

59519(1)

59538(1)

60115(1)

60121(1)

62622(1)

50411(1)

 
Country of Origin

China(34)

Taiwan(13)

United States(5)

 
Width

25.3"(19)

27"(3)

26.3"(3)

27.5"(3)

25"(3)

27.8"(2)

25.4"(2)

26.5"(2)

28.8"(2)

32"(2)

28.3"(1)

24.8"(1)

26"(1)

25.1"(1)

25.6"(1)

28.1"(1)

28.5"(1)

 
Material

Fabric(1)

 
Limited Warranty

5 Year(25)

Lifetime(8)

6 Year(1)

 
Weight (Approximate)

57 lb(2)

43 lb(1)

50 lb(1)

 
Seat Material

Fabric(31)

Leather(8)

SofThread Leather(3)

Polyester(2)

Bonded Leather(1)

Foam(1)

 
Seat Color

Black(21)

Brown(2)

Iron(1)

Red(1)

Beige(1)

Green(1)

Periwinkle(1)

Ocean Blue(1)

Real Red(1)

Malted(1)

Pepper(1)

 
Seat Width

20"(18)

22"(3)

20.50"(2)

20.25"(2)

19.50"(2)

19"(1)

19.38"(1)

19.75"(1)

19.13"(1)

21.50"(1)

20.90"(1)

 
Maximum Seat Height

21"(12)

20.90"(9)

21.75"(4)

22"(2)

23.62"(2)

22.13"(1)

20.50"(1)

21.25"(1)

22.25"(1)

22.64"(1)

23.43"(1)

20.88"(1)

21.50"(1)

21.66"(1)

 
Seat Depth

18.70"(15)

18.75"(3)

19"(2)

20.10"(2)

20.50"(2)

17.75"(1)

21"(1)

15.75"(1)

17.13"(1)

18.13"(1)

17.38"(1)

16.50"(1)

19.50"(1)

21.30"(1)

 
Base Shape

5-star(47)

 
Back Height

19.70"(10)

12.29"(5)

18"(3)

17.30"(2)

21.25"(2)

26.37"(1)

21.75"(1)

25"(1)

19.29"(1)

21.26"(1)

22.83"(1)

20.13"(1)

21"(1)

20"(1)

 
Number of Casters

5(47)

 
Maximum Load Capacity

250 lb(29)

300 lb(5)

275 lb(4)

 
Minimum Seat Height

17"(10)

17.70"(9)

18"(4)

16.75"(3)

19"(2)

20.08"(2)

18.37"(1)

16.62"(1)

18.25"(1)

19.10"(1)

19.88"(1)

38.50"(1)

17.50"(1)

 
Base Material

Nylon(33)

Plastic(2)

Aluminum(2)

Steel(1)

 
Adjustable Arm

Yes(37)

No(1)

 
Seat Thickness

3"(1)

 
Arm Material

Polyurethane(5)

Leather(3)

Metal(2)

Urethane(1)

Wood(1)

Polypropylene(1)

 
Arm Height

28.70"(9)

13.90"(2)

30"(2)

32.25"(1)

21.63"(1)

21.88"(1)

29"(1)

 
Adjustable Back

Yes(9)

 
Arm Color

Chrome(2)

Black(2)

Pewter(2)

Mahogany(1)

 
Back Type

Mid Back(22)

High Back(2)

 
Product Type

Chair(52)

 
Packaged Quantity

1 Each(47)

1 / Each(5)

 
Assembly Required

Yes(47)

No(5)

 
Product Model

H2092(2)

HVL103(1)

HVL161(1)

HVL171(1)

HVL601(1)

2192(1)

 
Product Line

Ergomesh(5)

Pillow-Soft(3)

Endorse(2)

Traction(1)

Tufted(1)

Mesh(1)

 
Chair/Seat Type

Management Chair(46)

Task Chair(3)

Executive Chair(1)

 
Back Width

20"(15)

19"(3)

22"(3)

17.50"(2)

18.75"(1)

21.25"(1)

21.26"(1)

18.11"(1)

18.10"(1)

19.75"(1)

18.88"(1)

20.50"(1)

25.50"(1)

19.30"(1)

 
Frame Color

Black(30)

Mahogany(1)

 
Back Material

Fabric(4)

Polyester(2)

Nylon(2)

Bonded Leather(1)

Leather(1)

 
Adjustable Seat

Yes(49)

 
Frame Material

Plastic(4)

Wood(1)

Polyurethane(1)

Steel(1)

 
Back Color

Black(22)

Iron(1)

Red(1)