there was an error
SELECT 
  td.tid AS category_tid, 
  td.name AS category_name, 
  cat_alias.dst AS category_path, 
  CONCAT( 'taxonomy/term/', td.tid ) AS raw_category_path, 
  td2.tid AS subcategory_tid, 
  td2.name AS subcategory_name, 
  subcat_alias.dst AS subcategory_path, 
  CONCAT( 'taxonomy/term/', td2.tid ) AS raw_subcategory_path, 
  tn.nid, 
  n.title AS node_title, 
  n.created AS created_unix_time, 
  pd.published_at AS published_unix_time, 
  node_alias.dst AS node_path, 
  CONCAT( 'node/', tn.nid ) AS raw_node_path, 
  ca.field_category_rotator_text_value, 
  ca.field_front_is_popular_value AS node_is_popular, 
  ca.field_front_is_in_rotator_value AS is_in_front_rotator, 
  ffront.filepath AS front_rotator_image, 
  ca.field_front_rotator_text_value AS front_rotator_text, 
  ca.field_front_rotator_subtext_value AS front_rotator_subtext, 
  ca.field_category_is_popular_value AS category_node_is_popular, 
  ca.field_category_is_in_rotator_value AS is_in_category_rotator, 
  fcat.filepath AS category_rotator_image, 
  ca.field_category_rotator_text_value AS category_rotator_text, 
  ca.field_short_title_value AS node_short_title, 
  ca.field_short_description_value AS node_short_description, 
  CONCAT( '/images/', en1.image_name ) as thumb140x100, 
  CONCAT( '/images/', en2.image_name ) as thumb85x62, 
  CONCAT( '/images/', en3.image_name ) as thumb70x50 
FROM `term_hierarchy` th 
JOIN term_data td ON th.tid = td.tid AND parent = 0 
LEFT JOIN url_alias cat_alias ON cat_alias.src = CONCAT( 'taxonomy/term/', td.tid ) 
JOIN term_hierarchy th2 ON td.tid = th2.parent 
JOIN term_data td2 ON th2.tid = td2.tid  
LEFT JOIN url_alias subcat_alias ON subcat_alias.src = CONCAT( 'taxonomy/term/', td2.tid ) 
JOIN term_node tn ON tn.tid = td2.tid 
JOIN node n ON n.nid = tn.nid AND n.type = 'article' AND status = 1 
LEFT JOIN publication_date AS pd ON n.nid = pd.nid 
LEFT JOIN url_alias node_alias ON node_alias.src = CONCAT( 'node/', tn.nid ) 
JOIN content_type_article ca ON n.nid = ca.nid 
LEFT JOIN eco_node_image en1 ON en1.nid = n.nid AND en1.image_type = 'thumb140x100' 
LEFT JOIN eco_node_image en2 ON en2.nid = n.nid AND en2.image_type = 'thumb85x62' 
LEFT JOIN eco_node_image en3 ON en3.nid = n.nid AND en3.image_type = 'thumb70x50' 
LEFT JOIN files ffront ON ffront.fid = ca.field_front_rotator_image_fid 
LEFT JOIN files fcat ON fcat.fid = ca.field_category_rotator_image_fid 
WHERE td.vid = 1 
AND td.name != 'Blogs' 
ORDER BY td.weight, td.tid, td2.weight, td2.tid, tn.weight_in_tid, tn.nid 
Green Building - Definition from ecolife.com

Definition of Green Building

What Is a Green Building?


Based on sustainable design principles, green buildings are those that are designed and built in a way that have minimal environmental impact throughout the entire building life-cycle. Green building designs can be applied to any kind of building, including residential homes, schools, commercial buildings, industrial facilities, laboratories, and many others.

Constructing more sustainable buildings is very important as they use an enormous amount of energy, water, electricity, and resources.  The WBDG’s report states that building in the United States use “39% of America's energy and 68% of its electricity. Furthermore, buildings emit 38% of the carbon dioxide (the primary greenhouse gas associated with climate change).”[1]

The environmental issues addressed in green building design broadly include:

  • Energy efficiency: This includes the energy used for manufacturing building components, the energy used during construction and deconstruction, and building maintenance. Also included in this category is the goal to have the building generating some of its own renewable energy through solar, wind, geothermal, etc.
  • Water efficiency: A green building will be one that manages local water efficiently, including fresh and marine water sources, groundwater, rainwater, stormwater runoff, landscape water, and grey water. Green buildings will also endeavor to minimize water pollution.
  • Eco building materials: During construction and renovation, green buildings should make use of environmentally-preferable materials, such as those made from renewable resources, locally-available materials, recycled materials, biodegradable materials, nontoxic materials, and recyclable materials.
  • Waste reduction: A green building construction and deconstruction site will manage waste to reduce it as much as possible and divert what remains to recycling and reuse facilities. Waste must also be managed during the regular operation of the building.
  • Toxics reduction: Understanding that nontoxic buildings are healthier for occupants and the planet, green buildings are those that minimize the use of health-harming materials.
  • Indoor air quality: In addition to reducing materials that might pollute indoor air, green buildings will have exceptional air movement and filtration systems to maintain healthy indoor air quality for its occupants.

Green buildings are good for the environment by protecting local ecosystems, minimizing greenhouse gas emissions, improving air and water quality, and conserving natural resources, but they’re also good for people:

  • Green buildings help boost employee productivity and health
  • Green buildings reduce operating costs
  • Green buildings are beautiful to look at, live in, and work in
  • Green buildings fit into larger sustainable development infrastructure for cities and human communities

The Leadership in Energy and Environmental Design (LEED) green building program developed by the US Green Building Council (USGBC) is the most widely used green building program in the world. However, many countries have developed their own green building standards:

References

1. Optimize Energy Use. December 21, 2010. WBDG Sustainable Committee. Retrieved February 7, 2011. http://www.wbdg.org/design/minimize_consumption.php
abcdefghijklmnopqrstuvwxyz
Like ecolife on Facebook & Google, and join us in the Green movement!