|
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
Panos London
Panos London is a part of a worldwide network of independent NGOs working with the media to generate public debate on the most critical global issues of today – trade & globalisation, HIV/AIDS, conflict, environment and gender. Central to Panos is airing the voices and views of ordinary people most affected by these issues.
Main Address
9 White Lion Street
London
N1 9PD
Main Telephone
020 7278 1111
Joined OneWorld
02.03.2006
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
|
|
|
|
