|
select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=153072
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=150893
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=150512
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=148724
) as subquery select CategoryID, istopic from (
SELECT
CategoryID,
EXISTS (SELECT * from topics_equivalence te WHERE te.categoryid=acl.categoryid) as istopic
FROM
eZArticle_ArticleCategoryLink acl
WHERE
acl.ArticleID=145398
) as subquery
Council for a Livable World
<< Back to organisation profile
Features
11.09.2007
Efforts in Iraq have achieved "progress" and reached a "turning point" many times over the past four and a half years, says the Council for a Livable World about a key military report to Congress this week.
Story link
Related topics/regions:
[Iraq]
[United States]
Related links
03.07.2007
Worldwide confidence in the United States and its president have been falling sharply, but attitudes toward Americans are often more positive, according to data from a new poll provided by the Washington, DC-based Council for a Livable World.
Story link
Related topics/regions:
[United States]
Image: Where's the love? © Eric Draper - White House
22.06.2007
Numerous U.S. presidential candidates have said they would consider using nuclear weapons against Iran. Join the thousands of others who have co-signed a letter telling the candidates to commit to diplomacy -- not nuclear war -- with Iran, urges the Council for a Livable World.
Story link
Related topics/regions:
[United States]
[Iran]
Related links
02.05.2007
An advocacy group lays out the mounting costs -- in lives, dollars, and terrorist attacks -- of the war in Iraq, four years to the day after U.S. President George W. Bush announced the end of "major combat operations" there.
Story link
Related topics/regions:
[Iraq]
[United States]
Image: President Bush on May 1, 2003, the day he declared 'major combat operations in Iraq have ended.' © White House
25.01.2007
Now that George W. Bush has told the American people what he thinks of the state of the union, Council for a Livable World wants to hear what you think--about the speech, the decision to escalate the war in Iraq, and what the United States should be doing there.
Story link
Related topics/regions:
[Iraq]
[United States]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-12
| Next >>
|
|
|
|
