Luke Barratt is climate emergency investigations reporter at Unearthed, Greenpeace’s journalism project.
'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 = \'3482592\' )
OR
( wp_postmeta.meta_key = \'secondary_author\' AND wp_postmeta.meta_value LIKE \'{6bb576e26237b229e53fe949a00d286d0739ffcb03a2e36b72f1cb75184ba41c}\\"3482592\\"{6bb576e26237b229e53fe949a00d286d0739ffcb03a2e36b72f1cb75184ba41c}\' )
)
) 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'
BP Spends ‘Low Carbon’ Money on Finding and Using Fossil Fuels
The oil giant BP has used money from a “low carbon transition” fund to buy shares in companies developing new ways to find and use fossil fuels, Unearthed can reveal.
August 3, 2020
