Research Chemicals/Products/Certified Reference Materials
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=2022 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 = 36
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 = '36')
INNER JOIN `search_tmp_6107faeb57ef96_14623289` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (e.created_in <= '1592283420') AND (e.updated_in > '1592283420')
Certified Reference Material, 500 mg/L Al, 250 mg/L V, 100 mg/L each of As, Be, Co, Cr, Cu, Fe, Mn, Ni, Pb, Zn, 25 mg/L each of Cd, Se, 10 mg/L Hg in HNO3 5%
Certified Reference Material, 1000 mg/L each of Ca, Fe, K, Mg, Na, Sr, 10 mg/L each of Ag, Al, As, Ba, Be, Cd, Co, Cr, Cu, Mn, Mo, Ni, Pb, Sb, Se, Tl, V, Zn, Th, U in HNO3 5%
Certified Reference Material, 10 mg/L each of Ag, Al, As, Ba, Be, Bi, Ca, Cd, Co, Cr, Cs, Cu, Fe, Ga, Hg, In, K, Li, Mg, Mn, Na, Ni, Pb, Rb, Se, Sr, Tl, U, V, Zn in HNO3 5%
Certified Reference Material, 120 mg/L Sb, 100 mg/L each of Co, V, 80 mg/L Ni, 50 mg/L Cu, 40 mg/L Zn, 30 mg/L Mn, 20 mg/L each of Ag, As, Cr, Tl, 10 mg/L each of Be, Cd, Se, 6 mg/L Pb in HNO3 5%
Certified Reference Material, 250 mg/L each of Ba, Cr, Cu, Zn, 150 mg/L V, 125 mg/L Ni, 100 mg/L each of Co, Pb, Sb, 50 mg/L each of As, Cd, 25 mg/L each of Ag, Be, Se, Tl in HNO3 5%
Certified Reference Material, 500 mg/L Fe, 250 mg/L each of Ba, Zn, 100 mg/L each of Co, Cr, Cu, Mn, Ni, Sb, V, 50 mg/L each of As, Pb, 25 mg/L each of Ag, Be, Cd, Se, Tl in HNO3 5%
Certified Reference Material, 100 mg/L each of Al, As, Pb, Sb, Se, Tl, 50 mg/L each of Ba, Co, Cu, Ni, 20 mg/L each of Cr, Fe, Mn, 10 mg/L Ag, 5 mg/L each of Be, Cd in HNO3 5%, tr. HF
Certified Reference Material, 100 mg/L each of B, Fe, Se, Tl, Zn, 40 mg/L each of Al, As, Ba, Pb, V, 20 mg/L each of Cr, Cu, Ni, 10 mg/L each of Be, Cd, Co, Mn in HNO3 10%
Certified Reference Material, 21215 mg/L Cl-, 3000 mg/L Ca, 2500 mg/L each of Fe, Na, 2000 mg/L C, 1000 mg/L each of Al, K, Mg, P, S, 20 mg/L each of Mo, Ti in Nitric Acid 5% in HNO3 5%