Plastic Salvage Drums With Metal Lever-Lock Band for Transporting Damaged Containers of Hazardous Materials

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 (9372)) ORDER BY FIELD(e.entity_id,9372)

1 Item

Set Descending Direction
View as Grid List

1 Item

Set Descending Direction
View as Grid List

Plastic Salvage Drums With Metal Lever-Lock Band for Transporting Damaged Containers of Hazardous Materials

The single salvage drum containment unit is ideal for use as a spill containment unit, as well as a mobile pumping station or waste collection station. With the addition of model 1698 overpack dolly, the drum is easy to move for dispensing and collection.

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