Post-Doctoral Researcher, Environmental Justice Atlas, Autonomous University of Barcelona
'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 = \'3471966\' )
OR
( wp_postmeta.meta_key = \'secondary_author\' AND wp_postmeta.meta_value LIKE \'{afa8c295f5a0f9a46ed075d36f88c45ce779edead1d0b31fb7ebbf9182514d9d}\\"3471966\\"{afa8c295f5a0f9a46ed075d36f88c45ce779edead1d0b31fb7ebbf9182514d9d}\' )
)
) 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'
Tracking the Battles for Environmental Justice: Here are the World’s Top 10
The EJAtlas shows that people all over the world, organised in groups and networks, struggle for the kind of world they want to create, and in doing so, are promoting sustainability.
June 7, 2018
