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=38698
) 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=38701
) 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=38702
) 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=38755
) 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=38766
) as subquery
28.08.2002
Development is impossible unless all citizens have "the ability to make informed choices about their lives, their families and their societies," says a new briefing paper on the importance of providing education for all in developing countries. Try the LearningChannel for more info on education in the developing world.
27.08.2002
While expectations for meaningful success in Johannesburg are low, the diversity of civil society groups working in very different environments around the globe for the common ideal of a more sustainable and prosperous global system for all is exciting, says CIVICUS's Secretary General.
27.08.2002
A dispute over the need for two forums on indigenous people's issues within the UN shows that many countries are merely paying lip-service to the rights of indigenous people, says Bob Scott of the World Council of Churches.
23.07.2002
A British aid worker pinpoints deforestation as a key factor underlying poor health and vulnerability to drought and storms in Honduras. But since "development" projects often promote deforestation, how can the vicious cycle be stopped?
16.07.2002
Are global activists paying enough attention to grassroots movements? With the G-8 Summit recently concluded and the World Summit on Sustainable Development rapidly approaching, it's a good time to consider the balance between global and local activism.
