|
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=160939
) 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=145680
) 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=141647
) as subquery
Hesperian
Hesperian is a publisher of popular health books promotes the health of poor people around the world by making health information accessible. They produce books and other educational resources for community-based health care.
Main Address
1919 Addison Street, Suite 304
Berkeley California 94704
Main Telephone
1-510-845-1447
Joined OneWorld
10.10.2001
Features
24.06.2008
From starting tree nurseries to properly disposing of solid waste, a new guide offers simple solutions to help communities around the planet improve their quality of life.
Story link
01.02.2007
Advances in science and technology are securing better health and longer lives, but only for a small fraction of the world's population. A new book (available free online) argues that the world lacks neither funds nor expertise to solve many of its key health problems.
Story link
28.10.2006
From Bolivia to the United States, Nigeria, and beyond, publics are challenging the notion that corporations can control the most basic resource needed to sustain life.
Story link
|
|
|
|
