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 = '1252' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,50 Large Volume (Gallon)

Large Volume (Gallon)

Our durable sharps disposal containers, available in larger volumes, are designed for safe and efficient disposal of needles, lancets, and other sharp medical instruments. Ensuring compliance with safety standards, they provide a secure solution for preventing accidental injuries in healthcare environments.


BD Sharps Collector 5.4 Quart Pearl Ca20

BD Sharps Collector 5.4 Quart Pearl Ca20

Product Code: 305444

5.4 quart BD nestable patient room sharps collector. Pearl with side entry. 20 per case...

Price:  $156.62
Kendall 851301 Sharps Container 5 Quart Ea

Kendall 851301 Sharps Container 5 Quart Ea

Product Code: 851301A

Kendall Sharps Container 5 Quart, Each Always-Open lids provide convenient, quick and easy point-of..

Price:  $5.36
Kendall In-Room Sharps Container with Always-Open Lid 5 Quart Clear - Ca20

Kendall In-Room Sharps Container with Always-Open Lid 5 Quart Clear - Ca20

Product Code: 851201

Kendall In-Room Sharps Container with Always-Open Lid, 5 Quart Clear Always-Open lids provide con..

Price:  $118.17
Kendall Multi-Purpose Sharps Collector 3 Gallon- Ca10

Kendall Multi-Purpose Sharps Collector 3 Gallon- Ca10

Product Code: 85221R

Kendall Multi-Purpose Sharps Collector, 3 Gallon/12 Quart Manufacturer: Kendall Healthcare Appl..

Price:  $97.21
Medical Action 2 Gallon Sharps Container- Ca24

Medical Action 2 Gallon Sharps Container- Ca24

Product Code: 8704

Medical Action Large, Stackable Sharps Container- Case of 24 Features of the Stackable Sharps Con..

Price:  $101.03
Medical Action Red Sharps Container 32 Quart- Ea

Medical Action Red Sharps Container 32 Quart- Ea

Product Code: 8705

Medical Action Red Sharps Container, 32 Quart/8 Gallon- Each Stackable 13 3/4'' W x 13 3/4'' D ..

Price:  $13.29
Showing 1 to 6 of 6 (1 Pages)