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=156770
) 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=156726
) 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=156725
) 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=156531
) 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=156529
) as subquery
15.01.2008
Gas flaring continued in 2008 in defiance of the Nigerian government’s warning that the act would not be tolerated in the new year. Forty percent of gas produced in the country -- almost 23 billion cubic metres -- is burned annually.
12.01.2008
The global economy is starting to reluctantly turn towards sustainability, according to the "State of the World 2008" report released by the Worldwatch Institute.
12.01.2008
The global economy is starting to reluctantly turn towards sustainability, according to the "State of the World 2008" report released by the Worldwatch Institute.
04.01.2008
Dan Bloom thinks it's time to figure out how to build self-sustaining cities in the polar regions because climate change will eventually make most of Earth uninhabitable.
04.01.2008
Dan Bloom thinks it's time to figure out how to build self-sustaining cities in the polar regions because climate change will eventually make most of Earth uninhabitable.
