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=141602
) 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=136578
) 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=135493
) 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=124007
) 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=107970
) as subquery
27.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.
18.07.2006
The widely-read book by US-based health organisation Hesperian Where There Is No Doctor is now online. The Hesperian Foundation's classic manual has helped people take lead in their own health care and organize to improve health conditions in their communities. Simply written and heavily illustrated, the book is available in many languages.
From pesticides to deforestation, from toxic waste to oil drilling, environmental destruction is making people sick all over the world. The Hesperian Foundation is currently developing A Community Guide to Environmental Health to help communities in their struggle for environmental health. Click here to view chapters and fact sheets from this book.
21.03.2005
While much attention has been paid to several of President Bush's recent high-profile nominations, one that has been largely overlooked has been that of Ann Veneman, the former Secretary of Agriculture chosen to be the new head of UNICEF. Veneman's history has been characterized by "privileging private profit above the public good," says a global public health coalition calling for a rethinking of both the appointment and the appointment process.
