Ophthalmic Drape Packs

An innovative range of ophthalmology-specific instruments and components. Medline innovates on the market by proposing single-use instruments in its ophthalmology kits these very high-quality single-use instruments offer you safety for each of your interventions. Due to our expertise in personalized medical kits for all surgical procedures, Medline have developed kits specific to ophthalmology. Our production unit, based in france, at châteaubriant, offers very great flexibility in terms of elaboration and assembly of personalized kits, in a manner to satisfy your needs. Our know-how associated with the maximization of our product portfolio, allows us to gain the confidence of the largest ophthalmology centres.


SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '16' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 18 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE ((e.entity_id IN (37723, 37761, 38673, 38676, 38702, 39311, 39364))) AND (e.created_in <= '1700708760') AND (e.updated_in > '1700708760') ORDER BY FIELD(e.entity_id,37723,37761,38673,38676,38702,39311,39364)
Sort by Descending

7 results