|
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 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=143780
) 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=143626
) 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=141353
) as subquery
CIVICUS: World Alliance for Citizen Participation
<< Back to organisation profile
Features
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
13.12.2006
The existence of poverty in times of plenty not only breaches individuals' economic rights, but also curtails the enjoyment of most other rights as well, said an international civil society coalition reflecting on a recent visit to Zimbabwe. Human Rights Day is Sunday.
Story link
10.12.2006
The existence of poverty in times of plenty not only breaches individuals' economic rights, but also curtails the enjoyment of most other rights as well, said an international civil society coalition reflecting on a recent visit to Zimbabwe. Human Rights Day is Sunday.
Story link
Related topics/regions:
[Zimbabwe]
24.10.2006
Seventy-seven foreign non-governmental organizations operating in Russia, including many critical of the government, have been forced to suspend their activities after their registrations were rejected Thursday.
Story link
<< Previous
| 1
| 2
| 3
| 4
| 5
| 6
| 7
| 8
| 9
| 10
| 11-12
| Next >>
|
|
|
|
