|
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=152117
) 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=151679
) 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=151562
) 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=151560
) 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=151547
) as subquery
SciDev.Net
<< Back to organisation profile
Features
09.08.2007
Attempts to adjust gross domestic product across China by accounting for its toll on the local environment are floundering.
Story link
Related topics/regions:
[China]
Related links
26.07.2007
Developing countries can learn from the experiences of Brazil and Thailand when it comes to sustaining access to anti-HIV drugs, says Médecins Sans Frontières.
Story link
Related topics/regions:
[Brazil]
[Thailand]
24.07.2007
UNCTADin uusimman raportin mukaan kehittyvien maiden on panostettava aiempaa enemmän tieteeseen ja teknologiaan. Tietoyhteiskunnasta jälkeenjääminen vaikeuttaa köyhyyden ja työttömyyden kitkemistä. Raportti väittää myös tieteeseen ja teknologiaan liittyvan kehitysavun olevan laadullisesta ja määrällisesti heikkotasoista.
Story link
Related topics/regions:
[e-governance]
[intermediate technology]
[international cooperation]
23.07.2007
Increasing the price of water used for irrigation will lead farmers to use water more efficiently and plant water-efficient crops, according to a study in India.
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| < 7 >
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
