|
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 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=155579
) 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=155332
) as subquery
SciDev.Net
<< Back to organisation profile
Features
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
27.11.2007
Brazil's ability to negotiate price reductions with pharmaceutical companies for patented HIV/AIDS drugs saved the country $1 billion between 2001 and 2005, according to a study.
Story link
Related topics/regions:
[Brazil]
Image: HIV/AIDS information materials being distributed to truck drivers by a local NGO and the local truck drivers union.(Credit: UNAIDS/A.Vasconcelos)
Related links
20.11.2007
The world must not miss its second chance to take a radically different approach to energy consumption, says this editorial review of a major International Energy Agency report.
Story link
Image: Developing alternative technology will not be enough
<< Previous
| 1
| 2
| < 3 >
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
