A flat plate that looks like a tray with multiple wells that are used as small test tubes. The well plates are commonly manufactured in a 2:3 rectangular mix with 96, 384, or 1536 wells, although other cavity configurations are available.
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=33 AND cat_index.is_parent=1
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 = 33
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')
INNER JOIN `search_tmp_60fe4e97a89809_72270654` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (e.created_in <= 1) AND (e.updated_in > 1)
KF LabwareEquipment that facilitates Karl Fischer Titration such as vials, vial caps, and crimpers.
Solvent LabwareLabware specifically for use with solvents. Includes but not limited to containers, adapters and connectors, and hoses.
Well PlatesA flat plate that looks like a tray with multiple wells that are used as small test tubes. The well plates are commonly manufactured in a 2:3 rectangular mix with 96, 384, or 1536 wells, although other cavity configurations are available.
