|
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=160770
) 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=159571
) 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=159521
) 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=157268
) 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=157105
) as subquery
Nuclear Age Peace Foundation
<< Back to organisation profile
Features
02.06.2008
Advocates of nuclear peace have compiled quotes they feel best summarize each U.S. presidential candidate's views on nuclear weapons, disarmament, missile defense, and the Comprehensive Test Ban Treaty.
Story link
Related topics/regions:
[United States]
09.04.2008
Make a short video about why US leadership is necessary to achieve a world free of nuclear weapons and win $1,000.
Story link
08.04.2008
Shortly after her husband's assassination, Coretta Scott King gave a dramatic speech in his place, elucidating the "10 Commandments on Vietnam" he had written out just before his death. They ring powerfully familiar today.
Story link
Related topics/regions:
[Iraq]
[United States]
[Vietnam]
28.01.2008
David Krieger, president of the Nuclear Age Peace Foundation, writes that we can no longer rely on mutual assured destruction as a viable defense against a nuclear weapons attack and we must move towards "a world free of nuclear weapons."
Story link
23.01.2008
An organization advocating for nuclear age peace is launching an petition calling on the next U.S. president to take seven urgent steps to prevent nuclear proliferation, nuclear terrorism, and nuclear war.
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-34
| Next >>
|
|
|
|
