Drain Covers and Leak Diverters

Durable, Chemically Resistant Drain Covers and Leak Diverters

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.website_id = '1' AND price_index.customer_group_id = 0 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 (9432, 9440, 9457, 9466)) ORDER BY FIELD(e.entity_id,9432,9440,9457,9466)

4 Items

Set Descending Direction
View as Grid List

4 Items

Set Descending Direction
View as Grid List

Durable, Chemically Resistant Drain Covers and Leak Diverters

Protect against unexpected leaks and spills with Eagle drain covers and leak diverters. Durable and chemically resistant, our drain covers create a barrier to help prevent liquids from reaching the drain. Use leak diverters to channel away liquids and minimize the risk of injuries, property damage and contamination due to drips and leaks.

Terms and Conditions Privacy Policy Terms of Use © 2021 Eagle Manufacturing All Rights Reserved