|
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=159835
) 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=158988
) 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=158118
) as subquery
SciDev.Net
A free-access website devoted to science and technology issues relevant to the needs of the developing world.
Main Address
97/99 Dean Street
London
W1D 3TE
Main Telephone
+44 (0)20 7292 9910
Joined OneWorld
23.03.2002
Features
17.04.2008
The world risks "scientific apartheid" between rich and poor countries unless research and technology is better used to benefit the poor, says one of Africa's leading science experts.
Story link
19.03.2008
Using China's forests and 'idle land' to produce biofuels could pose a threat to biodiversity, experts warned at an international meeting.
Story link
Related topics/regions:
[China]
23.02.2008
The Peruvian government is trying to stimulate investment and large-scale use of renewable energies to reduce its dependence on petroleum.
Story link
|
|
|
|
