|
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=128553
) 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=128050
) 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=127621
) 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=127614
) 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=127359
) as subquery
SciDev.Net
<< Back to organisation profile
Features
01.03.2006
Scientists from across Africa and beyond respond to a suggestion by Kazhila Chinsembu that African nations should regain control over their biological resources and indigenous knowledge.
Story link
Related topics/regions:
[Africa]
Image: African research (Photo:USAID/R. Buckley)
22.02.2006
The periodic warming of the Pacific Ocean known as El Niño threatens food supplies for millions of Africans by reducing crops yields, say researchers.
Story link
Related topics/regions:
[Africa]
15.02.2006
A project that provided tap water to a remote part of Ethiopia improved women's lives, but also led to increased childhood malnutrition, say researchers.
Story link
Related topics/regions:
[Ethiopia]
Related links
15.02.2006
The only way for Africa to combat bird flu successfully is through an effective communication strategy that enables the public to prepare both for outbreaks in their poultry stocks and for a possible human pandemic, says Tom Egwang.
Story link
Related topics/regions:
[Africa]
Image: Bird flu: a wake-up call to the African media © . / SciDev.Net
13.02.2006
Peruvian farmers are getting access to important agricultural information thanks to the new practice of 'podcasting' — downloading audio broadcasts from the Internet then playing them on computers or portable music players.
Story link
Related topics/regions:
[Peru]
<< Previous
| 26-35
| 36
| 37
| 38
| 39
| 40
| 41-50
| 51-60
| 61-70
| 71-80
| Next >>
|
|
|
|
