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=98744
) 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=92974
) 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=81224
) 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=76774
) 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=76225
) as subquery
30.11.2004
Solidarity will be the theme when members of civil society demonstrate outside Zimbabwean embassies on December 10th, International Human Rights Day. New legislation seeks to further restrict civil society in the country, which has seen a steady exodus of skilled professionals in recent months and years.
31.08.2004
The Civicus toolkit Developing a Financing Strategy includes key sections (pp5-7) entitled "Contextual Reality", "Financial Sustainability" and "Financial Autonomy" which together provide a clear summary of the interests of institutional donors and the challenge for civil society organisations to create a financial strategy which avoids overdependence on donor funding.
10.03.2004
A unique self-assessment by civil society groups around the world gauging four key dimensions of civil society activity is being undertaken by Civicus, which will hold a World Assembly of civil society organizations later this month in Botswana.
15.01.2004
Civicus, the largest association of global civil society groups, will hold its 5th World Assembly in Gabarone, Botswana in March on the theme, “Acting Together for a Just World.” Early-bird registration until Jan. 21.
06.01.2004
The Civicus World Assembly will take place in Gabarone, Botswana focusing on the theme of “Acting Together for a Just World." Click here to register.
