SELECT *,A.page_id AS page_id,DATE_FORMAT(A.article_date,'%d.%m.%Y') AS AD FROM cms_news AS A LEFT JOIN cms_pages AS P USING(page_id) LEFT JOIN cms_pages_rel AS PR ON (PR.page_id = A.page_id) LEFT JOIN cms_template_modules AS TM ON (TM.mp_id = A.descr_mp_id) WHERE A.descr_mp_id = '531' AND P.page_published = '1' AND (A.expire_date >= '2018-06-19' OR A.expire_date = '0000-00-00') ORDER BY A.article_date DESC

Unknown column 'P.page_published' in 'where clause'

Baltic Climate | Sitemap
Policy makers
Spatial planners
Business people
The Toolkit
About climate change
 
Climate mitigation and adaptation
The three key elements of vulnerability
Climate change scenarios
 
Temperature
Precipitation
Snow cover
Wind
Climate change impacts
 
Climate change impact scenarios
 
Agriculture
Energy
Housing and water
Overall economy
Forestry
Health
Natural environment
Examples
The Project
Glossary
Policy makers
 
Introduction
Recognizing the problem
Getting into action
 
Prepare the ground
Assess vulnerability
 
Energy
Transport
Housing
Agriculture
Set the strategic direction
Plan and implement
 
Regional planning level
General planning level
Detailed planning level
Spatial planners
 
Introduction
Inventory analysis
 
Local statistical inventory
 
Socio-economic data
Energy sector data
Transport sector data
Housing/building data
Agriculture data
Generic sector data
Climate change related data
 
Greenhouse gas emissions
Future climate
Exercise A – Mapping the stakeholders
Exercise B – Identification of existing policies and measures
Exercise C - Challenges and chances generated by climate change
Vulnerability assessment
 
Preparing the process
 
What is your specific focus?
Steps of the Vulnerability Assessment process
Evaluation of the exercises
Exposure and sensitivity
 
Exercise I - How might the future society look?
Exercise II - Climatic stressor mapping
Exercise III - Socio-economic stressor mapping
Exercise IV - Local sensitivity
Response action
 
Exercise V - Identifying and ranking adaptive capacity
Exercise VI - Responsibilities and relationships of key actors involved in change
Exercise VII – Integrated vulnerability assessment and action plan
Planning and climate change
 
Local climate and the future climate scenarios
Compact and diverse urban structure
Sustainable transportation
Energy efficiency
Comfortable and healthy environment
Public participation and stakeholder involvement
Strategic planning
Costs
Business people
 
Introduction
Challenges and chances for business
SWOT analysis tool
 
How to construct a Climate SWOT
 
Identification of product life cycle stages
Identification of climate impacts
Significance assessment of the climate impacts
Compilation of the Climate SWOT
From Climate SWOT to climate strategy
References