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

ADC Ophthalmoscopes

Product Compare (0)
ADC Diagnostix 3.5v Coax Ophthalmoscope Head

ADC Diagnostix 3.5v Coax Ophthalmoscope Head

Product Code: 5440

Diagnostix 3.5v Coax Ophthalmoscope Head features: High performance aspherical condenser lens red..

Price:  $158.91
ADC Diagnostix 3.5v Coax Plus Ophthalmoscope Head

ADC Diagnostix 3.5v Coax Plus Ophthalmoscope Head

Product Code: 5442

ADC's Diagnostix 3.5 v Coax Plus Ophthalmoscope Head features: High performance aspherical conden..

Price:  $210.01
ADC Diagnostix 3.5v Ophthalmoscope with Li-ion Battery Handle

ADC Diagnostix 3.5v Ophthalmoscope with Li-ion Battery Handle

Product Code: 5412

Complete instrument includes your choice of our 3.5v Coax or Coax PLUS Ophthalmoscope head, plug-in ..

Price:  $490.94
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 Ophthalmoscope with Hard Case

ADC Diagnostix Pocket Ophthalmoscope with Hard Case

Product Code: 5112N

Feature rich 2.5v Pocket Ophthalmoscope provides all of the features, none of the bulk. The 5112N..

Price:  $176.66
ADC Diagnostix Pocket Ophthalmoscope with Soft Case

ADC Diagnostix Pocket Ophthalmoscope with Soft Case

Product Code: 5112NS

Feature rich 2.5v Pocket Ophthalmoscope provides all of the features, none of the bulk. The 5112N..

Price:  $176.66
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 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
ADC Adstation 3.5v Wall Ophthalmoscope

ADC Adstation 3.5v Wall Ophthalmoscope

Product Code: 5612

Complete instrument includes your choice of our 3.5v Coax or Coax PLUS Ophthalmoscope head and wall ..

Price:  $449.99
ADC Adstation Diagnostic Wall Set with Clock Aneroid

ADC Adstation Diagnostic Wall Set with Clock Aneroid

Product Code: 5610xx-7

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $651.56
ADC Adstation Diagnostic Wall Set with DermaScope

ADC Adstation Diagnostic Wall Set with DermaScope

Product Code: 5610xx-5

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $778.64
ADC Adstation Otoscope Ophthalmoscope Diagnostic Wall Set

ADC Adstation Otoscope Ophthalmoscope Diagnostic Wall Set

Product Code: 5610

A complete diagnostic solution that puts a full assortment of core diagnostic tools within easy reac..

Price:  $599.99
Showing 1 to 14 of 14 (1 Pages)