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=129595
) 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=129192
) 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=128889
) 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=128171
) 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=126543
) as subquery
21.03.2006
Ex-marine Brian Stiedle spent parts of three years in Sudan as ceasefire monitor and peacekeeper--he explains the causes of the conflict, what can be done, and what is being done.
13.03.2006
Dozens of hunger-striking dissidents protesting against Beijing's human rights policies have gone missing or been detained, victims of a "clean-up" ahead of a meeting of China's parliament, reports Jehangir Pocha.
* China: house arrests stifle HIV/AIDS petitions
07.03.2006
With proliferation worries growing and preemptive war discredited, there appears a growing chorus calling for sanctions against Iran. Christopher Hayes cuts through the fog of the passions of war to examine the true impacts--both positive and negative--of 13 years of sanctions on Iraq.
23.02.2006
The cartoon row is a clash of sensibilities, not civilizations, says Salim Muwakkil, but he argues that if Western and Islamic governments allow the cultists to push the agenda, the choreography of polarisation will take over.
01.02.2006
Today marks the beginning of Black History month in the United States. While critics have argued that this observance has become a hollow celebration that emphasizes racial difference rather than human unity, proponents point out that the month must continue to be commemorated so that Americans don't forget the particular obstacles African Americans have had to overcome.
