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

ADC Otoscopes

ADC Otoscopes

Product Compare (0)
ADC Diagnostix 3.5v Portable Diagnostic Otoscope

ADC Diagnostix 3.5v Portable Diagnostic Otoscope

Product Code: 5411

The ADC Diagnostix 3.5V Portable Diagnostic Otoscope is a complete instrument that includes the 3.5v..

Price:  $429.74
ADC Diagnostix Complete Otoscope Ophthalmoscope Diagnostic Set

ADC Diagnostix Complete Otoscope Ophthalmoscope Diagnostic Set

Product Code: 5215

Full featured 2.5v set with 5 different instruments in a fitted case. The complete set features: ..

Price:  $168.79
ADC Diagnostix Pocket Otoscope with Hard Case

ADC Diagnostix Pocket Otoscope with Hard Case

Product Code: 5111N

Fiber optic Pocket Otoscope boasts incredible optics in a compact form. The 5111N Series features..

Price:  $131.45
ADC Diagnostix Pocket Otoscope with Soft Case

ADC Diagnostix Pocket Otoscope with Soft Case

Product Code: 5111NS

Fiber optic Pocket Otoscope boasts incredible optics in a compact form. The 5111N Series features..

Price:  $131.45
ADC Diagnostix Standard Otoscope Ophthalmoscope Diagnostic Set

ADC Diagnostix Standard Otoscope Ophthalmoscope Diagnostic Set

Product Code: 5210

Competitively priced 2.5v Diagnostic Set in a fitted case. ADC Standard 2.5v Instrument Set featu..

Price:  $140.96
ADC Diagnostix Standard Otoscope with 3 Reusable Speculums

ADC Diagnostix Standard Otoscope with 3 Reusable Speculums

Product Code: 5211

An affordable otoscope that offers high quality optics and workmanship. The 5211 series features:..

Price:  $56.04
ADC Otoscope Ophthalmoscope Pocket Set - One Handle

ADC Otoscope Ophthalmoscope Pocket Set - One Handle

Product Code: 5110E

Compact, single handle 2.5v Pocket Diagnostic Set. Otoscope features: Fiber optics for cool..

Price:  $231.93
ADC Otoscope Ophthalmoscope Pocket Set - Two Handles - Hard Case

ADC Otoscope Ophthalmoscope Pocket Set - Two Handles - Hard Case

Product Code: 5110N

Full featured pockets sets that sacrifices nothing but the size. Premium Two Handle Set Features:..

Price:  $263.99
ADC Otoscope Ophthalmoscope Pocket Set - Two Handles - Soft Case

ADC Otoscope Ophthalmoscope Pocket Set - Two Handles - Soft Case

Product Code: 5110NS

Full featured pockets sets that sacrifices nothing but the size. Premium Two Handle Set Features:..

Price:  $263.99
Showing 1 to 9 of 9 (1 Pages)