What's in it?
Search Entire CPID Database

Enter Products, Manufacturers, Chemicals, Product Categories and Product Types

Roundup Fence & Yard Edger-Old Product

 

Products in this Consumer Product Information Database (CPID) are classified based on their composition:
Substances: single chemicals
Preparations: products which contain chemicals that can be easily separated during normal use

Articles: products or product assemblies that do not contain chemicals that can be separated out from the product or assembly under normal or advertised use.

 

Classification: 
Preparation

Indicates country where product is sold.

Market: 
US/Canada
EPA Registration No:  239-2638B
Brand Information
Date entered: June 07, 2001

Structure such as solid, liquid, aerosol etc.

Form: 
liquid
Customer Service No: 800-225-2883
Manufacturer Information

Date when validity of Material Safety Data Sheet (MSDS) or Safety Data Sheet (SDS) was last verified.

Date verified: March 20, 2020
Scotts Company

14111 Scottslawn Road  
Marysville OH 43041

937-644-0011 ^
888-270-3714 (TOLL FREE)
https://www.scotts.com

(default) 163 queries took 219 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `SoldInCountry`.`id`, `SoldInCountry`.`name`, `SoldInCountry`.`abbr`, `SoldInCountry`.`country_flag` FROM `sold_in_countries` AS `SoldInCountry` LEFT JOIN `languages` AS `Language` ON (`SoldInCountry`.`language_id` = `Language`.`id`) LEFT JOIN `regions` AS `Region` ON (`SoldInCountry`.`region_id` = `Region`.`id`) WHERE `SoldInCountry`.`status` = 1 AND `SoldInCountry`.`display_in_menu` = 1 880
2SELECT `Language`.`id`, `Language`.`abbreviation` FROM `languages` AS `Language` WHERE `Language`.`id` = 1 AND `Language`.`status` = 1 LIMIT 1110
3SELECT `Brand`.`id` FROM `brands_languages` AS `BrandsLanguage` LEFT JOIN `brands` AS `Brand` ON (`BrandsLanguage`.`brand_id` = `Brand`.`id`) WHERE `BrandsLanguage`.`id` = 3323 AND `Brand`.`status` = 1 LIMIT 1110
4SELECT `BrandsCountry`.`id`, `BrandsCountry`.`brand_id`, `BrandsCountry`.`sold_in_country_id`, `SoldInCountry`.`id`, `SoldInCountry`.`abbr`, `SoldInCountry`.`name`, `SoldInCountry`.`language_id`, `SoldInCountry`.`region_id`, `SoldInCountry`.`country_flag` FROM `brands_countries` AS `BrandsCountry` LEFT JOIN `sold_in_countries` AS `SoldInCountry` ON (`BrandsCountry`.`sold_in_country_id` = `SoldInCountry`.`id`) WHERE `BrandsCountry`.`brand_id` = 3299 AND `SoldInCountry`.`status` = 1 000
5SELECT `CategoryLanguage`.`id`, `CategoryLanguage`.`category_id`, `CategoryLanguage`.`name` FROM `category_languages` AS `CategoryLanguage` LEFT JOIN `categories` AS `Category` ON (`CategoryLanguage`.`category_id` = `Category`.`id`) WHERE `CategoryLanguage`.`language_id` = 1 AND `Category`.`status` = 1 ORDER BY `Category`.`display_order` ASC LIMIT 1210100
6SELECT `BrandsLanguage`.`id`, `BrandsLanguage`.`brand_name`, `Brand`.`brand_no`, `Brand`.`is_featured`, `Brand`.`is_new`, `Brand`.`is_green`, `Brand`.`is_future_1`, `Brand`.`upc`, `Brand`.`is_future_2`, `Brand`.`is_future_3`, `Brand`.`season`, `Brand`.`epa_registration`, `Brand`.`is_sds`, `BrandsLanguage`.`form`, `Brand`.`msds_file`, `BrandsLanguage`.`created`, `Brand`.`id`, `Brand`.`manufacturer_id`, `Brand`.`brand_usage_id`, `Brand`.`modified`, `Brand`.`created`, `Brand`.`svhc_decleration`, `BrandsLanguage`.`safe_use_info`, `Brand`.`voc_Tot_g_l`, `Brand`.`voc_Emit_g_l`, `Brand`.`wt_Percent_Tot`, `Brand`.`wt_Percent_Emit`, `Brand`.`customer_information_no`, `Brand`.`image_name`, `Brand`.`msds_verified_date`, `Brand`.`green_start_date`, `Brand`.`green_end_date`, `Brand`.`is_green_always_active`, `Brand`.`green_logo_id`, `CategoryLanguage`.`name`, `ReactivityRating`.`ratings`, `FlammabilityRating`.`ratings`, `HealthRating`.`ratings`, `BrandsLogo`.`id`, `BrandsLogo`.`brands_classifications_id`, `BrandsLogo`.`image_name`, `BrandsLogo`.`caption`, `BrandsLogo`.`status`, `Brand`.`region_id`, `UsagesLanguage`.`name`, `ProductsClassification`.`name`, `BrandsLanguage`.`description`, `Brand`.`msds_date`, `Brand`.`ph_level`, `ManufacturerLanguage`.`manufacturer_name`, `ManufacturerLanguage`.`street_address_1`, `Manufacturer`.`id`, `Manufacturer`.`region_id`, `Manufacturer`.`website`, `Manufacturer`.`modified`, `Manufacturer`.`website_enabled`, `Manufacturer`.`corporate_tel_no`, `Manufacturer`.`toll_free_no`, `Manufacturer`.`fax_no`, `Manufacturer`.`date_verified`, `ManufacturerLanguage`.`street_address_2`, `ManufacturerLanguage`.`city`, `ManufacturerLanguage`.`postcode`, `ManufacturerLanguage`.`country`, `ManufacturerLanguage`.`state`, `BrandsLanguage`.`acute_health_effects`, `BrandsLanguage`.`handling_info`, `BrandsLanguage`.`carcinogenicity`, `BrandsLanguage`.`california_warning`, `BrandsLanguage`.`disposal_info`, `BrandsLanguage`.`chronic_health_effects`, `BrandsLanguage`.`warnings`, `BrandsLanguage`.`first_aid`, `Brand`.`other_codes`, `BrandsChemical`.`percentage`, `BrandsChemical`.`nano_enable`, `BrandsChemical`.`micro_enable`, `BrandsChemical`.`chemical_id`, `BrandsChemical`.`cas_no`, `BrandAssociation`.`category_id`, `BrandAssociation`.`type_id`, `BrandAssociation`.`usage_id`, `TypeLanguage`.`type_name` FROM `brands_languages` AS `BrandsLanguage` LEFT JOIN brands AS `Brand` ON (`Brand`.`id` = `BrandsLanguage`.`brand_id`) LEFT JOIN brands_chemicals AS `BrandsChemical` ON (`BrandsLanguage`.`brand_id` = `BrandsChemical`.`brand_id`) LEFT JOIN manufacturers AS `Manufacturer` ON (`Brand`.`manufacturer_id` = `Manufacturer`.`id`) LEFT JOIN manufacturer_languages AS `ManufacturerLanguage` ON (`Manufacturer`.`id` = `ManufacturerLanguage`.`manufacturer_id`) LEFT JOIN brand_associations AS `BrandAssociation` ON (`Brand`.`id` = `BrandAssociation`.`brand_id`) LEFT JOIN usages_languages AS `UsagesLanguage` ON (`UsagesLanguage`.`usage_id` = `BrandAssociation`.`usage_id`) LEFT JOIN products_classifications AS `ProductsClassification` ON (`ProductsClassification`.`id` = `Brand`.`products_classification_id`) LEFT JOIN health_ratings AS `HealthRating` ON (`HealthRating`.`id` = `Brand`.`health_rating_id`) LEFT JOIN brands_logos AS `BrandsLogo` ON (`BrandsLogo`.`id` = `Brand`.`green_logo_id`) LEFT JOIN flammability_ratings AS `FlammabilityRating` ON (`FlammabilityRating`.`id` = `Brand`.`flammability_rating_id`) LEFT JOIN reactivity_ratings AS `ReactivityRating` ON (`ReactivityRating`.`id` = `Brand`.`reactivity_rating_id`) LEFT JOIN category_languages AS `CategoryLanguage` ON (`CategoryLanguage`.`category_id` = `BrandAssociation`.`category_id`) LEFT JOIN types AS `Type` ON (`Type`.`id` = `BrandAssociation`.`type_id`) LEFT JOIN type_languages AS `TypeLanguage` ON (`TypeLanguage`.`type_id` = `Type`.`id`) WHERE `ManufacturerLanguage`.`language_id` = 1 AND `BrandsLanguage`.`language_id` = 1 AND `BrandsLanguage`.`id` = 3323 AND `Brand`.`status` = 1 LIMIT 11116
7SELECT `BrandAssociation`.`id`, `BrandAssociation`.`category_id`, `BrandAssociation`.`type_id`, `BrandAssociation`.`usage_id` FROM `brand_associations` AS `BrandAssociation` LEFT JOIN `categories` AS `Category` ON (`BrandAssociation`.`category_id` = `Category`.`id`) WHERE `BrandAssociation`.`brand_id` = 3299 AND `Category`.`status` = 1 GROUP BY `BrandAssociation`.`id` 111
8SELECT `EdcSetting`.`id`, `EdcSetting`.`status` FROM `edc_settings` AS `EdcSetting` WHERE `EdcSetting`.`id` = 1 LIMIT 1110
9SELECT `Featuredlogo`.`id`, `Featuredlogo`.`newproductlogo`, `Featuredlogo`.`featuredlogo`, `Featuredlogo`.`seasonallogo`, `Featuredlogo`.`greenlogo`, `Featuredlogo`.`future1`, `Featuredlogo`.`future2`, `Featuredlogo`.`new_brand_color`, `Featuredlogo`.`featured_color`, `Featuredlogo`.`seasonal_color`, `Featuredlogo`.`green_color`, `Featuredlogo`.`future1_color`, `Featuredlogo`.`future2_color` FROM `featuredlogos` AS `Featuredlogo` WHERE 1 = 1 ORDER BY `Featuredlogo`.`id` DESC LIMIT 1110
10SELECT `CategoryLanguage`.`category_id`, `CategoryLanguage`.`name` FROM `category_languages` AS `CategoryLanguage` LEFT JOIN `categories` AS `Category` ON (`CategoryLanguage`.`category_id` = `Category`.`id`) WHERE `CategoryLanguage`.`language_id` = 1 AND `Category`.`status` = 1 10100
11SELECT `CategoryLanguage`.`category_id`, `CategoryLanguage`.`name` FROM `category_languages` AS `CategoryLanguage` LEFT JOIN `categories` AS `Category` ON (`CategoryLanguage`.`category_id` = `Category`.`id`) WHERE `CategoryLanguage`.`language_id` = 1 AND `Category`.`status` = 1 10100
12SELECT `TypeLanguage`.`type_id`, `TypeLanguage`.`type_name` FROM `type_languages` AS `TypeLanguage` LEFT JOIN `types` AS `Type` ON (`TypeLanguage`.`type_id` = `Type`.`id`) WHERE `TypeLanguage`.`language_id` = 1 AND `Type`.`status` = 1 3743741
13SELECT `TypeLanguage`.`type_id`, `TypeLanguage`.`type_name` FROM `type_languages` AS `TypeLanguage` LEFT JOIN `types` AS `Type` ON (`TypeLanguage`.`type_id` = `Type`.`id`) WHERE `TypeLanguage`.`language_id` = 1 AND `Type`.`status` = 1 3743741
14SELECT `UsagesLanguage`.`usage_id`, `UsagesLanguage`.`name` FROM `usages_languages` AS `UsagesLanguage` LEFT JOIN `usages` AS `Usage` ON (`UsagesLanguage`.`usage_id` = `Usage`.`id`) WHERE `UsagesLanguage`.`language_id` = 1 AND `Usage`.`status` = 1 302430248
15SELECT `UsagesLanguage`.`usage_id`, `UsagesLanguage`.`name` FROM `usages_languages` AS `UsagesLanguage` LEFT JOIN `usages` AS `Usage` ON (`UsagesLanguage`.`usage_id` = `Usage`.`id`) WHERE `UsagesLanguage`.`language_id` = 1 AND `Usage`.`status` = 1 302430248
16SELECT COUNT(*) AS `count` FROM `brands_chemicals` AS `BrandsChemical` LEFT JOIN chemicals AS `Chemical` ON (((`BrandsChemical`.`chemical_id` = `Chemical`.`id`) OR (`BrandsChemical`.`cas_no` = `Chemical`.`cas_number`))) LEFT JOIN edc_chemicals AS `EdcChemical` ON (`EdcChemical`.`cas_no` = `Chemical`.`cas_number`) LEFT JOIN brands AS `Brand` ON (`Brand`.`id` = `BrandsChemical`.`brand_id`) LEFT JOIN brands_languages AS `BrandsLanguage` ON (`BrandsChemical`.`brand_id` = `BrandsLanguage`.`brand_id`) LEFT JOIN `chemical_functions` AS `ChemicalFunction` ON (`BrandsChemical`.`chemical_function_id` = `ChemicalFunction`.`id`) WHERE `BrandsLanguage`.`language_id` = 1 AND `Brand`.`status` = 1 AND `Brand`.`id` = 3299 AND `Chemical`.`status` = 1 1116
17SELECT `BrandsChemical`.`id`, `BrandsChemical`.`order`, `BrandsChemical`.`percentage`, `BrandsChemical`.`percentage_enable`, `BrandsChemical`.`nano_enable`, `BrandsChemical`.`micro_enable`, `BrandsChemical`.`chemical_id`, `BrandsChemical`.`cas_no`, `BrandsChemical`.`chemical_function_id`, `Chemical`.`chemical_name`, `Chemical`.`id`, `Chemical`.`cas_number`, `Chemical`.`ec_number`, `Chemical`.`hazard_symbols`, `Chemical`.`hazard_category`, `Chemical`.`hazard_class`, `Chemical`.`hazard_statement_code`, `Chemical`.`precautionary_statement_code`, `Chemical`.`label_code`, `Chemical`.`risk_phrases`, `Chemical`.`safety_phrases`, `EdcChemical`.`id`, `EdcChemical`.`concern`, `EdcChemical`.`status`, `ChemicalFunction`.`name`, `ChemicalFunction`.`id` FROM `brands_chemicals` AS `BrandsChemical` LEFT JOIN chemicals AS `Chemical` ON (((`BrandsChemical`.`chemical_id` = `Chemical`.`id`) OR (`BrandsChemical`.`cas_no` = `Chemical`.`cas_number`))) LEFT JOIN edc_chemicals AS `EdcChemical` ON (`EdcChemical`.`cas_no` = `Chemical`.`cas_number`) LEFT JOIN brands AS `Brand` ON (`Brand`.`id` = `BrandsChemical`.`brand_id`) LEFT JOIN brands_languages AS `BrandsLanguage` ON (`BrandsChemical`.`brand_id` = `BrandsLanguage`.`brand_id`) LEFT JOIN `chemical_functions` AS `ChemicalFunction` ON (`BrandsChemical`.`chemical_function_id` = `ChemicalFunction`.`id`) WHERE `BrandsLanguage`.`language_id` = 1 AND `Brand`.`status` = 1 AND `Brand`.`id` = 3299 AND `Chemical`.`status` = 1 ORDER BY `Chemical`.`ec_number` asc LIMIT 9000005517
18SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '999999-00-2' LIMIT 1002
19SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '999999-00-2' LIMIT 1002
20SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '999999-00-2' LIMIT 1003
21SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '999999-00-2' LIMIT 1003
22SELECT `GhsChemicalClassification`.`hazard_statement_codes` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '999999-00-2' LIMIT 1002
23SELECT `GhsChemicalClassification`.`hazard_statement_codes` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '999999-00-2' LIMIT 1002
24SELECT `GhsChemicalClassification`.`pictogram_signal` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '999999-00-2' LIMIT 1002
25SELECT `GhsChemicalClassification`.`pictogram_signal` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '999999-00-2' LIMIT 1002
26SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '999999-00-2' LIMIT 1112
27SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '999999-00-2' LIMIT 1002
28SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '999999-00-2' LIMIT 1002
29SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '999999-00-2' LIMIT 1003
30SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '999999-00-2' LIMIT 1003
31SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '999999-00-2' OR `SvhcChemical`.`ec_no` = '') AND `SvhcChemical`.`status` = 1 LIMIT 1000
32SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '999999-00-2' OR `SvhcChemical`.`ec_no` = '') AND `SvhcChemical`.`status` = 1 LIMIT 1000
33SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '999999-00-2' LIMIT 1112
34SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '999999-00-2' LIMIT 1002
35SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '999999-00-2' LIMIT 1002
36SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '999999-00-2' LIMIT 1003
37SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '999999-00-2' LIMIT 1003
38SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '999999-00-2' OR `SvhcChemical`.`ec_no` = '') AND `SvhcChemical`.`status` = 1 LIMIT 1000
39SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '999999-00-2' OR `SvhcChemical`.`ec_no` = '') AND `SvhcChemical`.`status` = 1 LIMIT 1000
40SELECT `California65Chemical`.`id`, `California65Chemical`.`cas_no`, `California65Chemical`.`chemical_name`, `California65Chemical`.`toxicity_id`, `California65Chemical`.`created`, `California65Chemical`.`modified`, `California65Chemical`.`user_id`, `California65Chemical`.`modified_by`, `California65Chemical`.`status` FROM `california65_chemicals` AS `California65Chemical` WHERE `California65Chemical`.`cas_no` = '999999-00-2' AND `California65Chemical`.`status` = 1 LIMIT 1001
41SELECT `California65Chemical`.`id`, `California65Chemical`.`cas_no`, `California65Chemical`.`chemical_name`, `California65Chemical`.`toxicity_id`, `California65Chemical`.`created`, `California65Chemical`.`modified`, `California65Chemical`.`user_id`, `California65Chemical`.`modified_by`, `California65Chemical`.`status` FROM `california65_chemicals` AS `California65Chemical` WHERE `California65Chemical`.`cas_no` = '999999-00-2' AND `California65Chemical`.`status` = 1 LIMIT 1000
42SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '38641-94-0' LIMIT 1002
43SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '038641-94-0' LIMIT 1002
44SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '38641-94-0' LIMIT 1003
45SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '038641-94-0' LIMIT 1003
46SELECT `GhsChemicalClassification`.`hazard_statement_codes` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '38641-94-0' LIMIT 1002
47SELECT `GhsChemicalClassification`.`hazard_statement_codes` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '038641-94-0' LIMIT 1002
48SELECT `GhsChemicalClassification`.`pictogram_signal` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '38641-94-0' LIMIT 1002
49SELECT `GhsChemicalClassification`.`pictogram_signal` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '038641-94-0' LIMIT 1002
50SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '38641-94-0' LIMIT 1004
51SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '038641-94-0' LIMIT 1112
52SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '38641-94-0' LIMIT 1002
53SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '038641-94-0' LIMIT 1002
54SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '38641-94-0' LIMIT 1003
55SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '038641-94-0' LIMIT 1003
56SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '38641-94-0' OR `SvhcChemical`.`ec_no` = '') AND `SvhcChemical`.`status` = 1 LIMIT 1000
57SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '038641-94-0' OR `SvhcChemical`.`ec_no` = '') AND `SvhcChemical`.`status` = 1 LIMIT 1000
58SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '38641-94-0' LIMIT 1004
59SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '038641-94-0' LIMIT 1112
60SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '38641-94-0' LIMIT 1002
61SELECT `GhsChemicalClassification`.`ec_no` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '038641-94-0' LIMIT 1002
62SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '38641-94-0' LIMIT 1003
63SELECT `CosmeticIngredient`.`ec_no` FROM `cosmetic_ingredients` AS `CosmeticIngredient` WHERE `CosmeticIngredient`.`cas_no` = '038641-94-0' LIMIT 1003
64SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '38641-94-0' OR `SvhcChemical`.`ec_no` = '') AND `SvhcChemical`.`status` = 1 LIMIT 1000
65SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '038641-94-0' OR `SvhcChemical`.`ec_no` = '') AND `SvhcChemical`.`status` = 1 LIMIT 1000
66SELECT `California65Chemical`.`id`, `California65Chemical`.`cas_no`, `California65Chemical`.`chemical_name`, `California65Chemical`.`toxicity_id`, `California65Chemical`.`created`, `California65Chemical`.`modified`, `California65Chemical`.`user_id`, `California65Chemical`.`modified_by`, `California65Chemical`.`status` FROM `california65_chemicals` AS `California65Chemical` WHERE `California65Chemical`.`cas_no` = '38641-94-0' AND `California65Chemical`.`status` = 1 LIMIT 1000
67SELECT `California65Chemical`.`id`, `California65Chemical`.`cas_no`, `California65Chemical`.`chemical_name`, `California65Chemical`.`toxicity_id`, `California65Chemical`.`created`, `California65Chemical`.`modified`, `California65Chemical`.`user_id`, `California65Chemical`.`modified_by`, `California65Chemical`.`status` FROM `california65_chemicals` AS `California65Chemical` WHERE `California65Chemical`.`cas_no` = '038641-94-0' AND `California65Chemical`.`status` = 1 LIMIT 1000
68SELECT `GhsSignalCode`.`image_name` FROM `ghs_signal_codes` AS `GhsSignalCode` WHERE `GhsSignalCode`.`code` = 'Warning' LIMIT 1110
69SELECT `GhsSignalCode`.`image_name` FROM `ghs_signal_codes` AS `GhsSignalCode` WHERE `GhsSignalCode`.`code` = 'GHS07' LIMIT 1110
70SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '112-05-0' LIMIT 1004
71SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '000112-05-0' LIMIT 1112
72SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '112-05-0' OR `SvhcChemical`.`ec_no` = '203-931-2') AND `SvhcChemical`.`status` = 1 LIMIT 1000
73SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '000112-05-0' OR `SvhcChemical`.`ec_no` = '203-931-2') AND `SvhcChemical`.`status` = 1 LIMIT 1000
74SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '112-05-0' LIMIT 1008
75SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '000112-05-0' LIMIT 1112
76SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '112-05-0' OR `SvhcChemical`.`ec_no` = '203-931-2') AND `SvhcChemical`.`status` = 1 LIMIT 1000
77SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '000112-05-0' OR `SvhcChemical`.`ec_no` = '203-931-2') AND `SvhcChemical`.`status` = 1 LIMIT 1000
78SELECT `California65Chemical`.`id`, `California65Chemical`.`cas_no`, `California65Chemical`.`chemical_name`, `California65Chemical`.`toxicity_id`, `California65Chemical`.`created`, `California65Chemical`.`modified`, `California65Chemical`.`user_id`, `California65Chemical`.`modified_by`, `California65Chemical`.`status` FROM `california65_chemicals` AS `California65Chemical` WHERE `California65Chemical`.`cas_no` = '112-05-0' AND `California65Chemical`.`status` = 1 LIMIT 1000
79SELECT `California65Chemical`.`id`, `California65Chemical`.`cas_no`, `California65Chemical`.`chemical_name`, `California65Chemical`.`toxicity_id`, `California65Chemical`.`created`, `California65Chemical`.`modified`, `California65Chemical`.`user_id`, `California65Chemical`.`modified_by`, `California65Chemical`.`status` FROM `california65_chemicals` AS `California65Chemical` WHERE `California65Chemical`.`cas_no` = '000112-05-0' AND `California65Chemical`.`status` = 1 LIMIT 1000
80SELECT `GhsSignalCode`.`image_name` FROM `ghs_signal_codes` AS `GhsSignalCode` WHERE `GhsSignalCode`.`code` = 'Danger' LIMIT 1110
81SELECT `GhsSignalCode`.`image_name` FROM `ghs_signal_codes` AS `GhsSignalCode` WHERE `GhsSignalCode`.`code` = 'GHS05' LIMIT 1110
82SELECT `GhsSignalCode`.`image_name` FROM `ghs_signal_codes` AS `GhsSignalCode` WHERE `GhsSignalCode`.`code` = 'GHS07' LIMIT 1110
83SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '1310-58-3' LIMIT 1004
84SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '001310-58-3' LIMIT 1110
85SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '1310-58-3' OR `SvhcChemical`.`ec_no` = '215-181-3') AND `SvhcChemical`.`status` = 1 LIMIT 1000
86SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '001310-58-3' OR `SvhcChemical`.`ec_no` = '215-181-3') AND `SvhcChemical`.`status` = 1 LIMIT 1000
87SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '1310-58-3' LIMIT 1004
88SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '001310-58-3' LIMIT 1110
89SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '1310-58-3' OR `SvhcChemical`.`ec_no` = '215-181-3') AND `SvhcChemical`.`status` = 1 LIMIT 1000
90SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '001310-58-3' OR `SvhcChemical`.`ec_no` = '215-181-3') AND `SvhcChemical`.`status` = 1 LIMIT 1000
91SELECT `California65Chemical`.`id`, `California65Chemical`.`cas_no`, `California65Chemical`.`chemical_name`, `California65Chemical`.`toxicity_id`, `California65Chemical`.`created`, `California65Chemical`.`modified`, `California65Chemical`.`user_id`, `California65Chemical`.`modified_by`, `California65Chemical`.`status` FROM `california65_chemicals` AS `California65Chemical` WHERE `California65Chemical`.`cas_no` = '1310-58-3' AND `California65Chemical`.`status` = 1 LIMIT 1000
92SELECT `California65Chemical`.`id`, `California65Chemical`.`cas_no`, `California65Chemical`.`chemical_name`, `California65Chemical`.`toxicity_id`, `California65Chemical`.`created`, `California65Chemical`.`modified`, `California65Chemical`.`user_id`, `California65Chemical`.`modified_by`, `California65Chemical`.`status` FROM `california65_chemicals` AS `California65Chemical` WHERE `California65Chemical`.`cas_no` = '001310-58-3' AND `California65Chemical`.`status` = 1 LIMIT 1000
93SELECT `GhsChemicalClassification`.`hazard_statement_codes` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '7783-20-2' LIMIT 1002
94SELECT `GhsChemicalClassification`.`hazard_statement_codes` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '007783-20-2' LIMIT 1002
95SELECT `GhsChemicalClassification`.`pictogram_signal` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '7783-20-2' LIMIT 1002
96SELECT `GhsChemicalClassification`.`pictogram_signal` FROM `ghs_chemical_classifications` AS `GhsChemicalClassification` WHERE `GhsChemicalClassification`.`cas_no` = '007783-20-2' LIMIT 1002
97SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '7783-20-2' LIMIT 1004
98SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '007783-20-2' LIMIT 1111
99SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '7783-20-2' OR `SvhcChemical`.`ec_no` = '231-984-1') AND `SvhcChemical`.`status` = 1 LIMIT 1000
100SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '007783-20-2' OR `SvhcChemical`.`ec_no` = '231-984-1') AND `SvhcChemical`.`status` = 1 LIMIT 1000
101SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '7783-20-2' LIMIT 1004
102SELECT `Chemical`.`ec_number` FROM `chemicals` AS `Chemical` WHERE `Chemical`.`cas_number` = '007783-20-2' LIMIT 1111
103SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '7783-20-2' OR `SvhcChemical`.`ec_no` = '231-984-1') AND `SvhcChemical`.`status` = 1 LIMIT 1000
104SELECT `SvhcChemical`.`id`, `SvhcChemical`.`ec_no`, `SvhcChemical`.`cas_no`, `SvhcChemical`.`name`, `SvhcChemical`.`created`, `SvhcChemical`.`reason_for_creation`, `SvhcChemical`.`date_created`, `SvhcChemical`.`modified`, `SvhcChemical`.`user_id`, `SvhcChemical`.`modified_by`, `SvhcChemical`.`status` FROM `svhc_chemicals` AS `SvhcChemical` WHERE (`SvhcChemical`.`cas_no` = '007783-20-2' OR `SvhcChemical`.`ec_no` = '231-984-1') AND `SvhcChemical`.`status` = 1 LIMIT 1000
105SELECT `California65Chemical`.`id`, `California65Chemical`.`cas_no`, `California65Chemical`.`chemical_name`, `California65Chemical`.`toxicity_id`, `California65Chemical`.`created`, `California65Chemical`.`modified`, `California65Chemical`.`user_id`, `California65Chemical`.`modified_by`, `California65Chemical`.`status` FROM `california65_chemicals` AS `California65Chemical` WHERE `California65Chemical`.`cas_no` = '7783-20-2' AND `California65Chemical`.`status` = 1 LIMIT 1000
106SELECT `California65Chemical`.`id`, `California65Chemical`.`cas_no`, `California65Chemical`.`chemical_name`, `California65Chemical`.`toxicity_id`, `California65Chemical`.`created`, `California65Chemical`.`modified`, `California65Chemical`.`user_id`, `California65Chemical`.`modified_by`, `California65Chemical`.`status` FROM `california65_chemicals` AS `California65Chemical` WHERE `California65Chemical`.`cas_no` = '007783-20-2' AND `California65Chemical`.`status` = 1 LIMIT 1000
107SELECT `CocSetting`.`id`, `CocSetting`.`turn_on` FROM `coc_settings` AS `CocSetting` WHERE `CocSetting`.`id` = 1 LIMIT 1110
108SELECT `CocMasterList`.`id`, `CocMasterList`.`name`, `CocMasterList`.`description`, `CocMasterList`.`table_name`, `CocMasterList`.`status`, `CocMasterList`.`connect_external_url`, `CocMasterList`.`connect_to_table`, `CocMasterList`.`disabled_link`, `CocMasterList`.`external_url`, `CocMasterList`.`external_url_1`, `CocMasterList`.`external_url_2`, `CocMasterList`.`source_date`, `CocMasterList`.`entered_date`, `CocMasterList`.`created_on`, `CocMasterList`.`created_by` FROM `coc_master_lists` AS `CocMasterList` WHERE `CocMasterList`.`status` = 1 29290
109SELECT * FROM california_prop65_lists Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')001
110SELECT * FROM eu_carcinogens_mutagens_repro_toxicants_cmr_lists Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')005
111SELECT * FROM eu_endocrine_disruptors Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
112SELECT * FROM iris_neurotoxicants Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
113SELECT * FROM iris_carcinogens Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
114SELECT * FROM eu_pbts Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
115SELECT * FROM canada_epa_pbts Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
116SELECT * FROM iarc_groups_carcinogens_lists Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')001
117SELECT * FROM atsdr_neurotoxicants Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')002
118SELECT * FROM us_epa_priority_chemicals_lists Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
119SELECT * FROM us_ntp_reproductive_or_developmental_toxicants Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
120SELECT * FROM usa_epa_pbts Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
121SELECT * FROM washington_state_pbts Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
122SELECT * FROM us_ntp_carcinogens Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
123SELECT * FROM california_drinking_water_notification_levels Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
124SELECT * FROM california_mcls Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
125SELECT * FROM ca_toxic_air_contaminants Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
126SELECT * FROM california_priority_pollutants Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
127SELECT * FROM california_non_cancer_hazards Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
128SELECT * FROM california_priority_chemicals Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')001
129SELECT * FROM marine_priority_action_chemicals Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
130SELECT * FROM eu_fragrance_allergens Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
131SELECT * FROM aoec_asthmagens Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')001
132SELECT * FROM usepa_tsca_chemicals_of_concerns Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
133SELECT * FROM usepa_ozone_depletors Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
134SELECT * FROM ny_doh_mcls Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
135SELECT * FROM glwqa_chemicals_of_mutual_concerns Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
136SELECT * FROM new_york_air_toxics Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
137SELECT * FROM short_list_of_chemicals_of_concerns Where status=1 and cas_no IN ('999999-00-2','038641-94-0','000112-05-0','001310-58-3','007783-20-2')000
138SELECT `GhsHazardStatementLanguage`.`id`, `GhsHazardStatement`.`hazard_code`, `GhsHazardStatementLanguage`.`physical_hazard_statement` FROM `ghs_hazard_statement_languages` AS `GhsHazardStatementLanguage` LEFT JOIN `ghs_hazard_statements` AS `GhsHazardStatement` ON (`GhsHazardStatementLanguage`.`ghs_hazard_statement_id` = `GhsHazardStatement`.`id`) WHERE `GhsHazardStatement`.`hazard_code` IN ('H315','H319','H412','H290','H302','H314') AND `GhsHazardStatementLanguage`.`language_id`= 1 661
139SELECT `GhsPrecautionaryCodeLanguage`.`id`, `GhsPrecautionaryCode`.`precautionary_code`, `GhsPrecautionaryCodeLanguage`.`precautionary_statement` FROM `ghs_precautionary_code_languages` AS `GhsPrecautionaryCodeLanguage` LEFT JOIN `ghs_precautionary_codes` AS `GhsPrecautionaryCode` ON (`GhsPrecautionaryCodeLanguage`.`ghs_precautionary_code_id` = `GhsPrecautionaryCode`.`id`) WHERE `GhsPrecautionaryCode`.`precautionary_code` IN ('P280','P260','P305+P351+P338','P303+P361+P353','P310') AND `GhsPrecautionaryCodeLanguage`.`language_id` = 1 551
140SELECT `HazardsRisksSafetyLanguage`.`id`, `HazardsRisksSafety`.`code`, `HazardsRisksSafetyLanguage`.`statement` FROM `hazards_risks_safety_languages` AS `HazardsRisksSafetyLanguage` LEFT JOIN `hazards_risks_safeties` AS `HazardsRisksSafety` ON (`HazardsRisksSafetyLanguage`.`hazards_risks_safety_id` = `HazardsRisksSafety`.`id`) WHERE `HazardsRisksSafety`.`code` IN ('R34','R22','R35') AND `HazardsRisksSafetyLanguage`.`language_id` = 1 331
141SELECT `HazardsRisksSafetyLanguage`.`id`, `HazardsRisksSafety`.`code`, `HazardsRisksSafetyLanguage`.`statement` FROM `hazards_risks_safety_languages` AS `HazardsRisksSafetyLanguage` LEFT JOIN `hazards_risks_safeties` AS `HazardsRisksSafety` ON (`HazardsRisksSafetyLanguage`.`hazards_risks_safety_id` = `HazardsRisksSafety`.`id`) WHERE `HazardsRisksSafety`.`code` IN ('S(1/2-)','S26','S28','S36/37/39','S45','S(1/2-)','S26','S36/37/39','S45') AND `HazardsRisksSafetyLanguage`.`language_id` = 1 441
142SELECT `GhsSignalCodeLanguage`.`id`, `GhsSignalCode`.`code`, `GhsSignalCodeLanguage`.`statement` FROM `ghs_signal_code_languages` AS `GhsSignalCodeLanguage` LEFT JOIN `ghs_signal_codes` AS `GhsSignalCode` ON (`GhsSignalCodeLanguage`.`code_id` = `GhsSignalCode`.`code`) WHERE `GhsSignalCode`.`code` IN ('Warning','GHS07','Danger','GHS05','GHS07') AND `GhsSignalCodeLanguage`.`language_id` = 1 220
143SELECT `HazardsRisksSafetyLanguage`.`id`, `HazardsRisksSafety`.`code`, `HazardsRisksSafetyLanguage`.`statement` FROM `hazards_risks_safety_languages` AS `HazardsRisksSafetyLanguage` LEFT JOIN `hazards_risks_safeties` AS `HazardsRisksSafety` ON (`HazardsRisksSafetyLanguage`.`hazards_risks_safety_id` = `HazardsRisksSafety`.`id`) WHERE `HazardsRisksSafety`.`code` IN ('C','Xn','C') AND `HazardsRisksSafetyLanguage`.`language_id` = 1 221
144SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 145 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
145SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 151 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
146SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 152 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
147SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 153 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
148SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 142 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
149SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 27 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
150SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 140 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
151SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 154 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
152SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 149 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
153SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 158 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
154SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 155 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
155SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 156 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
156SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 144 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
157SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 159 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
158SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 163 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
159SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 160 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
160SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 74 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
161SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 157 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
162SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 161 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110
163SELECT `GlossaryLanguage`.`description` FROM `glossary_languages` AS `GlossaryLanguage` LEFT JOIN `glossaries` AS `Glossary` ON (`GlossaryLanguage`.`glossary_id` = `Glossary`.`id`) WHERE `GlossaryLanguage`.`glossary_id` = 162 AND `GlossaryLanguage`.`language_id` = 1 LIMIT 1110