|
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=160654
) 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=160587
) 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=157894
) 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=151691
) 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=149576
) as subquery
CIVICUS: World Alliance for Citizen Participation
<< Back to organisation profile
Features
23.05.2008
The hunger crisis and climate change present global peace and security challenges that require global solutions and take into account the needs of all peoples in all countries of the world, writes UN Representative Vicente García-Delgado.
Story link
Image: States must work together, not against each other, to feed their people and the world, says García-Delgado. © Greenpeace UKRelated links
19.05.2008
Mutabar Tojiboyeva has been named this year's recipient of the Martin Ennals Award, an annual commendation given by 13 prominent human rights groups. There is concern that the Uzbek activist could die in prison, where she has been held since protesting the Andijan massacre of 2005.
Story link
Related topics/regions:
[Uzbekistan]
15.02.2008
Kumi Naidoo, head of an organization advocating for greater citizen participation in the creation of a more just and equitable world, explains why he is signing on to a citizen's petition calling on decision-makers to ensure all people around the world have access to fair employment, wages, and social protections.
Story link
29.07.2007
'How much longer can we ignore this catastrophe and how will climate change affect the work of civil society?' asks Kumi Naidoo, CIVICUS Secretary-General?
Story link
Image: London's Trafalgar Square, November 2006 rally
24.05.2007
Activists detained for their human rights work will be profiled at a major civil society gathering in Scotland this week.
Story link
| < 1 >
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-12
| Next >>
|
|
|
|
