'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 = \'1153211\' )
OR
( wp_postmeta.meta_key = \'secondary_author\' AND wp_postmeta.meta_value LIKE \'{356cfa8b381814cbe27f7c2ab7fc76a9c7a19a28e13823a07cd6e100a922c935}\\"1153211\\"{356cfa8b381814cbe27f7c2ab7fc76a9c7a19a28e13823a07cd6e100a922c935}\' )
)
) 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'
New Zealand Greens screen Peak Oil film, ‘The End of Suburbia’
“In conjunction with the Green Transport Campaign, we are pleased to bring you the newly released documentary End of Suburbia… Followed by an afterward discussion with Green Party Co-Leader and Transport spokesperson”
November 8, 2004
NZ: Farming must clean up its act
Green Co-Leader Jeanette Fitzsimons says farmers should stop seeing environmental concerns as a threat and recognise that it is essential to their economic interests to clean up their act.
November 3, 2004
