We use the location you select to personalize the content on our website and provide you with relevant product pricing and availability information.
SCHEDULED MAINTENANCEOur US Distribution Center located in Texas will be closed temporarily from November 8th to 14th for scheduled maintenance. All open deliveries scheduled during this period will be shipped during the prior week. Services will resume on November 15th.
Your Session Is Expiring
Due to inactivity you will be logged out in 0 : 0 .
Fittings designed for changing out lines quickly and easily. They are made to be connected and disconnected without the use of tools, or losing product.
Products designed for the delivery of hydrocarbon-based solvents, oils, petrochemical products or water based solutions.
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`, `shared_product`.`customer_group_id` 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 = 33 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'))
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
INNER JOIN `shared_catalog_product_item` AS `shared_product` ON (shared_product.sku =e.sku) AND (shared_product.customer_group_id = '33') WHERE ((NULL)) AND (e.created_in <= 1) AND (e.updated_in > 1)