|
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 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=158117
) 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=158160
) as subquery
SciDev.Net
<< Back to organisation profile
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
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
Related topics/regions:
[Peru]
Image: Peru is losing it's glaciers fast. These used to provide
22.02.2008
One million Indians will die every year in the 2010s as a result of tobacco consumption, a study predicts.
Story link
Related topics/regions:
[India]
| < 1 >
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
