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 = 0 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 = '0') WHERE ((e.entity_id IN (84207, 84234, 84237, 84273, 84276, 84282, 84297, 84306, 84312, 84324, 84366, 84402, 63162, 64383, 64479, 64626, 64671, 65211, 65394, 65499, 66525, 66564, 66585, 66645, 66678, 66714, 66753, 66783, 66804, 66840, 67554, 67848, 69219, 69306, 69342, 69360, 69369, 69393, 69399, 69408, 69540, 69549, 69555, 69576, 69606, 69615, 69618, 69621, 69624, 70551, 70653, 70725, 70767, 70791, 70800, 70827, 70899, 64449, 64542, 65304, 64758, 69099, 64533, 68211, 64701, 68586, 64401, 63489, 62277, 64695, 65517, 64353, 62421, 64623, 82186, 64458, 68502, 64716, 64329, 66951, 68325, 67800, 68250, 64545, 64599, 64320, 64644, 62535, 68988, 64359, 65310, 62340, 65046, 68559, 67638, 69438, 66621, 63249, 62451, 64875))) AND (e.created_in <= '1592283420') AND (e.updated_in > '1592283420') ORDER BY FIELD(e.entity_id,84207,84234,84237,84273,84276,84282,84297,84306,84312,84324,84366,84402,63162,64383,64479,64626,64671,65211,65394,65499,66525,66564,66585,66645,66678,66714,66753,66783,66804,66840,67554,67848,69219,69306,69342,69360,69369,69393,69399,69408,69540,69549,69555,69576,69606,69615,69618,69621,69624,70551,70653,70725,70767,70791,70800,70827,70899,64449,64542,65304,64758,69099,64533,68211,64701,68586,64401,63489,62277,64695,65517,64353,62421,64623,82186,64458,68502,64716,64329,66951,68325,67800,68250,64545,64599,64320,64644,62535,68988,64359,65310,62340,65046,68559,67638,69438,66621,63249,62451,64875)
Acids & Bases
Compounds that dissolves in water to yield hydronium ions (H3O+) in the case of acids or hydroxide ions (OH−) in the case of bases.
Action 27301H Salicylic acid Meets analytical specification of Ph. Eur., BP, USP, 99.5-100.5% (calc. to the dried substance)
CAS Number: 69-72-7 | Molar Mass: 138.12 g/mol
Action 65826 Acetic acid Puriss. p.a., ACS Reagent, Reagent ISO, Reagent European Pharmacopoeia, 99,8%
CAS Number: 64-19-7 | Molar Mass: 60.05 g/mol
Action 66105 Boric acid Puriss. p.a., ACS Reagent, Reagent ISO, Reagent European Pharmacopoeia
Synonym: Acidum Boricum
Action 66131 Sulfuric acid Puriss. p.a., for determination of mercury, ACS Reagent, Reagent ISO, Reagent European Pharmacopoeia, 95-97%
Synonym: Sulfuric Acid Solution
Action 65989 Sodium hydroxide Extra pure, 32%
Synonym: Natrii Hydroxidum; Natrii Hydroxidum; Natrii Hydroxidum; Natrii Hydroxidum; ?Caustic Soda?Caustic SodaNatrii Hydroxidum; ?Caustic Soda?Caustic SodaNatrii Hydroxidum; Natrii Hydroxidum; ?Caustic Soda?Caustic SodaNatrii Hydroxidum; ?Caustic Soda?Caustic SodaNatrii Hydroxidum; Natrii Hydroxidum; Natrii Hydroxidum; ?Caustic Soda?Caustic SodaNatrii Hydroxidum; ?Caustic Soda?Caustic SodaNatrii Hydroxidum; Natrii Hydroxidum; ?Caustic Soda?Caustic SodaNatrii Hydroxidum; ?Caustic Soda?
Action 65923 Acetic acid Extra pure, meets analytical specifications of Reagent European Pharmacopoeia, BP , USP, FCC, E 260, 100%
Action 65873 Nitric acid Puriss. p.a., min. 65%, Reagent ISO, Reagent European Pharmacopoeia, for determination with dithizone
Action 65976 Nitric acid Puriss. p.a., for determination of mercury, Reagent ISO, Reagent European Pharmacopoeia, min. 65%
Action 66100 Boric acid Extra pure, meets analytical specifications of Reagent European Pharmacopoeia, BP, NF
Synonym: Acidum Boricum
CAS Number: 10043-35-3 | Linear Formula: H
3BO
3 | Molar Mass: 61.83 g/mol
Action I5001 Acetic acid ACS Reagent, ≥99.7%
Synonym: Glacial acetic acid
CAS Number: 64-19-7 | Linear Formula: CH
3CO
2H
| Molar Mass: 60.05 g/mol
Action 30721 Hydrochloric acid Puriss. p.a., ACS Reagent, Reag. ISO, Reag. Ph. Eur., fuming, ≥37%, APHA: ≤10
Synonym: Hydrogen Chloride Solution
CAS Number: 7647-01-0 | Linear Formula: HCl
| Molar Mass: 36.46 g/mol
Action 30743 Sulfuric acid Puriss. p.a., for determination of Hg, ACS Reagent, Reag. ISO, Reag. Ph. Eur., 95.0-97.0%
Synonym: Sulfuric acid solution
Action 33209 Acetic acid Puriss. p.a., ACS Reagent, Reag. ISO, Reag. Ph. Eur., ≥99.8%
Synonym: Glacial acetic acid
CAS Number: 64-19-7 | Linear Formula: CH
3CO
2H
| Molar Mass: 60.05 g/mol
Action 30709 Nitric acid Puriss. p.a., Reag. ISO, Reag. Ph. Eur., for determinations with dithizone, ≥65%
Synonym: Nitric Acid Solution
CAS Number: 7697-37-2 | Linear Formula: HNO
3 | Molar Mass: 63.01 g/mol
Action 07208 Sulfuric acid Puriss., meets analytical specification of BP, Ph. Eur., 95-97%
Synonym: Sulfuric Acid Solution
CAS Number: 7664-93-9 | Linear Formula: H
2SO
4 | Molar Mass: 98.08 g/mol
Action 27225 Acetic acid Puriss., meets analytical specification of BP, FCC, Ph. Eur., USP, 99.8-100.5%
Synonym: Glacial acetic acid
CAS Number: 64-19-7 | Linear Formula: CH
3CO
2H
| Molar Mass: 60.05 g/mol
Action 31146 Boric acid Puriss. p.a., ACS Reagent, Reag. ISO, Reag. Ph. Eur., buffer substance, ≥99.8%
Synonym: Acidum Boricum
CAS Number: 10043-35-3 | Linear Formula: H
3BO
3 | Molar Mass: 61.83 g/mol
Action 07102 Hydrochloric acid Meets analytical specification of BP, NF, Ph. Eur., fuming, 36.5-38%
Synonym: Hydrogen Chloride Solution
CAS Number: 7647-01-0 | Linear Formula: HCl
| Molar Mass: 36.46 g/mol
Action A6283 Acetic acid Reagent Grade, ≥99%
Synonym: Glacial acetic acid
CAS Number: 64-19-7 | Linear Formula: CH
3CO
2H
| Molar Mass: 60.05 g/mol
Action 84392 Nitric acid Purum p.a., fuming, packed in coated, shock- and leak-protected glass bottle, ≥99% (T)
Synonym: Nitric Acid Solution
CAS Number: 7697-37-2 | Linear Formula: HNO
3 | Molar Mass: 63.01 g/mol
Action 27109 Citric acid Meets analytical specification of BP, Ph. Eur., USP, E330, Anhydrous, 99.5-100.5% (based on anhydrous substance)
CAS Number: 77-92-9 | Linear Formula: HOC(COOH)(CH
2COOH)
2 | Molar Mass: 192.12 g/mol
Action 27001 Formic acid Puriss., meets analytical specifications of DAC, FCC, 98.0-100%
CAS Number: 64-18-6 | Linear Formula: HCOOH
| Molar Mass: 46.03 g/mol
Action 16201 Tannic acid Puriss., meets analytical specification of USP, powder
Synonym: Gallotannin; Tannin
CAS Number: 1401-55-4 | Linear Formula: C
76H
52O
46 | Molar Mass: 1.701.2 g/mol