|
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=151183
) 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=151125
) 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=151037
) 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=150863
) 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=150862
) as subquery
SciDev.Net
<< Back to organisation profile
Features
12.07.2007
A relatively new drug has been found to be effective at treating HIV/AIDS in treatment-experienced patients, but experts in the developing world say it may be too costly for widespread use in resource-poor countries.
Story link
10.07.2007
Using insecticide-treated bednets to protect around half of older children and adults from malaria also protects more vulnerable groups such as children and pregnant women, a study has shown.
Story link
06.07.2007
Developing nations must pay more than mere lip service to WHO advice on linking HIV/AIDS and tuberculosis programmes, says Peter Mugyenyi.
Story link
02.07.2007
China's carbon emissions have shot up as energy demands soar. But will this change with new technology, asks Jane Wu?
Story link
Related topics/regions:
[China]
02.07.2007
China's carbon emissions have shot up as energy demands soar. But will this change with new technology, ask Jane Wu.
Story link
Related topics/regions:
[China]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| < 8 >
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
