SELECT p.product_id, (SELECT AVG(rating) AS total FROM mm_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM mm_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM mm_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM mm_product_to_category p2c LEFT JOIN mm_product p ON (p2c.product_id = p.product_id) LEFT JOIN mm_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN mm_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '2727' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,50 Clinton Stools
  • Your shopping cart is empty!

Clinton Stools

Product Compare (0)
Clinton 2135 Black Base Pneumatic Stool

Clinton 2135 Black Base Pneumatic Stool

Product Code: 2135

The Clinton 2135 Air Lift Stool is comfortable, durable, in-expensive and stylish. It has a black ny..

Price:  $167.06
Clinton 2135-21 Black Base Pneumatic Stool with Backrest

Clinton 2135-21 Black Base Pneumatic Stool with Backrest

Product Code: 2135-21

The Clinton 2135 Air Lift Stool is comfortable, durable, in-expensive and stylish. It has a black ny..

Price:  $255.29
Clinton 2145 Hands-Free Stool

Clinton 2145 Hands-Free Stool

Product Code: 2145

Foot activated height controlContemporary stylingPremium 23" cast aluminum base with satin top and b..

Price:  $361.76
Clinton 2155 Stainless Steel Base Pneumatic Stool

Clinton 2155 Stainless Steel Base Pneumatic Stool

Product Code: 2155

Premium, 23" die cast, aluminum base with satin finish top5-leg design for greater stabilityFull siz..

Price:  $225.88
Clinton 2155-21 Stainless Steel Base Pneumatic Stool with Backrest

Clinton 2155-21 Stainless Steel Base Pneumatic Stool with Backrest

Product Code: 2155-21

Comfortable BackrestPremium, 23" die cast, aluminum base with satin finish top5-leg design for great..

Price:  $314.12
Clinton 2166W Lab Chair

Clinton 2166W Lab Chair

Product Code: 2166W

Seat features 23'' brushed aluminum base, adjustable contour backrest with high impact back shroud, ..

Price:  $563.41
Clinton 2175W Office Chair

Clinton 2175W Office Chair

Product Code: 2175W

Premium, die cast, aluminum base with satin finish top2" thick padded seat and backrestPneumatic cyl..

Price:  $431.12
Clinton 2188W Lab Chair with Arms

Clinton 2188W Lab Chair with Arms

Product Code: 2188W

Contemporary stylingCast aluminum base with satin finish2" thick padded seat and backrestContour sea..

Price:  $580.40
Showing 1 to 8 of 8 (1 Pages)