Writer for Climate Code Red
'SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (47485,47486)
)
) AND (
(
( wp_postmeta.meta_key = \'the_author\' AND wp_postmeta.meta_value = \'3502969\' )
OR
( wp_postmeta.meta_key = \'secondary_author\' AND wp_postmeta.meta_value LIKE \'{17ed2d5799b6daefd819e13dbe3b4246fc34bcfb1bfc5c89e702fdc45e662bfc}\\"3502969\\"{17ed2d5799b6daefd819e13dbe3b4246fc34bcfb1bfc5c89e702fdc45e662bfc}\' )
)
) AND wp_posts.post_type = \'post\' AND ((wp_posts.post_status = \'publish\'))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 6'
Q: Are new liquid airline fuels good climate policy? A: Pigs might fly.
The only effective way currently available for emissions reductions from aviation to align with the 2015 Paris Agreement limits, is through a dramatic reduction in the number flights — an action not seriously addressed in the government’s transport emissions reduction roadmap.
August 27, 2024
