|
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 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
SciDev.Net
<< Back to organisation profile
Features
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]
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]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
