|
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=148039
) 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=143930
) 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=143630
) as subquery
International Relations Center
The IRC is working to make the U.S. a more responsible member of the global community by promoting progressive strategic dialogues that lead to new citizen-based agendas. Through their three key programs, Global Affairs, Right Web and Americas Program, the IRC provides independent, well-researched analysis of U.S. foreign policy, rooted in progressive values, with an emphasis on fostering strategic dialogue among academics, grassroots advocacy organizations, and policymakers. A "virtual think tank," our global partners develop policy briefs, special reports, talking points, commentaries, and other publications, most of which are widely disseminated for free to constituents around the globe.
Main Address
PO Box 2178
Silver City NM 88062
Main Telephone
505.388.0208
Joined OneWorld
11.01.2002
Features
09.04.2007
Dos días antes de la Nochebuena, el 22 de diciembre a las tres de la madrugada, 400 soldados bajo el mando de oficiales brasileños asaltaron con blindados Cité Soleil, barrio de Puerto Príncipe, apoyados por helicópteros que disparaban sobre la atemorizada población que se refugiaba en sus precarias viviendas.
Story link
Related topics/regions:
[Haiti]
Image: Mujer en Cité Soleil, Haití
16.12.2006
Leaders of Andean governments who thought that the Free Trade Agreement with the United States would deepen the process of Andean integration turned out to be dead wrong.
Read more
Related topics/regions:
[South America]
Image: © Mikko Sauli
09.12.2006
While acknowledging that all of these irregularities occurred, the tribunal, astonishingly, did not consider them grounds to annul the election. The tribunal's decision is at the center of the country's current political crisis and democratic regression.
Story link
Related topics/regions:
[Mexico]
|
|
|
|
