|
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=158017
) 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=157612
) 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=157522
) 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=157520
) 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=157548
) as subquery
Greenpeace UK
<< Back to organisation profile
Features
20.02.2008
With just a few days to go until the consultation process ends, London mayor Ken Livingstone is keeping up the pressure on the government to abandon plans to build a third runway at Heathrow airport.
Story link
Related topics/regions:
[United Kingdom]
09.02.2008
Greenpeace has launched an interactive virtual city showcasing how towns and cities across the UK are fighting climate change and enjoying a cleaner and more secure energy future - without relying on new coal or nuclear power stations.
Story link
Related topics/regions:
[United Kingdom]
07.02.2008
With soaring oil prices, companies including BP are looking to cash in on Alberta's tar sands.
Story link
07.02.2008
With soaring oil prices, companies including BP are looking to cash in on Alberta's tar sands.
Story link
06.02.2008
Greenpeace barricaded entrances to Lord's cricket ground this morning where UK Energy Minister Malcolm Wicks was due to deliver the opening speech for a major coal industry event.
Story link
Related topics/regions:
[United Kingdom]
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41
| Next >>
|
|
|
|
