|
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=155071
) 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=155070
) 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=154876
) 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=154333
) 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=153394
) as subquery
Greenpeace UK
<< Back to organisation profile
Features
11.11.2007
How the world’s largest food, cosmetic and biofuel industries - through a growing demand for palm oil - are driving the wholesale destruction of peatlands and rainforests. (PDF report from Greenpeace.)
Story link
11.11.2007
How the world’s largest food, cosmetic and biofuel industries - through a growing demand for palm oil - are driving the wholesale destruction of peatlands and rainforests. (PDF report from Greenpeace.)
Story link
06.11.2007
It looks like the British government's nuclear ambitions have been dealt yet another major body blow, this time over the intractable issue of nuclear waste, writes Nathan.
Story link
Related topics/regions:
[United Kingdom]
20.10.2007
Tissues: as long as they do the job, what more do you need? But when you begin to consider where that paper has come from and its impact on forests, the tissue issue starts to become more interesting...
Story link
21.09.2007
Greenpeace blogger Nathan explains why Greenpeace has complained to the Market Research Standards Board about the role of the pollsters employed by the government to conduct a public consultation on nuclear power.
Story link
Related topics/regions:
[United Kingdom]
Related links
<< Previous
| 1
| 2
| 3
| 4
| < 5 >
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-40
| 41
| Next >>
|
|
|
|
