0 = tag name
= tag id
cat id = 686
select ID as postID, post_title, wp2tst_term_relationships.term_taxonomy_id as taxID, wp2tst_term_taxonomy.term_id as termID from wp2tst_posts, wp2tst_term_relationships, wp2tst_term_taxonomy where ID = object_id AND wp2tst_term_taxonomy.term_id = 686 AND ID NOT IN (select object_id from wp2tst_term_relationships where wp2tst_term_relationships.term_taxonomy_id = 420) AND wp2tst_term_relationships.term_taxonomy_id= wp2tst_term_taxonomy.term_taxonomy_id AND post_type = 'post' AND (post_status = 'publish') GROUP BY ID ORDER BY post_date DESC LIMIT 0,5
News in Politics: No recent news in this category.
For Software Addicts: Yes!
Maybe
Nah!
Articles In Category Politics
September 18th, 2008
Extending these to more difficult lines of inquiry, it's clear that changes in earth's atmosphere are causing global temperatures to rise, for the Arctic ice cap to melt, for glaciers around the world to disappear, and for the incidence of hurricanes and droughts to increase. These are facts, and nearly all scientists today agree that the inference from these facts is that Global Warming is a fact. It is the truth, even if it's extremely inconvenient.
Full article