Search for Resources

Climate Change and Your Ecological Area

Secondary, Middle

Description

In Climate Chance and Your Ecological Area, students will investigate interrelationships among plants and animals in an ecosystem and explore how climate change might affect those interrelationships and the natural community as a whole. By the end of this lesson, students will:

  • identify their own ecological area;
  • understand the concept of an ecosystem and its key components; 
  • explore interrelationships among plants and animals in a local ecosystem;
  • investigate the effects of climate change on the ecosystem and its key components; and 
  • speculate about future impacts of climate change on the ecosystem. 
This resource can take place inside and outside the classroom. 

General Assessment

Recommendation of how and where to use it

This resource would be excellent for introducing the effect of climate change on ecosystems in science and biology lessons.

Relevant Curriculum Units

The following tool will allow you to explore the relevant curriculum matches for this resource. To start, select a province listed below.

  • Step 1Select a province
  • Alberta
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Interactions and Ecosystems
    • Grade 9
      • Step 3Select a subject
      • Environmental Science
        • Step 4Relevant matches
        • Environment and Outdoor Education: Environmental Core
        • Environment and Outdoor Education: Environmental Investigations
      • Science
        • Step 4Relevant matches
        • Biological Diversity
        • Knowledge and Employability Science: Biological Diversity (Social and Environmental Contexts Emphasis)
    • Grade 10
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 10-4 (Knowledge and Employability Science): Investigating Matter and Energy in Environmental Systems
        • Science 10: Energy Flow in Global Systems
        • Science 14:Investigating Matter and Energy in the Environment
    • Grade 11
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 20: Ecosystems and Population Change
        • Biology 20:Energy and Matter Exchange in the Biosphere
      • Science
        • Step 4Relevant matches
        • Science 20: Changes in Living Systems
    • Grade 12
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 30: Population and Community Dynamics
  • British Columbia
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 7: Earth and its climate have changed over geological time
    • Grade 11
      • Step 3Select a subject
      • Environmental Science
        • Step 4Relevant matches
        • Environmental Science 11: Changing ecosystems are maintained by natural processes.
        • Environmental Science 11: Complex roles and relationships contribute to diversity of ecosystems
        • Environmental Science 11: Human practices affect the sustainability of ecosystems
        • Environmental Science 11:Humans can play a role in stewardship and restoration of ecosystems
      • Science
        • Step 4Relevant matches
        • Earth Science 11: The transfer of energy through the atmosphere creates weather and is affected by climate change
    • Grade 12
      • Step 3Select a subject
      • Environmental Science
        • Step 4Relevant matches
        • Environmental Science 12: Human activities cause changes in the global climate system
      • Science
        • Step 4Relevant matches
        • Specialized Science 12: Biodiversity is dependent on the complex interactions and processes between biotic and abiotic factors
        • Specialized Science 12: Climate change impacts biodiversity and ecosystem health
  • Manitoba
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Interactions Within Ecosystems
    • Grade 10
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Senior 2 Science: Dynamics of Ecosystems
        • Senior 2 Science: Weather Dynamics
    • Grade 12
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology: Conservation of Biodiversity
  • New Brunswick
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 7 Earth Surface Processes: Nature of Science
        • Science 7 Earth Surface Processes:Learning and Living Sustainably (STSE)
    • Grade 9
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 9 Ecosystem Dynamics: Learning and Living Sustainably (STSE)
        • Science 9 Ecosystem Dynamics: The Nature of Science
    • Grade 11
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 11: Biodiversity
    • Grade 12
      • Step 3Select a subject
      • Environmental Science
        • Step 4Relevant matches
        • Advanced Environmental Science 120: Earth Systems
  • Newfoundland & Labrador
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Interaction of Ecosystems
    • Grade 10
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 1206: Sustainability of Ecosystems
        • Science 1206: Weather Dynamics
    • Grade 11
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 2201: Ecosystem Interactions and Population Dynamics
      • Science
        • Step 4Relevant matches
        • Science 2200: Ecosytems
        • Science 2200: Weather Dynamics
    • Grade 12
      • Step 3Select a subject
      • Environmental Science
        • Step 4Relevant matches
        • Environmental Science 3205: The Atmosphere and the Environment
  • Northwest Territories
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Interactions and Ecosystems
    • Grade 9
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Biological Diversity
    • Grade 10
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Experiential Science 10, Terrestial Systems: Climatology and Meteorology
        • Experiential Science 10, Terrestial Systems: Ecology of the Land
        • Science 10-4 (Knowledge and Employability Science): Investigating Matter and Energy in Environmental Systems
        • Science 14:Investigating Matter and Energy in the Environment
    • Grade 11
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 20: Ecosystems and Population Change
        • Biology 20:Energy and Matter Exchange in the Biosphere
      • Science
        • Step 4Relevant matches
        • Science 20: Changes in Living Systems
        • Science 20: The Changing Earth
    • Grade 12
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 30: Population and Community Dynamics
  • Nova Scotia
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Life Science: Interactions Within Ecosystem
    • Grade 8
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 8: Climate Change
    • Grade 10
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 10: Sustainability of Ecosystems
        • Science 10: Weather Dynamics
    • Grade 11
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 11: Biodiversity
        • Biology 11: Interactions among Living Things
    • Grade 12
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • AP Biology: Ecology
      • Environmental Science
        • Step 4Relevant matches
        • AP Environmental Science: Global Change
        • AP Environmental Science: The Living World: Biodiversity
        • AP Environmental Science: The Living World: Ecosystems
  • Nunavut
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Interactions and Ecosystems
    • Grade 8
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Interactions in Our Environment
    • Grade 9
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Knowledge and Employability Science: Biological Diversity (Social and Environmental Contexts Emphasis)
    • Grade 10
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 10-4 (Knowledge and Employability Science): Investigating Matter and Energy in Environmental Systems
        • Science 14: Investigating Matter and Energy in the Environment
    • Grade 11
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 20: Ecosystems and Population Change
        • Biology 20: Energy and Matter Exchange in the Biosphere
      • Science
        • Step 4Relevant matches
        • Science 20: Changes in Living Systems
        • Science 20: The Changing Earth
    • Grade 12
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biologie 30 :Population and Community Dynamics
      • Science
        • Step 4Relevant matches
        • Science 30: Energy and the Environment
  • Ontario
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science & Technology
        • Step 4Relevant matches
        • Interactions in the Environment
    • Grade 9
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science (Academic):Biology: Sustainable Ecosystems
        • Science (Applied): Biology: Sustainable Ecosystems and Human Activity
    • Grade 10
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science (Academic):Earth and Space Science: Climate Change
        • Science (Applied)::Earth and Space Science: Earth's Dynamic Climate
    • Grade 11
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 11(College Prep.) Plants in the Natural Environment
        • Biology 11(Univer.Prep.) Diversity of Living Things
    • Grade 12
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 12 (Univ. Prep.): Population Dynamics
  • Prince Edward Island
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Interactions Within Ecosystems
    • Grade 9
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 9: Content Knowledge
    • Grade 10
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 431A: Earth and Space Science, Weather Systems
        • Science 431A: Life Science, Sustainability of Ecosystems
    • Grade 11
      • Step 3Select a subject
      • Biology
        • Step 4Relevant matches
        • Biology 521A: Biodiversity
        • Biology 521A: Interaction Among Living Things
    • Grade 12
      • Step 3Select a subject
      • Environmental Science
        • Step 4Relevant matches
        • Environmental Science 621A: Ecological Principles
        • Environmental Science 621A: Environmental Challenges and Successes
  • Quebec
    • Step 2Select a grade level
    • Grade 7
    • Grade 8
    • Grade 10
      • Step 3Select a subject
      • Science & Technology
        • Step 4Relevant matches
        • Applied Science & Technology:The Living World
        • Environmental Science & Technology: The Living World
        • Science & Technology:The Living World
        • Science and the Environment: The Living World
  • Saskatchewan
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 7: Life Science: Interactions within Ecosystems
    • Grade 10
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 10: Climate and Ecosystem Dynamics
    • Grade 11
      • Step 3Select a subject
      • Environmental Science
        • Step 4Relevant matches
        • Environmental Science 20: Atmosphere and Human Health
        • Environmental Science 20: Terrestrial Systems
  • Yukon Territory
    • Step 2Select a grade level
    • Grade 7
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Science 7: Earth and its climate have changed over geological time
    • Grade 11
      • Step 3Select a subject
      • Environmental Science
        • Step 4Relevant matches
        • Environmental Science 11: Changing ecosystems are maintained by natural processes.
        • Environmental Science 11: Complex roles and relationships contribute to diversity of ecosystems
        • Environmental Science 11: Human practices affect the sustainability of ecosystems
        • Environmental Science 11:Humans can play a role in stewardship and restoration of ecosystems
      • Science
        • Step 4Relevant matches
        • Earth Science 11: The transfer of energy through the atmosphere creates weather and is affected by climate change
    • Grade 12
      • Step 3Select a subject
      • Environmental Science
        • Step 4Relevant matches
        • Environmental Science 12: Human activities cause changes in the global climate system
      • Science
        • Step 4Relevant matches
        • Specialized Science 12: Climate change impacts biodiversity and ecosystem health

Themes Addressed

  • Air, Atmosphere & Climate (1)

    • Climate Change
  • Ecosystems (3)

    • Appreciating the Natural World
    • Biodiversity
    • Habitat Loss
44 total queries
(query time) (total time) (query)
0.001 0.001 (SET NAMES 'utf8')
0.0003 0.0013 ( SELECT issues.issue_id as id, issue_content.title as name FROM issues LEFT JOIN issue_content USING (issue_id) WHERE issue_content.lang_id='1' ORDER BY issue_content.title ASC ) [14 row(s)]
0.0035 0.0048 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='resource' AND parent_page=1 AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0008 0.0056 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='climate-change-and-your-ecological-area' AND parent_page=5 AND lang_id='1' AND page_details.live='yes') [0 row(s)]
0.0002 0.0058 (SELECT * FROM cms76_languages WHERE lang_id=1) [1 row(s)]
0.0015 0.0073 (SELECT * FROM cms76_languages WHERE lang_id!=1) [1 row(s)]
0.0062 0.0135 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page_id='5' AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0016 0.0151 (SELECT * FROM cms76_modules LEFT JOIN page_includes USING (module_id) WHERE page_id=5 ORDER BY page_order) [1 row(s)]
0.0003 0.0154 (SELECT * FROM page_details WHERE page_id='5') [1 row(s)]
0.0014 0.0168 ( SELECT resource_content.title FROM resources LEFT JOIN resource_content USING (resource_id) WHERE resources.language_id='1' AND resources.slug='climate-change-and-your-ecological-area' ) [1 row(s)]
0.0026 0.0194 ( SELECT resource_content.description FROM resources LEFT JOIN resource_content USING (resource_id) WHERE resources.language_id='1' AND resources.slug='climate-change-and-your-ecological-area' ) [1 row(s)]
0.0003 0.0197 ( SELECT resource_content.title FROM resources LEFT JOIN resource_content USING (resource_id) WHERE resources.language_id='1' AND resources.slug='climate-change-and-your-ecological-area' ) [1 row(s)]
0.0003 0.02 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='17' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [7 row(s)]
0.0003 0.0203 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='32' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0016 0.0219 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='195' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [5 row(s)]
0.0003 0.0222 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='225' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0225 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='223' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0228 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='245' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0231 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='253' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0234 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='282' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0015 0.0249 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='18' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0252 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='22' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0255 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='19' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0258 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='20' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0261 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='21' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0016 0.0277 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='28' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [6 row(s)]
0.0003 0.028 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='178' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0006 0.0286 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='179' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0002 0.0288 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='180' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0002 0.029 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='181' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0293 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='182' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0014 0.0307 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='183' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0044 0.0351 ( SELECT resources.resource_id, resources.*, resource_content.* FROM resources LEFT JOIN resource_content USING (resource_id) LEFT JOIN resource_curriculum ON resource_curriculum.resource_id=resources.resource_id LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id WHERE resources.language_id='1' AND resources.slug='climate-change-and-your-ecological-area' AND resources.live='yes' GROUP BY resource_content.resource_id ) [1 row(s)]
0.0003 0.0354 ( SELECT resource_supplier_content.organization, resource_supplier.website as organization_website FROM resource_supplier LEFT JOIN resource_supplier_content ON resource_supplier_content.supplier_id=resource_supplier.supplier_id WHERE resource_supplier.supplier_id='130' AND resource_supplier_content.lang_id = 1 ) [1 row(s)]
0.0005 0.0359 ( SELECT compilation_content.compilation_id, compilation_content.title as compilation_title FROM resource_compilation LEFT JOIN compilation USING (compilation_id) LEFT JOIN compilation_content USING (compilation_id) WHERE resource_compilation.resource_id='3330' AND compilation.in_sidebar='yes' AND compilation_content.lang_id='1' ) [0 row(s)]
0.001 0.0369 ( SELECT curriculum_audience_content.name as audience FROM resources LEFT JOIN resource_curriculum USING (resource_id) LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id=curriculum_units.audience_id WHERE curriculum_audience_content.lang_id='1' AND resource_curriculum.weight>0 AND resource_curriculum.resource_id='3330' AND resources.live='yes' GROUP BY curriculum_units.audience_id ORDER BY audience ) [6 row(s)]
0.0003 0.0372 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3330' ) [1 row(s)]
0.0004 0.0376 ( SELECT resource_assessment_questions_content.question_field, resource_assessment_questions_content.question_short as question, resource_assessment_questions_content.question as question_long FROM resource_assessment_questions LEFT JOIN resource_assessment_questions_content USING (question_field) WHERE resource_assessment_questions_content.lang_id='1' AND resource_assessment_questions_content.question_field like 'resource_assessment.%' ORDER BY display_order ASC ) [8 row(s)]
0.0003 0.0379 ( SELECT * FROM resource_assessment WHERE resource_id='3330' ) [1 row(s)]
0.0039 0.0418 ( SELECT curriculum_audience_content.name as audience, curriculum_subject_content.name as subject, curriculum_province_content.name as province, GROUP_CONCAT(DISTINCT curriculum_content.title SEPARATOR ';') as units FROM resources LEFT JOIN resource_curriculum USING (resource_id) LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id LEFT JOIN curriculum_content ON curriculum_content.curriculum_id=resource_curriculum.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id=curriculum_units.audience_id LEFT JOIN curriculum_subject_content ON curriculum_subject_content.subject_id=curriculum_units.subject_id LEFT JOIN curriculum_province_content ON curriculum_province_content.province_id=curriculum_units.province_id WHERE curriculum_content.lang_id='1' AND curriculum_audience_content.lang_id='1' AND curriculum_subject_content.lang_id='1' AND curriculum_province_content.lang_id='1' AND resource_curriculum.weight>0 AND resource_curriculum.resource_id='3330' AND resources.live='yes' GROUP BY curriculum_units.audience_id,curriculum_units.subject_id,curriculum_units.province_id ORDER BY province, audience, subject ) [65 row(s)]
0.0018 0.0436 ( SELECT issue_content.issue_id, issue_content.title as issue_title, issues_sub_themes_content.title as theme_title FROM resources LEFT JOIN resource_theme ON resource_theme.resource_id=resources.resource_id LEFT JOIN issues_sub_themes ON issues_sub_themes.theme_id=resource_theme.theme_id LEFT JOIN issues_sub_themes_content ON issues_sub_themes_content.theme_id=resource_theme.theme_id LEFT JOIN issue_content ON issue_content.issue_id=issues_sub_themes.issue_id WHERE issues_sub_themes_content.lang_id='1' AND issue_content.lang_id='1' AND resource_theme.resource_id='3330' AND resources.live='yes' GROUP BY issues_sub_themes.theme_id ORDER BY issue_title, theme_title ) [4 row(s)]
0.0004 0.044 (SELECT review_type FROM resources WHERE resources.resource_id='3330') [1 row(s)]
0.0002 0.0442 (SELECT review_type FROM resources WHERE resources.resource_id='3330') [1 row(s)]
0.0005 0.0447 ( SELECT issue_content.issue_id, issue_content.title as issue_title, issues_sub_themes_content.title as theme_title FROM resources LEFT JOIN resource_theme ON resource_theme.resource_id=resources.resource_id LEFT JOIN issues_sub_themes ON issues_sub_themes.theme_id=resource_theme.theme_id LEFT JOIN issues_sub_themes_content ON issues_sub_themes_content.theme_id=resource_theme.theme_id LEFT JOIN issue_content ON issue_content.issue_id=issues_sub_themes.issue_id WHERE issues_sub_themes_content.lang_id='1' AND issue_content.lang_id='1' AND resource_theme.resource_id='3330' AND resources.live='yes' GROUP BY issues_sub_themes.issue_id ORDER BY RAND() LIMIT 0,5 ) [2 row(s)]