'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 = \'1153684\' )
OR
( wp_postmeta.meta_key = \'secondary_author\' AND wp_postmeta.meta_value LIKE \'{eda6976e2881db39add0df162a54fcb00df48b780376476e4ea1a2b62b990f84}\\"1153684\\"{eda6976e2881db39add0df162a54fcb00df48b780376476e4ea1a2b62b990f84}\' )
)
) 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'
China faces water crisis
Eighty percent of China’s rivers no longer support fish. Most surface waters are polluted and many rivers no longer reach the ocean. The per-capita water availability in northwest China is only one-quarter of the world average and the second lowest on the planet.
August 31, 2005
