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

Welch Allyn Lights

Product Compare (0)
Welch Allyn KleenSpec Disposable LED Vaginal Specula - Bx96

Welch Allyn KleenSpec Disposable LED Vaginal Specula - Bx96

Product Code: 5900XLED

Integrated light source produces uniform light output to help provide the visualization needed for i..

Price:  $486.59
Welch Allyn GS IV Exam Light

Welch Allyn GS IV Exam Light

Product Code: GSIV

Perfect for the OB/GYN office or for specialties that require very focused light in specific areas, ..

Price:  $1,033.50
Welch Allyn GS300 LED Exam Light

Welch Allyn GS300 LED Exam Light

Product Code: GS300

Utilizing a single white LED, the GS 300 Exam Light Provides a whiter, brigher light than halogen an..

Price:  $426.53
Welch Allyn GS600 Minor Procedure Light

Welch Allyn GS600 Minor Procedure Light

Product Code: GS600

Featuring three LEDs and a wider head, the GS 600 is designed specifically for demanding viewing con..

Price:  $980.00
Welch Allyn GS900 Procedure Light

Welch Allyn GS900 Procedure Light

Product Code: GS900

This procedure light, featuring six LEDs, combines outstanding durability, extraordinary maneuverabi..

Price:  $2,762.50
Welch Allyn Solid State Portable Headlight - 46070

Welch Allyn Solid State Portable Headlight - 46070

Product Code: 46070

Bright, white light made affordable Solid State Portable Headlight Welch Allyn once again brings..

Price:  $314.63
Welch Allyn Solid State Procedure Headlight - 49020

Welch Allyn Solid State Procedure Headlight - 49020

Product Code: 49020

Superior white light precisely where you need it Solid State Procedure Headlight Welch Allyn onc..

Price:  $856.10
Welch Allyn 800 Series Kleenspec Illuminator - Light Only

Welch Allyn 800 Series Kleenspec Illuminator - Light Only

Product Code: 80000

KleenSpec Disposable Vaginal Specula Cordless Illuminator (Light Only) for the Kleenspec Disposable ..

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