|
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=160952
) 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=160701
) 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=160660
) as subquery
Corporate Accountability International
Corporate Accountability International is a membership organization that protects people by waging and winning campaigns that challenge irresponsible and dangerous corporate actions around the world. For 30 years, Corporate Accountability International and our members have scored major victories that protect people's lives by forcing corporations like Nestlé, General Electric and Philip Morris/Altria to stop abusive practices.
Main Address
46 Plympton St.
Boston
MA
01609
Main Telephone
617 695 2525
Joined OneWorld
25.08.2007
Features
25.06.2008
A conference of U.S. mayors -- with support from restaurants, businesses, and public interest groups -- passed a resolution Monday to phase out municipal use of bottled water in favor of tap water.
Story link
Related topics/regions:
[United States]
29.05.2008
At a shareholders meeting just days before "World No Tobacco Day," the embattled cigarette giant Altria (formerly Philip Morris USA) has been urged to scale back its massive lobbying efforts against U.S. public health and tobacco control.
Story link
Related topics/regions:
[United States]
26.05.2008
The World Health Assembly made moves during talks held Friday to prohibit commercial interests from interfering in public health policies such as nutrition and tobacco control.
Story link
|
|
|
|
