|
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=118065
) 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=118013
) 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=114988
) as subquery
Red Pepper
Red Pepper is an independent magazine of news, debate and culture for the green-left in the UK and internationally, providing a platform and discussion point for ideas and action.
Main Address
1B Waterlow Road
Archway
London NW19 5NJ
Main Telephone
44 0207 281 7024
Joined OneWorld
21.09.1999
Features
31.08.2005
Is micropower generation - which has been hailed as the environmental equivalent of the leap from the steam engine to the diesel locomotive - the solution to climate change?
Story link
30.08.2005
Part of east London will become a no-go zone in September as the capital once again plays unwilling host to the world’s largest arms fair.
Story link
Related topics/regions:
[United Kingdom]
08.07.2005
There can be no hesitation in condemning the bombing of innocent civilians. But our condolences and horror at the attacks should not blind us to the dangerous political uses to which they will be put, argues Oscar Reyes.
Story link
Related topics/regions:
[United Kingdom]
|
|
|
|
