|
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=136028
) 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=135602
) 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=135254
) 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=135170
) 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=135009
) as subquery
SciDev.Net
<< Back to organisation profile
Features
06.07.2006
China, the world's main producer of traditional and herbal medicines, has launched an international project to modernise the sector.
Story link
Related topics/regions:
[China]
27.06.2006
Climate change makes temperatures rise faster at high altitudes and could threaten water supplies for people depending on glacier run-off.
Story link
Image: Jacabamba glacier, Peru, in 1980 ŠLynas
21.06.2006
China has opened a new centre to assess its potential to generate wind and solar energy.
Story link
Related topics/regions:
[China]
20.06.2006
Scientists have genetically modified wheat and barley so the seeds still contain an important nutritional enzyme after cooking.
Story link
16.06.2006
The national academies of the G8 countries and Brazil, China, India and South Africa have called on the forthcoming G8 summit in Russia to lead the way for better global disease surveillance and more energy research.
Story link
<< Previous
| 16-25
| 26
| 27
| 28
| 29
| 30
| 31-40
| 41-50
| 51-60
| 61-70
| Next >>
|
|
|
|
