|
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=158051
) 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=157443
) 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=157442
) 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=156958
) 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=156957
) as subquery
SciDev.Net
<< Back to organisation profile
Features
20.02.2008
Ninety per cent of farmers growing genetically modified crops are from developing countries, according to a report.
Story link
Image: Indian farmers burn genetically modified crop © Intercontinental Caravan (ICC)
05.02.2008
Crops in South Asia and Southern Africa are likely to be worst hit by climate change and need greater investment in agriculture development and adaptation strategies, say US scientists.
Story link
05.02.2008
Crops in South Asia and Southern Africa are likely to be worst hit by climate change and need greater investment in agriculture development and adaptation strategies, say US scientists.
Story link
Related topics/regions:
[Africa]
[Asia and the Pacific]
20.01.2008
Climate change threatens food crops across the world. Now scientists are re-focusing their efforts on crop resilience, rather than yields.
Story link
Image: Rice crops are the most vulnerable to global warming © Adrian Arbib
20.01.2008
Climate change threatens food crops across the world. Now scientists are re-focusing their efforts on crop resilience, rather than yields.
Story link
Image: Rice crops are the most vulnerable to global warming © Adrian Arbib
<< Previous
| 1
| < 2 >
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
