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 = '386' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,50 Clinton Industries Treatment Tables

Clinton Industries Treatment Tables

Shop for Clinton Industries Treatment Tables

Clinton 100 Classic Flat Top Straight Line Treatment Table

Clinton 100 Classic Flat Top Straight Line Treatment Table

Product Code: 100

Solid hardwood legsH-brace constructionLegs have pre-inserted carriage bolts for fast easy assemblyS..

Price:  $357.13
Clinton 1010 Classic H-Brace Treatment Table

Clinton 1010 Classic H-Brace Treatment Table

Product Code: 1010

Classic Line tables are available in a variety of configurations with easy-clean, scratch resistant ..

Price:  $357.13
Clinton 1013 Classic Treatment Table with Shelf and Drawers

Clinton 1013 Classic Treatment Table with Shelf and Drawers

Product Code: 1013

Clinton Industries set a new standard in medical treatment tables with their Classic Line of Treatme..

Price:  $761.18
Clinton 1020 Classic Treatment Table with Shelf

Clinton 1020 Classic Treatment Table with Shelf

Product Code: 1020

Clinton Industries set a new standard in medical treatment tables with their Classic Line of Treatme..

Price:  $404.71
Clinton 1030 Classic Treatment Table with Shelves

Clinton 1030 Classic Treatment Table with Shelves

Product Code: 1030

Clinton Industries set a new standard in medical treatment tables with the Classic Line of Treatmen..

Price:  $564.71
Clinton 1300 Classic Flat Top Treatment Table with Shelf and Drawers

Clinton 1300 Classic Flat Top Treatment Table with Shelf and Drawers

Product Code: 1300

Solid hardwood legsTwo drawer unit and shelf in Natural or Darrk Cherry laminate to coordinate with ..

Price:  $761.18
Clinton 1701 Taping Table

Clinton 1701 Taping Table

Product Code: 1701

Clinton Industries Taping Tables are the answer for today's athletic departments. All Clinton table..

Price:  $329.41
Clinton 1702 Taping Table with Shelf

Clinton 1702 Taping Table with Shelf

Product Code: 1702

Clinton Industries Taping Tables are the answer for today's athletic departments. All Clinton table..

Price:  $374.12
Clinton 1703 Taping Table with Shelves

Clinton 1703 Taping Table with Shelves

Product Code: 1703

Clinton Industries Taping Tables are the answer for today's athletic departments. All Clinton table..

Price:  $445.82
Clinton 200 Classic Flat Top Straight Line Treatment Table with Shelf

Clinton 200 Classic Flat Top Straight Line Treatment Table with Shelf

Product Code: 200

Solid hardwood legsH-brace constructionFull laminate shelf in Natural or Dark Cherry to coordinate w..

Price:  $404.71
Clinton 300 Classic Flat Top Straight Line Treatment Table with Shelving

Clinton 300 Classic Flat Top Straight Line Treatment Table with Shelving

Product Code: 300

Solid hardwood legs• Tiered  shelving unit and shelf in Natural or Dark Cherry laminate to coor..

Price:  $564.71
Clinton 3010 Alpha H-Brace Treatment Table

Clinton 3010 Alpha H-Brace Treatment Table

Product Code: 3010

Features powder-coated, all-steel frameEasy bolt-through assemblyPaper dispenser includedAdjustable ..

Price:  $370.91
Clinton 3013 Alpha Treatment Table with Drawers

Clinton 3013 Alpha Treatment Table with Drawers

Product Code: 3013

Features powder-coated, all-steel frame; gray laminate shelf; two, easy-clean, plastic drawers with ..

Price:  $761.18
Clinton 3020 Alpha Treatment Table with Shelf

Clinton 3020 Alpha Treatment Table with Shelf

Product Code: 3020

Features powder-coated, all-steel frame, gray laminate shelf and an adjustable backrestEasy bolt-thr..

Price:  $429.41
Clinton 6190 Classic Bariatric Treatment Table with Shelf

Clinton 6190 Classic Bariatric Treatment Table with Shelf

Product Code: 6190

Plywood top and solid hardwood legs6-leg design with triple bolted corner legsBuilt-in middle leg le..

Price:  $611.76
Clinton 6196 Low Height Bariatric Treatment Table

Clinton 6196 Low Height Bariatric Treatment Table

Product Code: 6196

Plywood top and solid hardwood legs6-leg design with triple bolted corner legsBuilt-in middle leg le..

Price:  $611.76
Clinton 9133 Treatment Table with Stool

Clinton 9133 Treatment Table with Stool

Product Code: 9133

Features 3 drawers, storage shelf, adjustable backrest and matching stool that stores neatly under t..

Price:  $1,200.39
Showing 1 to 17 of 17 (1 Pages)