This website uses cookies. By continuing to browse this site you are agreeing to our use of cookies. Please review our Privacy Policy for more information.
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 (8892, 8916, 9049, 8895, 8520, 8912, 8945, 8947, 9074, 8926, 9073, 8948, 9069, 8502, 9050, 9068, 9063, 9067, 8501, 8936, 8500, 9065, 8499, 9053)) ORDER BY FIELD(e.entity_id,8892,8916,9049,8895,8520,8912,8945,8947,9074,8926,9073,8948,9069,8502,9050,9068,9063,9067,8501,8936,8500,9065,8499,9053)
Paddle Handle Replacement for Safety Cabinet with 2 Keys - 29157 MODEL NO: 29157$161.00
Cabinet Wheel Kit , 4 Wheels, fit 30 Gallon Safety Cabinets - 1933 MODEL NO: 1933$355.00
Set of 4, Shelf Dividers 2" High for shelf depth of 14", Yellow - 29985 MODEL NO: 29985$119.00
Metal Drum Roller Assembly, Double Vertical, For 55 Gallon Drum Safety Cabinet - 25922 MODEL NO: 25922$830.00
Self-Closing Adapter Kit for Model HAZ1992 and HAZ9010 Safety Cabinet - 1979GN MODEL NO: 1979GN$302.00
Metal Drum Roller Assembly, Double Vertical, For 30 Gallon Drum Safety Cabinet - 25923 MODEL NO: 25923$722.00
15/17/30/40/45 Gallon Poly Tray kit for shelf 29937, set of 3, Yellow - 3045XKIT MODEL NO: 3045XKIT$231.00
30.375" W, Metal Shelf for 60 Gallon Safety Cabinets, Galvanized Steel - 29944 MODEL NO: 29944$139.00
Self-Closing Adapter Kit for 60 Gallon 1961 and 6110 Safety Cabinets - 1968G MODEL NO: 1968G$302.00
39.375" W, Metal Shelf for 60 or 90 Gallon Safety Cabinets, Galvanized Steel - 29945 MODEL NO: 29945$190.00
19.625" W, Metal Shelf for 48 Gallon Safety Cabinets, Galvanized Steel - 29941 MODEL NO: 29941$116.00
Self-Closing Adapter Kit for 60 Gallon and 1-Drum Vertical Safety Cabinets - 1966G MODEL NO: 1966G$302.00
Self-Closing Adapter Kit for 110 Gallon Double Drum Safety Cabinets - 1967G MODEL NO: 1967G$302.00
