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 = '2275' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,50 Ear Curettes
  • Your shopping cart is empty!

Ear Curettes

Welcome to the Ear Curettes store of Mohawk Medical Mall!

Product Compare (0)
Bionix 9555 Safe Ear Curettes White FlexLoop Box50

Bionix 9555 Safe Ear Curettes White FlexLoop Box50

Product Code: 9555

Bionix 9555 Safe Ear Curettes White FlexLoop Box50Bionix Safe Ear Curettes™ allow healthcare provide..

Price:  $53.90
Miltex 19-320 Ear Curettes Ring Tip Pink Box50

Miltex 19-320 Ear Curettes Ring Tip Pink Box50

Product Code: 19320

Integra Miltex 19-320 Ring Tip Ear Curette, Pink, 50/bx Each size is color coded for easy identifica..

Price:  $52.50
Miltex 19-321 Ear Curettes Loop Tip White Box50

Miltex 19-321 Ear Curettes Loop Tip White Box50

Product Code: 19321

Integra Miltex 19-321 Loop Tip Ear Curette, White, 50/bx Each size is color coded for easy identific..

Price:  $52.50
Miltex 19-322 Ear Curettes Small Spoon Tip Grey Box50

Miltex 19-322 Ear Curettes Small Spoon Tip Grey Box50

Product Code: 19322

Integra Miltex 19-322 Small Spoon Tip Ear Curette, Gray, 50/bx Each size is color coded for easy ide..

Price:  $52.50
Miltex 19-323 Ear Curettes Large Spoon Peach Box50

Miltex 19-323 Ear Curettes Large Spoon Peach Box50

Product Code: 19323

Integra Miltex 19-323 Large Spoon Tip Ear Curette, Peach, 50/bx Each size is color coded for easy id..

Price:  $52.50
Showing 1 to 5 of 5 (1 Pages)