|
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=152723
) 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=152552
) 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=152423
) 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=152316
) 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=152222
) as subquery
SciDev.Net
<< Back to organisation profile
Features
29.08.2007
Scientists are battling to stop damage and death caused by lightning strikes in the developing world, reports Anuradha Alahakoon.
Story link
23.08.2007
Improved nutrition cannot replace drugs in the treatment of people infected with HIV or tuberculosis, the Academy of Science of South Africa says in a report that effectively rebukes health ministry support for the use of beetroot, lemons and garlic to treat HIV.
Story link
Related topics/regions:
[South Africa]
Image: AIDS ribbon
Related links
20.08.2007
Bhutan, a country committed to environmental preservation, is facing a dilemma over reconciling conservation and economic development in the era of rapid globalization.
Story link
Related topics/regions:
[Bhutan]
Related links
17.08.2007
Almost unnoticed, Nepal is developing simple and cheap technologies that make the best of local resources and don't damage the environment, says Kunda Dixit.
Story link
Related topics/regions:
[Nepal]
14.08.2007
After years of legal wrangling and controversy, the South African authorities finally approved an anti-HIV drug trial. Sharon Davis and Christina Scott report.
Story link
Related topics/regions:
[South Africa]
Image: AIDS
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| < 6 >
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
