Environmental Anthropologist, University of St Andrews
'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 = \'3472200\' )
OR
( wp_postmeta.meta_key = \'secondary_author\' AND wp_postmeta.meta_value LIKE \'{1b57804ea46b1c6f2a9193913de541ac59f4d665414a0c036dac1fe058b443a0}\\"3472200\\"{1b57804ea46b1c6f2a9193913de541ac59f4d665414a0c036dac1fe058b443a0}\' )
)
) 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'
How $6 Trillion of Fossil Fuel Investments Got Dumped Thanks to Green Campaigners
It has become one of the fastest growing political campaigns in human history, surpassing similar battles against the tobacco industry and the fight against apartheid in South Africa. Its logic is simple: the only way to avoid climate change and dangerous levels of greenhouse gases in the atmosphere is for most fossil fuel reserves to stay in the ground.
June 20, 2018