|
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=143294
) 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=142305
) 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=142044
) 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=141988
) 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=141974
) as subquery
International Relations Center
<< Back to organisation profile
Features
02.12.2006
This election season many voters are asking a critical question: What is the appropriate role for the United States in world affairs? By punishing those legislators who voted for war in Iraq, many citizens are rejecting the idea of the United States as a military overlord, asserting that a different set of values should guide our foreign policy.
Story link
10.11.2006
Guatemala's Congress did recognize that CAFTA would have negative social effects, but did not specify how. The promise to legislate compensatory measures was an empty gesture to get the measure passed. To date, no studies have been carried out or legislation passed, but Congress continues to comply with Washington's demands.
Read more
Related topics/regions:
[Guatemala]
07.11.2006
Despite the fact that the Iraq War has played a dominant role in Tuesday's elections, there is little reason to expect George W. Bush will agree to major policy shifts in 2007 on Iraq or on other challenging issues, says security analyst John Isaacs.
Story link
06.11.2006
Despite the fact that the Iraq War has played a dominant role in Tuesday's elections, there is little reason to expect George W. Bush will agree to major policy shifts in 2007 on Iraq or on other challenging issues, says security analyst John Isaacs.
Story link
Related topics/regions:
[United States]
[Iraq]
Image: Democrat John Tester: ''The time has come to support our troops by laying out a plan to bring them home.'' © Council for a Livable World
04.11.2006
Nicaragua is gearing up for its national elections on Sunday, November 5. For the last year, Nicaragua's complicated electoral panorama has been further convoluted by a string of U.S. representatives seeking to ward off an electoral victory by Sandinista (FSLN) leader and former president Daniel Ortega.
Read more
Related topics/regions:
[Nicaragua]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| Next >>
|
|
|
|
