Shannan is a senior editor at YES! She covers environmental justice and Native rights issues. Follow her on Twitter @slenke
'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 = \'3473422\' )
OR
( wp_postmeta.meta_key = \'secondary_author\' AND wp_postmeta.meta_value LIKE \'{f3bba9867d90c9667029b90253305e2df83f12e1b14379687ca4b2e2e2aaf7ea}\\"3473422\\"{f3bba9867d90c9667029b90253305e2df83f12e1b14379687ca4b2e2e2aaf7ea}\' )
)
) 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'
First Nations Celebrate Win Against Trans Mountain Pipeline Expansion
A Federal Court of Appeal on Thursday struck down the Canadian government’s approval of the ‪Kinder Morgan Trans Mountain oil pipeline expansion, halting construction of the 1,150-kilometer project indefinitely.
August 31, 2018
