$sql = "SELECT `BrandsChemical`.`percentage`, `BrandsChemical`.`percentage_enable`, `BrandsChemical`.`chemical_id`, `BrandsChemical`.`cas_no`, `EuChemicalClassification`.`chemical_name`, `EuChemicalClassification`.`id`, `EuChemicalClassification`.`cas_no`, `EuChemicalClassification`.`ec_no`, `EuChemicalClassification`.`labelling_risk_phrase`, `EuChemicalClassification`.`Labelling_safty_phare` FROM `brands_chemicals` AS `BrandsChemical` LEFT JOIN eu_chemical_classifications AS `EuChemicalClassification` ON (`EuChemicalClassification`.`cas_no` = `BrandsChemical`.`cas_no`) LEFT JOIN brands AS `Brand` ON (`Brand`.`id` = `BrandsChemical`.`brand_id`) LEFT JOIN brands_languages AS `BrandsLanguage` ON (`Brand`.`id` = `BrandsLanguage`.`brand_id`) WHERE `BrandsLanguage`.`language_id` = 1 AND `Brand`.`status` = 1 AND `BrandsChemical`.`brand_id` = 11462 ORDER BY `Chemical`.`ec_number` desc LIMIT 900000"
$error = "1054: Unknown column 'Chemical.ec_number' in 'order clause'"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 684
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 823
Model::find() - CORE/cake/libs/model/model.php, line 2127
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1224
TypesController::__getEuBrandChemicals() - APP/controllers/types_controller.php, line 1835
TypesController::type_detail() - APP/controllers/types_controller.php, line 1124
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Query: SELECT `BrandsChemical`.`percentage`, `BrandsChemical`.`percentage_enable`, `BrandsChemical`.`chemical_id`, `BrandsChemical`.`cas_no`, `EuChemicalClassification`.`chemical_name`, `EuChemicalClassification`.`id`, `EuChemicalClassification`.`cas_no`, `EuChemicalClassification`.`ec_no`, `EuChemicalClassification`.`labelling_risk_phrase`, `EuChemicalClassification`.`Labelling_safty_phare` FROM `brands_chemicals` AS `BrandsChemical` LEFT JOIN eu_chemical_classifications AS `EuChemicalClassification` ON (`EuChemicalClassification`.`cas_no` = `BrandsChemical`.`cas_no`) LEFT JOIN brands AS `Brand` ON (`Brand`.`id` = `BrandsChemical`.`brand_id`) LEFT JOIN brands_languages AS `BrandsLanguage` ON (`Brand`.`id` = `BrandsLanguage`.`brand_id`) WHERE `BrandsLanguage`.`language_id` = 1 AND `Brand`.`status` = 1 AND `BrandsChemical`.`brand_id` = 11462 ORDER BY `Chemical`.`ec_number` desc LIMIT 900000
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: United Kingdom
Brand Information
Date entered: March 01, 2012
The sweet combination of honey with a hint of fine chocolate makes the Glade Honey & Chocolate candle an essential accessory for a cosy evening.
The GHS is an acronym for The Globally Harmonized System of Classification and Labelling of Chemicals. The GHS is a system for standardizing and harmonizing the classification and labelling of chemicals. Chemicals are associated with codes that define their health, physical and environmental hazards.This universal hazard communication system was developed to ensure that employers, employees and consumers are provided with adequate, practical, reliable and comprehensible information on the hazards of chemicals, so that they can take effective preventive and protective measure for their own health and safety.
The GHS classifications for chemicals associated with products in this database may be viewed by selecting the "Advanced" button on the Chemical Ingredients tables. Since this is a work in progress, GHS classifications may not be shown for all chemical ingredients.
Chemical Abstracts Service Registry Number is a unique identifier for a chemical and its synonyms. CAS numbers identify the chemical, but not its concentration or specific mixture. CAS Registry Numbers are assigned by the Chemical Abstracts Service, a division of the American Chemical Society. For more information: www.cas.org
We have assigned ID numbers (with 6 leading zeros or nines, e.g., 000000-xx-x or 999999-xx-x) for blends and chemicals that do not have CAS numbers.
Is a seven-digit number (xxx-xxx-x) assigned by the European Commission to chemicals contained in three inventories: EINECS is the European Inventory of Existing Commercial Substances and its EINECS numbers are displayed as 2xx-xxx-x. ELINCS is the European List of Notified Chemical Substances that was available after September 18, 1981 and its ELINCS numbers are displayed as 4xx-xxx-x. NLP is the No-Longer Polymers category and its NLP numbers are displayed as 5xx-xxx-xEC No.
Percent of chemical in preparation.
% Conc.
REACH COMPLIANCE EU Hazard Classification Directive 67/548/EEC
Hazard Symbols are used to classify dangerous substances.
Hazard Symbols
Risk Phrases, denoted as a series of numbers preceded by the letter "R" indicate the nature of the special risks, in accordance with Annex III to Directive 67/548/EEC (see Article 23(2)(d) Directive 67/548/EEC). The numbers are separated by either a comma to denote separate statements concerning special risks, or an oblique stroke (/) to denote a combined statement, in a single sentence, of the special risks.
Risk Phrases
Safety Phrases, denoted as a series of numbers preceded by the letter "S" indicating the recommended safety precautions, in accordance with Annex IV to Directive 67/548/EEC. The numbers are separated by either a comma to denote separate statements concerning safety precautions, or an oblique stroke (/) to denote a combined statement, in a single sentence, of the safety precautions.
Safety Phrases
SVHC is a substance (identified by the European Chemicals Agency) that may have serious and often irreversible effects on human health and the environment. SVHC are defined in Article 57 of Regulation (EC) No 1907/2006 (“the REACH Regulation”) and include substances which are:
1. Carcinogenic, Mutagenic or toxic to Reproduction (CMR), meeting the criteria for classification in category 1 or 2 in accordance with Directive 67/548/EEC or in category 1a or 1b in accordance with EC No 1272/2008This directive was recently replaced by the new EU regulation (EC) No 1272/2008.
2. Persistent, Bioaccumulative and Toxic (PBT) or very Persistent and very Bioaccumulative (vPvB) according to the criteria in Annex XIII of the REACH Regulation, or
3. Identified, on a case-by-case basis, from scientific evidence as causing probable serious effects to human health or the environment of an equivalent level of concern as those above (e.g. endocrine disrupters).
SVHC?
No chemicals found.
Click on each chemical for information on chemical structure, properties and health effects.
Click on Chemical, CAS No./ID or EC No. headings to sort values.
Sources for Chemical Classifications
European Commission>JRC>IHCP>European chemical Substances Information System (ESIS) Table 3.2
Chemical Abstracts Service Registry Number is a unique identifier for a chemical and its synonyms. CAS numbers identify the chemical, but not its concentration or specific mixture. CAS Registry Numbers are assigned by the Chemical Abstracts Service, a division of the American Chemical Society. For more information: www.cas.org
We have assigned ID numbers (with 6 leading zeros or nines, e.g., 000000-xx-x or 999999-xx-x) for blends and chemicals that do not have CAS numbers.
Is a seven-digit number (xxx-xxx-x) assigned by the European Commission to chemicals contained in three inventories: EINECS is the European Inventory of Existing Commercial Substances and its EINECS numbers are displayed as 2xx-xxx-x. ELINCS is the European List of Notified Chemical Substances that was available after September 18, 1981 and its ELINCS numbers are displayed as 4xx-xxx-x. NLP is the No-Longer Polymers category and its NLP numbers are displayed as 5xx-xxx-xEC No.
Percent of chemical in preparation.
% Conc.
The GHS is an acronym for The Globally Harmonized System of Classification and Labelling of Chemicals. The GHS is a system for standardizing and harmonizing the classification and labelling of chemicals. Chemicals are associated with codes that define their health, physical and environmental hazards.This universal hazard communication system was developed to ensure that employers, employees and consumers are provided with adequate, practical, reliable and comprehensible information on the hazards of chemicals, so that they can take effective preventive and protective measure for their own health and safety.
The GHS classifications for chemicals associated with products in this database may be viewed by selecting the "Advanced" button on the Chemical Ingredients tables. Since this is a work in progress, GHS classifications may not be shown for all chemical ingredients.
UN Global Harmonization Classification
Hazard Codes and their associated descriptions are an essential part of the Globally Harmonized System of Classification and Labelling of Chemicals (GHS). There are 4 categories of Hazard Codes:
Physical Hazard Codes (H200 series)
Health Hazard Codes (H300 series)
Environmental Hazard Codes (H400 series)
Supplementary Hazard Codes (EUH series)
Hazard Codes may be found in the "Advanced" version of Chemical Composition / Ingredients tables.
Hazard Statement Code
Precautionary Codes and their associated descriptions are an essential part of the Globally Harmonized System of Classification and Labelling of Chemicals (GHS).
Precautionary Codes may be found in the "Advanced" version of Chemical Composition / Ingredients tables.
Precautionary Code
Pictogram
SVHC is a substance (identified by the European Chemicals Agency) that may have serious and often irreversible effects on human health and the environment. SVHC are defined in Article 57 of Regulation (EC) No 1907/2006 (“the REACH Regulation”) and include substances which are:
1. Carcinogenic, Mutagenic or toxic to Reproduction (CMR), meeting the criteria for classification in category 1 or 2 in accordance with Directive 67/548/EEC or in category 1a or 1b in accordance with EC No 1272/2008This directive was recently replaced by the new EU regulation (EC) No 1272/2008.
2. Persistent, Bioaccumulative and Toxic (PBT) or very Persistent and very Bioaccumulative (vPvB) according to the criteria in Annex XIII of the REACH Regulation, or
3. Identified, on a case-by-case basis, from scientific evidence as causing probable serious effects to human health or the environment of an equivalent level of concern as those above (e.g. endocrine disrupters).
SVHC?
No chemicals found.
Click on each chemical for information on chemical structure, properties and health effects.
Click on Chemical, CAS No./ID or EC No. headings to sort values.
Sources for Chemical Classifications
European Commission>JRC>IHCP>European chemical Substances Information System (ESIS) Table 3.1
Ingredients and Health Effects Information are taken from the manufacturer's product label and/or the Material Safety Data Sheet (MSDS). Products are not tested and manufacturer's information presented here is not evaluated by DeLima Associates.
This product does not contain any Substances of Very High Concern (SVHC).
Warnings
Risk of serious damage to eyes. Avoid contact with eyes. In case of contact with eyes, rinse immediately with plenty of water and seek medical advice. Wear eye/face protection. If swallowed, seek medical advice immediately and show this container or label. Wash hands after handling product. For use only in toilet bowls. Contains Octabenzone, Butylphenyl Methypropional, Coumarin and Citronellol. May produce an allergic reaction.
Safe use information
Keep out of the reach of children.
Acute health effects
Hazards Identification
Not classified as dangerous according to Dangerous Preparations Directive (99/45/EC) & amendments.
Eyes: Contact with hot product will cause thermal burns. No adverse effects expected when used as directed.
Skin effect: Contact with hot product will cause thermal burns. No adverse effects expected when used as directed.
Inhalation: No adverse effects expected when used as directed.
Ingestion: May cause abdominal discomfort. No adverse effects expected when used as directed.
Chronic health effects
No information provided.
Carcinogenicity
No information provided.
Disposal information
Do not dispose of waste into sewer. Do not contaminate ponds, waterways or ditches with chemical or used container. Disposal should be in accordance with local, state or national legislation.
First Aid
Inhalation: No special requirements
Skin contact: Rinse with plenty of water. Get medical attention if irritation develops and persists.
Eye contact: Rinse with plenty of water. Get medical attention if irritation develops and persists.