'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 = \'1793695\' )
OR
( wp_postmeta.meta_key = \'secondary_author\' AND wp_postmeta.meta_value LIKE \'{3bb16290989f5d5d633be9ea1e98777b2e4b00aecd09225a41c9192b7b7d0799}\\"1793695\\"{3bb16290989f5d5d633be9ea1e98777b2e4b00aecd09225a41c9192b7b7d0799}\' )
)
) 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'
Tucson shows how green infrastructure can create community resilience
What would happen if every time a roadway was built or renovated, new green infrastructure that added green spaces and soaked up rainwater was also installed? What if every time a new road is planned, we also planned to include lush tree canopies that naturally lower temperatures?
July 29, 2013
