|
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=160148
) 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=155075
) 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=154387
) 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=152961
) 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=150410
) as subquery
Panos London
<< Back to organisation profile
Features
29.04.2008
Kenyans talk about how they feel they are denied basic human rights - views that are particularly revealing given the violence that followed the country's disputed election results.
Story link
Related topics/regions:
[Kenya]
12.11.2007
African migrants account for the greatest number of new HIV diagnoses in the UK in recent years, and a new report argues that by speaking out, community leaders and people living with HIV can raise awareness of the discrimination they experience.
Story link
Related topics/regions:
[United Kingdom]
24.10.2007
Good journalism can shape public opinion and act as a lever for policy change, raise awkward questions and champion the views of poor people. At a time when the world is struggling to achieve the Millennium Development Goals, a new report argues that many international donors are yet to appreciate that a vibrant, independent media is essential for development.
Story link
Related links
07.09.2007
Why aren't development efforts fulfilling the promises made in the Millennium Development Goals, asks the Panos Institute.
Story link
Related links
20.06.2007
"Drought is serious now... disease spreads; children fall ill, people can’t be well-nourished; living becomes expensive; the price of animals falls. There is nothing good about desertification". Chuqulisa tells her story.
Story link
Related topics/regions:
[Ethiopia]
Image: Chuqulisa: 'It is during acute droughts that we enter into conflict with other clans.'
| < 1 >
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-20
| 21-30
| 31-38
| Next >>
|
|
|
|
