|
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 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=156857
) 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=156398
) 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=155653
) as subquery
SciDev.Net
<< Back to organisation profile
Features
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
15.01.2008
Peru will receive its first batch of XO laptops from the One Laptop per Child initiative in mid-February, despite pressure from rival company Intel to drop the order.
Story link
Related topics/regions:
[Peru]
28.12.2007
Cancer is becoming an increasing problem for developing countries, and issues commonly associated with poverty are making it worse, according to specialists taking part in an online seminar.
Story link
29.11.2007
The threat to global health and security posed by Indonesia's refusal to share samples of "bird flu" virus with the World Health Organization could be countered by the establishment of a vaccine stockpile in Asia, say two scientists.
Story link
Related topics/regions:
[Indonesia]
[Asia and the Pacific]
Related links
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
