Medline offers a comprehensive range of advanced skin care and wound care products for all phases of acute, critical and chronic wounds, including venous leg ulcers, diabetic foot ulcers and pressure ulcers, burns and post-operative wounds. Our products are designed to work in a complementary manner to help prevent and efficiently treat skin related problems. Our portfolio includes heel protectors for the prevention and treatment of pressure ulcers, wound dressings, skin protectants and moisture-related skin care products.
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 = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 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 (36825, 36855, 36858, 36861, 36865, 36870, 36873, 89021, 37613))) AND (e.created_in <= '1700708760') AND (e.updated_in > '1700708760') ORDER BY FIELD(e.entity_id,36825,36855,36858,36861,36865,36870,36873,89021,37613)
