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=46111
) 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=46138
) 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=44813
) 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=40072
) 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=59240
) as subquery
18.10.2002
War against Iraq will draw attention from grassroots development issues and reduce funds available for addressing them, as it threatens global peace and stability, warns the leader of a worldwide alliance of civil society organizations.
01.10.2002
The stigma of AIDS is a major barrier to combating the disease. But societies that are open and direct in debating prevention and treatment options have been successful in turning their infection rates around.
27.09.2002
Much attention will be focussed this weekend on the annual meetings of International Monetary Fund and World Bank. But what exactly are they and who controls them?
13.09.2002
Nigerian women are mad and they're not going to take it any more! A coalition of leading women's groups has issued an 11-point declaration demanding an end to political repression, environmental degradation, and gender-biased persecution based on Islamic laws.
29.08.2002
A project working on land re-occupation and demarcation by displaced rural communities in Mozambique is using film as a tool to increase their participation. Films are used to follow the whole process, which helps people who cannot read and write to monitor the process and be engaged in it.
