|
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=113641
) 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=112548
) 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=110783
) as subquery
Corporate Watch
Corporate Watch is a radical research and publishing group, based in Oxford, UK. It works with peace campaigners, environmentalists, trade unionists, journalists, MPs and other NGOs in campaigning against environmentally destructive, socially divisive and corrupt corporate projects and practices.
Main Address
16b Cherwell Street
Oxford
OX4 1BG
Main Telephone
01865 791 391
Joined OneWorld
01.01.1998
Features
20.06.2005
Scotland's eclectic history embracing free trade philosophy and radical protest creates an appropriate setting for the G8 summit. But modern history marks Scotland as a template of the corporate paradigm promoted by G8 governments.
Story link
Related topics/regions:
[United Kingdom]
03.06.2005
With typical optimism, Tony Blair sets off to persuade the Bush administration that the G8 summit must deliver something tangible for Africa and climate change. He may receive lesson one for G8 leaders - that the Group exists to look after itself and its corporate paymasters.
Story link
Related topics/regions:
[United Kingdom]
[United States]
05.05.2005
This is the first general election for which all corporate donations to political parties must be registered. Here is the list of major donors who can be blamed indirectly for the advertising and slogans we have endured over recent weeks.
Story link
Related topics/regions:
[United Kingdom]
|
|
|
|
