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 (9755, 9761, 9759, 9758, 9760, 8935, 8901, 8921, 8503, 8889, 8896, 8938, 9167, 8919, 8939, 8910, 8913, 9075, 8917, 9048, 8911, 8915, 8927, 9072)) ORDER BY FIELD(e.entity_id,9755,9761,9759,9758,9760,8935,8901,8921,8503,8889,8896,8938,9167,8919,8939,8910,8913,9075,8917,9048,8911,8915,8927,9072)
Antistatic Wire For Bonding and Grounding, With Dual Hand Clamps, 3 feet MODEL NO: 08499$111.00
Antistatic Wire For Bonding and Grounding, With Hand Clamp and "C" Clamp, 3 feet MODEL NO: 08498$83.00
13.375" W, Metal Shelf for 2 or 4 Gallon Safety Cabinets, Galvanized Steel - 29935 MODEL NO: 29935$52.00
Metal Half Shelf for Wall Mount and Aerosol Can Safety Cabinets MODEL NO: 1977$65.00
Metal Shelf for 60 and 96 Gallon Safety Cabinets with a 28.25" Inside Witdh MODEL NO: 1911$80.00
Half-Depth Shelf 110 Gallon Vertical Drum Safety Cabinet,Galvanized Steel - 29947 MODEL NO: 29947$190.00
Metal Drum Roller Assembly, Single Vertical, For 55 Gallon Drum Safety Cabinet - 25920 MODEL NO: 25920$457.00
Set of 4, Shelf Dividers 2" High for shelf depth of 18", Yellow - 29990 MODEL NO: 29990$133.00
Replacement Fusible Link For Self Closing Safety Cabinets -29988 MODEL NO: 29988$23.00
Set of 4, Adjustable Leveling Feet for Safety Cabinets - 25952 MODEL NO: 25952$29.00
29.625" W Plastic Tray for 60 Gallon Safety Cabinet, Yellow - 29054 MODEL NO: 29054$176.00
