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 .
Sample preparation devices that separate compounds in a liquid mixture based on their properties. Solid phase extraction can be used to isolate analytes from matrices such as urine, blood, water, beverages, soil, and animal tissue.
SPE stationary phase using silica as the adsorbent.
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)