|
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=153615
) 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=153614
) 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=153621
) 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=153619
) 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=153428
) as subquery
Inter Press Service
<< Back to organisation profile
Features
28.09.2007
As the United Nations takes an increasingly dominant role in guiding the climate change debate, there is renewed interest in a longstanding proposal for the creation of an international court to try environmental crimes.
Story link
28.09.2007
As the United Nations takes an increasingly dominant role in guiding the climate change debate, there is renewed interest in a longstanding proposal for the creation of an international court to try environmental crimes.
Story link
27.09.2007
Amid a series of international conferences on climate change this week, the BBC has released a 21-nation survey in which two out of three respondents said they believed "major steps starting very soon" need to be taken to combat global warming.
Story link
Image: climate change, environment, rally protest, London, Trafalgar Square, November 2006
27.09.2007
Amid a series of international conferences on climate change this week, the BBC has released a 21-nation survey in which two out of three respondents said they believed "major steps starting very soon" need to be taken to combat global warming.
Story link
Image: People want action, not words
22.09.2007
The world indirectly gives "perverse incentives" to destroy tropical rainforests by demanding goods produced by intensive logging, says a leading environmental activist.
Story link
Image: Logging, Cameroon
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| < 10 >
| 11-20
| 21-30
| 31-40
| 41-50
| Next >>
|
|
|
|
