|
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=118592
) 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=118379
) 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=118297
) 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=118069
) 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=117771
) as subquery
SciDev.Net
<< Back to organisation profile
Features
09.09.2005
Carbon dioxide being released from the soil could be making climate change worse, warn scientists, and targets for man-made emissions of the gas will need an urgent rethink.
Story link
Related topics/regions:
[United Kingdom]
06.09.2005
India's plans to reduce costly petrol imports by using 'biofuels' have been hit by bureaucracy and supply problems, an international workshop has heard.
Story link
Related topics/regions:
[India]
05.09.2005
Satellite data has shown that levels of a key air pollutant above the Chinese capital Beijing are much higher than previously thought. And they are still rising, say researchers.
Story link
Related topics/regions:
[China]
31.08.2005
China's plans to attract "overseas Chinese" researchers to help drive its scientific progress are being undermined by the "irresponsibility" of those being hired, a senior US-based Chinese mathematician has warned.
Story link
Related topics/regions:
[China]
26.08.2005
The combined emissions of the greenhouse gas carbon dioxide from hundreds of new coal-burning power plants could exceed current UK emissions.
Story link
Related topics/regions:
[China]
<< Previous
| 36-45
| 46
| 47
| 48
| 49
| 50
| 51-60
| 61-70
| 71-80
| 81-90
| Next >>
|
|
|
|
