|
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=130113
) 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=129805
) 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=128908
) 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=114712
) 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=114671
) as subquery
Panos London
<< Back to organisation profile
Features
30.03.2006
African farmers know little about the uses and risks of GM crops, says Ebenezer T. Bifubyeka, so he asks delegates at the Convention on Biological Diversity what they plan to do to spread awareness.
Story link
Related topics/regions:
[Africa]
24.03.2006
The governor of Brazil's Parana state vows to keep his state GM-free, in defiance of the federal government’s positive stance towards GM farming.
Story link
Related topics/regions:
[Brazil]
08.03.2006
The media play an important role in stimulating discussion in developing countries. Yet journalists asked by Panos say that the media have a poor understanding of the climate change debate and express little interest in it.
Story link
Image: Papuan family victim of 'flash flooding' © Adrian Arbib / Adrian Arbib
05.07.2005
A team of African journalists is filing news, views, and interviews from the G8 Summit.
Story link
Related topics/regions:
[Africa]
05.07.2005
The young man vaguely knew the name Blair, but could pronounce it only with difficulty.
“He is the chair of the Commission for Africa," Msechu told him.
"Sasa bwana Toni ndio mwenyekiti?" ("So Mr. Tony is the chair?") he asked, in Swahili.
"Yes."
"Which village was he born in?" the man asked.
It did not occur to him that the chair of the Commission for Africa is not from Africa but is a white British male.
Story link
Related topics/regions:
[Europe]
[Africa]
<< Previous
| 1
| 2
| < 3 >
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-38
| Next >>
|
|
|
|
